SQLite

Some quick notes

To build SQLite from the development repository, you need TCL and fossil...

~$ sudo apt-get install tcl8.5 fossil

SQLite uses fossil for their development branch, so if you use their development branch, you have some steps to go through:

First, check out a "fossil" which is a single file with all the information

~/sqlite$ fossil clone ​http://www.sqlite.org/cgi/src/dir trunk.fossil

Second, make and navigate into an sqlite directory:

~$ mkdir sqlite ~$ cd sqlite

Third, open the fossil file

~/sqlite$ fossil open ../trunk.fossil

Fourth, archaive the sqlite folder (so you have an old copy to fall back on)...

~/sqlite$ cd .. ~$ tar -acf sqlite.fossil.tar.bz2 sqlite

close the fossil file

~$ cd sqlite ~/sqlite$ fossil close ../trunk.fossil

SQLite "Almalgamates" the source code before building, which can complicate finding required configuration changes, so using --disable-amalgamate seems to make it easier to find where needed changes are. Haven't gotten any farther, but I thought that was rather interesting...

References

This looks promising... ​http://www.crosscompile.org/static/pages/SQLite.html