DBeaver: Free Database Manager for Oracle, SQL Server, MySQL, PostgreSQL, DB2

0 Comments
[yasr_overall_rating] [yasr_visitor_votes]




DBeaver is a freeware database manager to manage all databases that support JDBC drivers. DBeaver comes with a very intuitive and easy to use interface to connect to various database, run queries, create ERD, and manage database.

DBeaver has been tested with following databases: Oracle, MySQL, IBM DB2, SQL Server, PostgreSQL, Java DB, and more. Apart from supporting all these different type of databases, DBeaver is cross-platform, and works on Windows, Mac, as well as Linux. These aspects make it a really comprehensive database manager for all your simple database management needs.

DBeaver

Some of the features of this free database manager include:

  • Run SQL statements against database. You can run simple SQL statements, as well as run SQL scripts.
  • DBeaver comes with syntax highlighting feature for SQL statements. What makes DBeaver speccial is that syntax highlighting automatically changes based on the database you are working with. DBeaver is quite intelligent in that respect.
  • DBeaver also supports auto complete feature in SQL editor.
  • DBeaver is quite focused on memory management, and uses very less RAM while running on your system. Even the resultset window of this free database manager is memory optimized to use less system resources.
  • One great feature of DBeaver is that all database operations are done in non-blocking mode. This means that if you are running an operation and remote database does not responds for a long time, it will not hang DBeaver. I work on TOAD on almost daily basis, and really wish it had this feature (also check out TOAD alternatives).
  • Comes with a feature to easily create E-R diagrams of the database.
  • DBeaver comes with special support for BLOB and CLOB datatypes so that you can easily view such objects in your resultset windows. For example, if some column of your database contains images in CLOB format, you will be able to see those images with this free database manager.
  • You can search for database objects, such as tables, procedures, constraints, etc.

Other similar software we reviewed earlier include TORA, and Database Browser.

DBeaver is under continuous development, and developer of this free database manager is adding more features to it. If the progress of this free database manager continues like this, I am sure it will be one of the best free database manager down the line.

Download DBeaver free.

[yasr_overall_rating]
[yasr_visitor_votes]
Works With: Windows, Mac, Linux
Free/Paid: Free

Leave A Reply

What do you think?
  • 0
  • 0
  • 0
  • 0
  • 0
  • 0
6 Comments
  • Latest
  • Oldest
  • Hottest
Ishan2011-01-20

@Peter: Nice list, thanks 😃 I have RDtabs also covered here (love it). SoapUI looks especially interesting, but I don’t have a setup to test it. Do you want to write about it based on your experience with it?

Peter2011-01-20

hmm, as far as i remember, Donationcoder.com is already on your list and Nirsoft too… I’m using RDTabs for Remote Desktop (http:www.avianwaves.comTechToolsRDTabs), Putty Connection Manager (seems to be a stalled project at the moment, really sad 😦 , now hosted on sourceforge, but no files available for about one year, originating website is down), mTail (Tail for Windows: http:ophilipp.free.frop_tail.htm), soapUI (for testing of SOAP WebServices, http:www.soapui.org). Most other tools are licensed shareware or commercial software.

Ishan2011-01-19

@Peter: I am glad you like my blog 😃 Any other free software that you use know about that I have not covered in this blog yet? I would like to include that here.

Peter2011-01-19

@Ishan: there is a Free Edition of DBVis, and some versions ago there were enough nice features to keep an eye on it. But you are right: i just looked at the feature comparison, and it seems to lack more features now. But maybe it is still worth a look 😉

And i’m glad i could help you a bit with TOAD 😃 Only a small reward for your great work with this blog, which has lead me to some real freeware gems! 😃

Ishan2011-01-19

@Peter: Thanks for that tip, didn’t know that. Regarding the tool that you mentioned, it is not free. My favorite one nowadays is Oracle’s SQL Developer - it is very neat.

Peter2011-01-19

I think you should have a look at Toad Options -> Oracle -> Transactions: check “execute queries in threads” and “use a seperate Connection when TOAD itself is generating transactions” helps a lot 😉 (but generates many sessions on the DB server, which some DB admins dislike…)

If you want to have a look at another Java based DB tool: www.dbvis.com

Powered by Waline v3.5.5