Monday, April 14, 2014

Database Magic on the GNU/Linux Desktop

Is your preferred desktop GNU/Linux? If it is, then you may be as excited as I to discover Kexi, a database program that works on GNU/Linux distributions (e.g. Ubuntu, Debian, etc.). I was thrilled to discover a program that would not only interface with local copies of data, but also with MySQL databases.
sudo apt-get install kexi - this command works on Debian/Ubuntu systems to install Kexi
Get Kexi Now!

I needed to be able to run SQL queries on 22K row CSV file, and, since I was on CrunchbangLinux, I didn't see an easy way of accomplishing that. Kexi to the rescue! What I especially liked was the ability to run SQL queries:
SELECT submit_date, campus, technician, computer_type, request_type, requestor, room, request FROM report WHERE report.submit_date <= '2014-04-13' AND report.campus = 'ArmstrongCampus' AND report.submit_date >= '2013-08-01'
Watch these screencasts to get a feel for it, here are some screenshots,

It is not yet available for download on Mac and Windows...aww.

What features Kexi currently offers?
Read the Kexi Features page, look at the screenshots. Use the Kexi handbook.
Find an announcement for the newest release and look at the "Unsupported features" document added for this release.
How to use database servers with Kexi?
First, note that you do not need to use database servers at all - you can use file-based builtin database server built into Kexi (SQLite-based, very much like MS Access, but a bit more robust).

If you want database servers, PostgreSQL and MySQL are supported. Create a new blank database project on server using Kexi's startup dialogs. Kexi will ask you to define connection data with connection dialog and select database name, so you will be able to just pick this predefined connection later. You can also use command line options to create and drop database projects. Also read here (October 2004).

- Kexi assumes the account of the database server you use has enough permissions for creating a new database and use it. You may want alter the permissions (at least temporarily) using administration tools dedicated for your database server (Kexi itself does not contain such tools). If you're unsure how to do this, ask your database administrator or support.
One thing I noticed I couldn't do was delete via SQL command. I will have to investigate this further.

View my Flipboard Magazine.

Make Donations via PayPal below:

Everything posted on Miguel Guhlin's blogs/wikis are his personal opinion and do not necessarily represent the views of his employer(s) or its clients. Read Full Disclosure

No comments:

The Courage to Lead