Best free IDE for your Database Needs

The eternal struggle

For all that use MacOS daily for work, it's not new that sometimes we have the trouble of finding a tool for a specific job that only exists for Windows. That is the case of using databases (specially Oracle databases). There are a lot of choices on the market, specially if you want to pay a few thousands of dollars (or Euros in my case).

But, for free there are less options and with less quality. Even the official Oracle SQL Developer is really heavy for the system and quite lame in my opinion.

DBeaver - Free Database Client

When I first heard about DBeaver, I went to search about it. I was quite impressed with the reviews, but still, an eclipse based software tends to be heavy (Java VM) and not very user friendly, as most of those softwares tend to be geek oriented. But still, with all the nice things people were saying about it, I gave it a try.

The first great thing is that you can connect to several database engines, not only Oracle. You can reach your MySQL, MariaDB or even a SQL Server Instance. That is great. And also NoSQL databases like Cassandra are supported on the paid version (if you need it).

The interface is user friendly and the software is not heavy at all to the system, even with multiple connections open. Besides all this, there are three main things that I love on this client:

• On Grid Edit ( no need to write code for simple CRUD operations )

• Relational Maps available

• Import and Export data to CSV

But you can give it a try. It's available for MacOS, Windows or Linux and UNIX (yes, UNIX).  Please leave a reply to this with your opinion or if you have any question regarding this.

You can see all the features here or download it here

Images are property of DBeaver WebSite.