SQLite integeration for Linux

NOTE: What follows works with a clean build of TGE 1.3, under Gentoo it should work as-is for other distros as well.

Ok to start with you will need to get SQLite installed on your system, the easiest way to do this is to check with your distro for an RPM if you are running an RPM based distro.
If you are unsure or unable to find an RPM for your distro, then go to http://www.rpmfind.net/ and do a search there for SQLite.

Gentoo users only need to emerge sqlite on the command line
Debian would be apt-get sqlite (If I'm not mistaken)

We will use 2.x version SQLite, since that is what I currently have running. If for some reason you REALLY want a 3.x then you will need to do alot more editing.

Once you have it installed on your system open a console window

mkdir ~/Torque/lib/sqlite
cp /usr/include/sqlite.h ~/Torque/engine/console
cp /usr/lib/sqlite.a ~/Torque/lib/sqlite/sqlite_DEBUG.a

open your favorite text editor edit ~/Torque/engine/targets.torque.mk

Find

SOURCE.CONSOLE=\
	console/compiledEval.cc \
	console/compiler.cc \
	console/console.cc \
	console/consoleDoc.cc \
	console/consoleFunctions.cc \
	console/consoleInternal.cc \
	console/consoleLogger.cc \
	console/consoleObject.cc \
	console/consoleTypes.cc \
	console/gram.cc \
	console/scan.cc \
	console/scriptObject.cc \

After console/scriptObject \
add

console/SQLiteObject.cc \

In the same file look for

INCLUDES_BASE = -I../lib/zlib -I../lib/lungif -I../lib/lpng -I../lib/ljpeg -I../lib/directx8 -I../lib/vorbis/include

replace with

INCLUDES_BASE = -I../lib/zlib -I../lib/lungif -I../lib/lpng -I../lib/ljpeg -I../lib/directx8 -I../lib/vorbis/include -I../lib/sqlite

Continuing
Look for

$(PRE.LIBRARY.LIB)ljpeg$(EXT.LIB) \
	$(PRE.LIBRARY.LIB)lpng$(EXT.LIB) \
	$(PRE.LIBRARY.LIB)lungif$(EXT.LIB) \
	$(PRE.LIBRARY.LIB)zlib$(EXT.LIB)

Replace with

$(PRE.LIBRARY.LIB)ljpeg$(EXT.LIB) \
	$(PRE.LIBRARY.LIB)lpng$(EXT.LIB) \
	$(PRE.LIBRARY.LIB)lungif$(EXT.LIB) \
	$(PRE.LIBRARY.LIB)sqlite$(EXT.LIB) \
	$(PRE.LIBRARY.LIB)zlib$(EXT.LIB)

The above is in 2 seperate places in the script, you need to replace it in both places.
Save your file and exit.

Now as you noticed there was a file called SQLiteObject.cc, we will also be using SQLiteObject.h both of which are in the download from the other SQLite tutorial, which is meant for windows users.
The download is at
http://www.garagegames.com/uploaded/code/5531.sqliteobject.zip

The tutorial is at
http://www.garagegames.com/index.php?sec=mg&mod=resource&page=view&qid=5531

A word of caution on the download, you will ONLY be able to use the SQLiteObject.cc, SQLiteObject.h & sqlite.cs files.

DO NOT UNDER ANY CIRCUMSTANCES USE THE OTHER FILES. They won't work under linux.

Ok that said open up SQLiteObject.cc
Look for

#include <STDLIB.H>

replace with

#include <STDLIB.H>

Save and close
From a console

make clean
make -f mk/configure.mk OS=LINUX COMPILER=GCC3 BUILD=DEBUG
make

You WILL get an error thats ok
Next you will

cp ~/Torque/lib/sqlite/sqlite_DEBUG.a ~/Torque/lib/out.GCC3.DEBUG
make

And with that it should compile cleanly
Move your sqlite.cs file to examples and add

exec("sqlite.cs");

To init.cs

There ya go, SQLite integration in torque under linux.
Special thanx to John Vanderbek and Entr0py for the ideas and code.

Hope this helps!