Linux Blog

CrunchyFrog is a SQL client and schema browser mainly (but not solely) for the GNOME desktop. It's written in Python (PyGTK) and licensed under the GNU General Public License v3.

Features
    * Supports various databases (PostreSQL, MySQL, SQLite, Oracle, SQLServer, Firebird, Informix, MaxDB).
    * Lightweight user interface for daily tasks.
    * SQL editor with syntax highlighting, auto completion and SQL formatting.
    * Export results to CSV and OpenOffice.
    * Inspect database objects.
    * Supports multiple database connections at once (e.g. for switching between development and production environments).

Ubuntu / Debian:
To install CrunchyFrog add the following lines to /etc/apt/source.list:

deb http://ppa.launchpad.net/crunchyfrog/ppa/ubuntu jaunty main
deb-src http://ppa.launchpad.net/crunchyfrog/ppa/ubuntu jaunty main

Replace "jaunty" with "intrepid" or "karmic" if you're running Intrepid or karmic.

To import the repositories GPG key:
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 266d5f41c7f166d8

Finally to install CrunchyFrog run:
sudo aptitude update
sudo aptitude install crunchyfrog crunchyfrog-gnome