Recs.
Updated
SpecsUpdate
Pros
Pro Supports other database platforms
DataGrip is a multi-platform SQL IDE that is not limited to any particular database platform. DataGrip support a variety of systems out of the box, such as H2, MySQL, PostgreSQL, Oracle, and Microsoft SQL. Additionally, you can specify your own drivers for even further compatibility with your preferred database system.
Pro Powerful data editor
A powerful data editor lets you add, remove, edit, and clone data rows. Navigate through the data by foreign keys and use the text search to find anything in the data displayed in the table editor. All your changes are stored locally and can be submitted at once. Multiple fields can also be edited at once.
Pro Supports multiple languages
DataGrip is not a language-specific IDE. It supports a wide variety of languages by default, such as PostgreSQL, MySQL, Oracle, Microsoft SQL Server, Derby, H2, Sqlite, and many more.
You can also specify your own JDBC drivers to get support for additional platforms.
Cons
Con Performance can be slow/sluggish when working with high-volume databases
As with all other IDEs, DataGrip is powerful and thus requires more resources than usual. It can use up to several GB's of memory when working with high-volume databases, and this has an impact on performance if your system is not equipped to handle it.
Loading a 95.000 line SQL export, with 4 GB of RAM is super sluggish and execution is about 3 inserts per second, and it gets faster as it goes towards the end, up to about 10 inserts per second.