> > Go to the website and download three source files (all conveniently > packaged in a tarball on the download page): > > sqlite3.c > sqlite3.h > shell.c > > Then run: > > gcc -static -o sqlite3 -DSQLITE_THREADSAFE=0 sqlite3.c shell.c -ldl > > Then move the resulting stand-alone, dependency-free executable > "sqlite3" to someplace on your $PATH. > > > D. Richard Hipp > d...@hwaci.com >
Thanks. That works fine! I now have sqlite3 working fine. It would be nice to know why the version from the ubuntu repository caused the seg fault but I don't have time to investigate that. I got this when I did the compile: ~/Temp/sqlite3/sqlite-3.6.17 $ gcc -static -o sqlite3 -DSQLITE_THREADSAFE=0 sqlite3.c shell.c -ldl /tmp/ccHIYQp3.o: In function `unixDlOpen': sqlite3.c:(.text+0xa2d0): warning: Using 'dlopen' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking /tmp/cc0XLw8q.o: In function `find_home_dir': shell.c:(.text+0x63ec): warning: Using 'getpwuid' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking but I have not had any problems running sqlite3 (including using it to access and edit the firefox cookies which is very handy for development purposes). Thanks again, Paul Whipp www.paulwhippconsulting.com.au Tel: +61 410 545 357 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
