Database Management

From Freehackers

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

[edit] Database Agnostic

[edit] 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.

[edit] 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.

[edit] Database Specific

[edit] phpmysql

The de-facto standard for mysql. Really cool.

[edit] SQLiteManager

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

[edit] sqliteman

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

[edit] sqlitebrowser

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