I'm going to have to build an app in PHP which does this, but before I do that I'd like to connect to it with a client tool just to see how things are structured and such. I'm afraid I don't know ...

Each database is different, so connecting to Postgres is a little different from connecting to MySQL, which is different from connecting to SQLite. Watch out for the following pitfalls when doing JDBC ...