I'm managing SQLite, MySQL and PostgreSQL databases and want a tool for this locally

Question

I develop web applications on Mac OSX in SQLite, MySQL and PostgreSQL and these are then put on the webserver. I want to be able to take the brunt out of looking at the terminal locally when dealing with these databases - is there any software available (free or otherwise) that can handle all three of these database technologies in a GUI for the Mac that is actually decent and worth it?

Answer 1

Navicat is king, but does it do SQLite...I am not sure

Answer 2

You could just use any SQL tool that can handle JDBC connections (such as any of the various Java SQL tools). All three DBMS have JDBC drivers.

See e.g. https://stackoverflow.com/questions/1644893/recommendation-for-jdbc-sql-client-tool

Answer 3

You can use RazorSQL.

I'm looking for something a bit better/cheaper than this, but haven't found it so far.

Answer 4

You can use FREE tool - Valentina Studio, it works as with SQLite, so with postgreSQL and mySQL/mariaDB http://www.valentina-db.com/en/valentina-studio-overview