Re: SQL Server for ARM

[Simon Poole <simon.armlinux@xxxxxxxxxxxxx>]

Simon Poole wrote:
> I've recently been playing with SQLite, which is absolutely tiny and 
> looks superb.  I've not tried it on ARM yet and I've not tried 
> cross-compiling.  Looks good on x86 though!

Okay, that was a bit of a cop out.  I've cross-compiled it and installed 
it and it seems to be fine on ARM.

I used the following to configure and build:

patch -Np1 ../sqlite-3.0.8-autoconf.patch
autoreconf
export config_BUILD_CC=gcc
export config_TARGET_CC=arm-9tdmi-linux-gnu-gcc
export config_TARGET_RANLIB=arm-9tdmi-linux-gnu-ranlib
export config_TARGET_AR=arm-9tdmi-linux-gnu-ar
./configure --prefix=/tmp/rootfs --without-tcl
make
make install

Patch attached.

Note that there is a superb intro/tutorial on Freshmeat, with examples 
of command-line use, and C and C++ API use:
http://freshmeat.net/articles/view/1428/

--
Simon Poole
www.appliancestudio.com

--- sqlite-3.0.8.orig/configure.ac	2004-11-08 16:24:53.825206392 +0000
+++ sqlite-3.0.8/configure.ac	2004-11-08 16:41:38.016546104 +0000
@@ -490,6 +490,7 @@
 #
 AC_MSG_CHECKING([readline header files])
 found=no
+if false ; then
 if test "$config_TARGET_READLINE_INC" != ""; then
   TARGET_READLINE_INC=$config_TARGET_READLINE_INC
   found=yes
@@ -514,6 +515,7 @@
     fi
   done
 fi
+fi
 if test "$found" = "yes"; then
   if test "$TARGET_READLINE_LIBS" = ""; then
     TARGET_HAVE_READLINE=0
--- sqlite-3.0.8.orig/Makefile.in	2004-11-08 16:58:29.971705536 +0000
+++ sqlite-3.0.8/Makefile.in	2004-11-08 16:58:50.977512168 +0000
@@ -34,7 +34,7 @@
 exec_prefix = @exec_prefix@
 libdir = @libdir@
 INSTALL = @INSTALL@
-LIBTOOL = ./libtool
+LIBTOOL = ./libtool --tag=CCX
 RELEASE = @ALLOWRELEASE@
 
 # libtool compile/link/install

-------------------------------------------------------------------
Subscription options: http://lists.arm.linux.org.uk/mailman/listinfo/linux-arm
FAQ/Etiquette:       http://www.arm.linux.org.uk/armlinux/mailinglists.php