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
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).
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. =)