Randell's Tech Blog

Install SQLite Database Browser on Fedora

Posted: 25 Jul 2009 12:05 PM PDT

What is SQLite Database Browser?

From the SQLite Database browser home page:

SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. Controls and wizards are available for users to:

Create and compact database files

Create, define, modify and delete tables

Create, define and delete indexes

Browse, edit, add and delete records

Search records

Import and export records as text

Import and export tables from/to CSV files

Import and export databases from/to SQL dump files

Issue SQL queries and inspect the results

Examine a log of all SQL commands issued by the application

Install SQLite Database Browser

First, you need to download the platform-independent version of SQLite Database Browser from http://sourceforge.net/projects/sqlitebrowser/files/.

Extract the downloaded tar.gz.

Once extracted, you need to make sure that you can build the source. One of the build requirements for SQLite Database Browser, according to the SQLite Database Browser Building Instructions and Requirements, is the presence of QT. From this (http://forums.fedoraforum.org/showthread.php?t=111264) thread, it says that you only need to install the QT libraries and QT development interfaces. To do that, execute this command from your terminal (as root, of course):

yum install qt-devel qt-config

After running the command, I was still unable to qmake. Further googling led me to this thread: http://forums.fedoraforum.org/showthread.php?t=83141. So in your terminal, execute;

yum groupinstall 'KDE Software Development'

After that, you may now run

qmake

and then

make

from the extracted SQLite Database Browser directory. This will generate the sqlitebrowser binary file inside the sqlitebrowser sub-directory that you can run by simply double-clicking. Running it should show the SQLite Database Browser window (see screenshot).

Screenshot of SQLite Database Browser on Fedora 10

You may also check out screenshots of SQLite Database Browser 1.0 running on different platforms from http://sqlitebrowser.sourceforge.net/screenshots.html

Notes: The installation procedure mentioned was only tested by the author using Fedora 10. Please let me know if it worked on your machine. =)

Tags: Fedora 10, Linux, make, qmake, QT, SQLite Database Browser

Visits

Online

Partners

Blog Archive