![]() ![]() It’s more restricted in its range of databases (you only get MySQL/MariaDB, SQL Server and PostgreSQL) but for many, that’s enough. 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. I think a lot of the speed is because it uses its own drivers and connects directly, not through ODBC. 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. When you’re working with both live and development databases, being able to move large blocks of data easily is very important. 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). DBeaverĭBeaver is another Java-powered SQL client like the JDBC connector, it has a large set of databases it can connect to. There’s an Enterprise version, which includes NoSQL database support (Cassandra, MongoDb and Redis), but the community edition is the one I’ve examined. ![]() 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. It worked with that database flawlessly, and I was impressed. While I still prefer HeidiSQL, I would be very happy to use DBeaver if the opportunity arose. One thing to note: DBeaver doesn’t install drivers at the start, but fetches them as you need them (this is very “Eclipse-like”). ![]()
0 Comments
Leave a Reply. |