Difference between revisions of "Sqlite"
From RonWareWiki
 (New page: I use the excellent [http://sqlite.org/index.html SQLite] relational database for all sorts of projects.  My vim setup as well as my [http://ronware.org/reva/ Reva Forth] utilize it.  ...)  | 
				|||
| Line 1: | Line 1: | ||
| + | [[category: tools]]  | ||
| + | |||
I use the excellent [http://sqlite.org/index.html SQLite] relational database for all sorts of projects.  My [[vim]] setup as well as my [http://ronware.org/reva/ Reva Forth] utilize it.  | I use the excellent [http://sqlite.org/index.html SQLite] relational database for all sorts of projects.  My [[vim]] setup as well as my [http://ronware.org/reva/ Reva Forth] utilize it.  | ||
Revision as of 08:28, 30 November 2008
I use the excellent SQLite relational database for all sorts of projects.  My vim setup as well as my Reva Forth utilize it.
Here is a script I created to help me rebuild SQLite as new versions are available. The script runs on Windows using the 'MSys' bash shell:
- !/bin/sh
 
tarfile=`ls -t sqlite*.tar.gz|head -n 1`
tardir=`echo ${tarfile}|sed -e's/.tar.gz//'`
if [ "$tardir" == "" ]
then
	# no tar directory
	echo "We are presumably in the tar directory already"
	pushd .
else
	# unpack the tar
	tar xzvf $tarfile
	pushd $tardir
fi
if  configure --disable-tcl --enable-threadsafe CFLAGS="-O3 -s" 
then
	echo "Building SQLITE"
	if  gmake sqlite3.dll 
	then
		upx --best sqlite3.dll
		cp sqlite3.dll /c/rw/vim7/bin/sqlite3.dll
		cp sqlite3.dll /c/rw/reva/bin/sqlite3.dll
	else
		echo "Could not build the DLL, sorry."
	fi
else
	echo "Could not configure, sorry."
fi
popd