Database Management

See also Replacement for MS Access

Database management is about "how do I browse my databse, change it, import, export, and such". Most databases come with a command line tool ('mysql', 'sqlite3', 'pgsql'....), but we focus on graphical frontends here

Contents 1 Database Agnostic 1.1 knoda 1.2 qtsqlview 2 Database Specific 2.1 phpmysql 2.2 SQLiteManager 2.3 sqliteman 2.4 sqlitebrowser

Database Agnostic

knoda

Can be used to edit sqlite3, mysql and such... Based on Qt3, no release since end of 2006. I was able to open and change a sqlite3 database though.

qtsqlview

A rich-client based on qt4. Quite old (2006-10-10) and not on gentoo, failed to compile with gentoo/qt-4.3.3 (i had to s/assert/Q_ASSERT) Based on qt4, it works flawlessly. I managed to connect/browse sqlite3 and mysql db.

Database Specific

phpmysql

The de-facto standard for mysql. Really cool.

SQLiteManager

Web-based tool for sqlite. It's ok, but it's web..

sqliteman

Qt4, gpl, not yet in gentoo (only in some overlay). Seems great, but untested.

sqlitebrowser

Based on qt3, has a lot of bug (display bugs most importantly), unmaintained since 2005, though still useful.