Install SQLite Database Browser on Fedora

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

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

10 thoughts on “Install SQLite Database Browser on Fedora”

  1. You did not have to install the KDE monster to have qmake. Most likely just had to run it like /usr/lib/qt4/qmake if you had qt4 installed, or create a symlink to /usr/bin. I got it past the qmake stage, but I am stuck at running make. Did anyone had any luck building it on later Fedora releases.
    Here is what I am seeing after running make. Any suggestions?

    /usr/bin/ld: .obj/sqlite3.o: undefined reference to symbol ‘dlopen@@GLIBC_2.1′
    /usr/bin/ld: note: ‘dlopen@@GLIBC_2.1′ is defined in DSO /lib/libdl.so.2 so try adding it to the linker command line
    /lib/libdl.so.2: could not read symbols: Invalid operation
    collect2: ld returned 1 exit status

  2. Thanks buddy, but I tried the solution described in that forum, and still no luck. I just want to know if there are any champs out there that managed to build that evil script. Please step forward and explain it to us mortals, step by step, noob-style.

    Here is what I tried so far:
    1. At a minimum Install “qt-config” and “qt-devel” packages
    2. Extract “sqlitebrowser_200_b1_src.tar.gz” and cd into the extracted directory
    3. $ qmake-qt4
    4. $ gedit sqlitedb.h to replace all instances of “DBBrowserField() : name( 0 ) { }” with “DBBrowserField() { }”
    5. $ gedit Makefile to change “CFLAGS = -ldl -lpthread -pipe -Wall -W -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector –param=ssp-buffer-size=4 -m32 -march=i686 -mtune=atom -fasynchronous-unwind-tables -DQT_NO_DEBUG -DQT_SHARED -DQT_TABLET_SUPPORT -DQT_THREAD_SUPPORT”
    6. $ make

    There were somewhere around 20 variations of step 5 that I did. All the permutations of using -ldl -lpthread with quotes and without. Still get the same error as above.

  3. I was able to build the GIT source but the program had no functionality whatsoever. So I ended up booting from Ubuntu liveCD and installing sqlitebrowser available from the repos.

    If you want to run the sqlitebrowser under Fedora. you can install qt3 and use the pre-compiled binary they include with the “sqlitebrowser-1.3-i386.tar.gz”. I tried it and it works on my FC14. You do not have to uninstall qt4 in order to make it work.

    I was unsuccessful building from source either 1.3 or 2.0 releases. I think sqlitebrowser is left to die its natural death, as qt3 is becoming outdated, and the qt4 port is not functional.

  4. Thanks for the tip Temperage, this workaround worked for me too on a Fedora 15 x86_64 release, although I had to install the i686 version of the qt3 package.

  5. For Fedora 14 x86_64, you can also use sqlite-devel package instead of the sqlite3 source included. It solved an issue with not getting results from sql.

    1. yum install qt3 sqlite-devel qt-devel
    2. tar xzf sqlitebrowser_200_b1.src.tar.gz; cd to the extracted directory
    3. qmake-qt4
    4. gedit Makefile and remove all references to sqlite_source/sqlite3.c, sqlite3.o; set “LIBS=… -ldl -lsqlite3″
    5. make

    Works beautifully.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>