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. =)
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
@Temperage, yeah, I didn’t have to install the entire KDE but I was in a hurry when I was installing the database browser at that time and google wasn’t helping much so I settled for the easiest way.
You can try this link regarding your problem in make: http://www.linuxforums.org/forum/programming-scripting/167385-c-code-link-error-need-help.html
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.
@Temperage, were you able to build it? I tried building it on Fedora 15 but I ended up in the same error message that you got.
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.
Awesome! Thanks for the additional info!
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.
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.
Thank you, Oscar. That really did work beautifully.