Sqlite - Revision history

Ron at 06:53, 8 December 2009

2009-12-08T06:53:48Z

Ron at 06:33, 28 June 2009

2009-06-28T06:33:49Z

Ron at 07:26, 13 January 2009

2009-01-13T07:26:50Z

Ron at 06:28, 30 November 2008

2008-11-30T06:28:38Z

Ron: 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. ...

2008-11-30T06:28:17Z

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

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.

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:

<code language="bash">
#!/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

</code>

← Older revision		Revision as of 06:28, 30 November 2008
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.

@@ Line 8: / Line 8: @@
 #!/bin/sh
 # vim: ft=sh :
 tarfile=`ls -t sqlite*.tar.gz|head -n 1`
 tardir=`echo ${tarfile}|sed -e's/.tar.gz//'|sed -e's/amalgamation-//'`
-−
-if [ "$tardir" == "" ]
+die() {
 then
 	# unpack the tar
 	tar xzvf $tarfile
-	pushd $tardir
+	cd $tardir
 fi
+if [ ! -f "sqlite3.pc.in" ]
 then
-	echo "Building SQLITE"
+	die 3 "This doesn't appear to be a SQLite distribution directory"
 fi
+)
-popd
+cd $oldpwd
 </code>

@@ Line 7: / Line 7: @@
 <code language="bash">
 #!/bin/sh
+# vim: ft=sh :
 tarfile=`ls -t sqlite*.tar.gz|head -n 1`
-tardir=`echo ${tarfile}|sed -e's/.tar.gz//'`
+tardir=`echo ${tarfile}|sed -e's/.tar.gz//'|sed -e's/amalgamation-//'`
-−
 if [ "$tardir" == "" ]
 then
@@ Line 22: / Line 23: @@
 fi
-if  configure --disable-tcl --enable-threadsafe CFLAGS="-O3 -s -mtune=i686 -fomit-frame-pointer -fmerge-all-constants"
 then
 	echo "Building SQLITE"
-	if  gmake sqlite3.dll
+	if  make
 	then
 		upx --best sqlite3.dll
 	else
 		echo "Could not build the DLL, sorry."
@@ Line 36: / Line 39: @@
 	echo "Could not configure, sorry."
 fi
 </code>