While I still prefer HeidiSQL, I would be very happy to use DBeaver if the opportunity arose. ![]() It worked with that database flawlessly, and I was impressed. There’s a large list of databases to try from the connection wizard I chose SQLite, as I have a 600 MB database created for a project a few years back. There’s an Enterprise version, which includes NoSQL database support (Cassandra, MongoDb and Redis), but the community edition is the one I’ve examined. DBeaverĭBeaver is another Java-powered SQL client like the JDBC connector, it has a large set of databases it can connect to. HeidiSQL is for Windows but can be used elsewhere via the Wine Emulator on Linux and Mac (but to be honest, I’d just as soon use either Squirrel or DBeaver). When you’re working with both live and development databases, being able to move large blocks of data easily is very important. Particularly good is the import/export features and batch import: You can run large SQL files (such as backup exports) directly without loading them into the query window.Īnother nice feature: When you are writing a SQL query, the currently selected table’s columns are shown in another window along with SQL functions and keywords, plus your own snippets. I think a lot of the speed is because it uses its own drivers and connects directly, not through ODBC. I’ve found it very fast, which is vital for projects such as a 29-million-rows table a select count (*) SQL command against MariaDB running on my PC takes around two minutes. It’s more restricted in its range of databases (you only get MySQL/MariaDB, SQL Server and PostgreSQL) but for many, that’s enough. Just over half the age of Squirrel, HeidiSQL has been my personal favorite for the past three years. For breadth of coverage (thanks to JDBC), it’s highly recommended, but watch how many sessions you run the more memory you have, the better. A couple of times, it ran out of memory, causing issues with live databases that earned it the red card. (If you’re keeping score at home, Sybase was also the ancestor of SQL Server.) Squirrel ticks the boxes for all the major databases ( Oracle, DB2, Informix, Ingres, SQL Server, SAPDB and Sybase), plus many more, and has a 17-year track record.īut Squirrel was eventually banned in production at the bank, mostly because of its ability to support simultaneous sessions with multiple databases. Sybase was also used extensively (it wasn’t exactly the most popular database), and Squirrel is one of the few clients that can talk to it. Squirrel was a popular choice of client in the bank where I worked five years ago, as they preferred Java, and that’s what it’s written in. I’ve used HeidiSQL and Squirrel for a while, so let’s start with the latter. The statista website suggests that global revenue from commercial databases will continue to decline in the years ahead.įor this article, the five SQL clients I chose are Squirrel, HeidiSQL, DBeaver, Tora and OmniDB. ![]() Reasons include service providers making greater use of open-source databases, plus the rise of alternatives such as NoSQL. This is particularly relevant as the impact of the cloud (i.e., SAAS) is beginning to be felt in the commercial database market. ![]() There are some nice commercial IDEs such as dbArtisan and SQL Server’s Management Studio, but IDEs is one area where open-source can do just as well (or in some cases, even better). Yes, it’s possible to do everything in SQL from the command line but creating or even maintaining databases and tables that way is an exercise in masochism. The work environment is very comprehensive but is intended only for advanced and professional users.įor database experts, RazorSQL is a powerful manager that offers a wealth of capabilities in a lightweight and fast package.If you’ve done a lot with SQL, you’ve probably used some form of SQL IDE to help you complete that work. RazorSQL also includes a powerful SQL script editor. You can query, compare tables, import or export data, create backup of tables or an entire database, cut or merge files, obtain detailed information on the DB, look at logs and more. RazorSQL is well made, light and reacts very quickly to commands.
0 Comments
Leave a Reply. |