![]() ![]() The free version is enough for database access, browsing and querying.īeing Java based, it requires JDBC drivers to work with different database engines. Now, let me list some of the advantages I really appreciate: ![]() If you are looking for a free tool that can work with a variety of database engines, possibility for custom support of unknown or commercial vendors (by manually providing the drivers in their JDBC-standard implementation), simple user interface and a reason to install JRE on your machine, then behold the almighty DB Visualizer!īesides being a little mocky at times in my description, I find this software valuable and suitable for nearly all of my needs. For instance, was unable to successfully call MySQL stored procedure definition script due to statement delimiters messing up. It allows you to execute only one single statement per query!!! This can become problem for complex scripts with strict sequential logic and specific syntax. Also, DbVisualizer can launch multiple instances, which with a different query in each window. The free version limits the number of open query windows to ONE! This seemed a serious drawback at first, but it fairly compensates with back and forward navigation, that allow you to change the query to any recently open file. I cannot recall similar issues with PostgreSQL, but it does not mean there could not be any. I had the "pleasure" of working a lot with IBM Informix using this software and the syntax highlighting of keywords and even specific dialect constructs was missing or incorrect, but bear in mind that Informix is not well supported in general. The syntax highlighting may not support all the language features. Remember, though, I use the free version on Linux, so your experience with it on a Mac will hardly be any worse, and I am not complaining at all. Your list of requirements is basic enough as well, so I assume you can do without luxuries. In other words - do not expect too much from it. Using the free version, I find it too basic and feature-stripped (by the time writing of this post), compared to pgAdmin, MySQL Workbench and quite far behind Microsoft SQL Server Management Studio - the other database tools I have experience working with. Having Java involved could reflect on the memory consumption of your machine, thus affecting the computer performance. It runs on Java, so you need to have a Java runtime pre-installed, or download the heavier executable which has an embedded JRE. PostgreSQL is supported by default, so this will not bother you. You may require to manually import database JDBC drivers for commercial servers, it is possible with the GUI though. That free version seems to support all items of your list though.īuilt-in support only for some of the database engines. It is commercial, although free version with limited functionality is available. ![]() Still there are some drawbacks to it, I'll list the few I am considering important and the ones I have personally rated as downsides: It has Query window that allows executing queries and examining the results It does support listing and browsing databases and database infrastructure. I have experience with the free Linux version of it, but the website states it supports the 3 major OS-es.Īccording to the features list, it does support SSH tunneling for known_hosts and has private key support (see Connection Management section) It is written in Java, which means it is cross-platform compatible. This is a database manipulation tool that supports a large number of database systems, including PostgreSQL. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |