linux poison RSS
linux poison Email

SQL client and front-end for multiple database- crunchyfrog

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



1 comments:

Unknown said...

version 0.4.0 has a bug with mysql does not support port number on connect when datasource is connected. version 0.4.1 is requited. I could not find a stright download for that, it seems one should manualy patch, see issue 70 and issue 139 july 29 2009 on crunchyfrog website.

This page is also missing an important step, for mysql to install python to mysql db module. There is fine print on the crunchyfrog installation instruction... that is:

sudo apt-get install python-MySQLdb

Post a Comment

Related Posts with Thumbnails