soaked and soaped

Recently, when I switched from Ubuntu Dapper Drake to Edgy Eft, I also had to set up my development environment again.
This time I decided to use SQLite3 for Rails development on my notebook instead of MySQL.

I used to administer my databases with phpMyAdmin or with the Data Perspective in RadRails. Now my problem was, that the SQLite JDBC driver which RadRails uses sucks and the Data Perspective wont work.

So I looked for a solution to easily manage the SQLite databases from my projects with RadRails.
Here it is:

Install rSQLiteGUI

rSQLiteGUI is a very simple but useful graphical interface to manage SQLite databases written in Ruby and using GTK2.

To install it, just download the latest version from here and extract the archive to a directory. Make sure rsqlitegui.rb is executable.

Configure RadRails to work with rSQLiteGUI

In RadRails you can define File Associations. So associate the *.db files with rSQLiteGUI:

• Open the preferences window with Window → Preferences…
• Go to General → Editors → File Associations
• Click Add… next to the File types list and enter *.db
• Select the *.db entry in the File types list
• Click Add… next to the Associated editors list
• Select External Programs
• Click on Browse and select the rsqlitegui.rb file.

Done! Now you can view or edit a SQLite database just double clicking on it in the Rails navigator.