Rockbox

SQLite is a fast and lightweight SQL database engine library.
See http://www.sqlite.org for more information.

This patch makes it available to use in a plugin and provides a usage example.

Additionally to the patch, the actual library is required. You need to download the amalgamation, available at http://www.sqlite.org/sqlite-amalgamation-3_5_7.zip
It is not included for obvious size reasons.
Extract both sqlite3.c and sqlite3.h to apps/plugins/lib/ and add the following line to the top of sqlite3.c :
#include sqlite3_aux.h
(this file contains everything necessary to make the library compile in the rockbox environment)

The binary size is still very high, we need to strip some features off to make it smaller.

For testing, an SQLite version of the Northwind database is available atsqlite-users@sqlite.org/msg22708.html"> http://www.mail-archive.com/sqlite-users@sqlite.org/msg22708.html

This is mainly an experiment. I have no intention of adding it to the core or use it to replace the current Database. However, it might open interesting possibilities for plugins.

Thanks to Frank Gevaerts for helping me with this :)

 apps/plugins/CATEGORIES        |    1 
 apps/plugins/sqlite3test.c     |   96 ++++++++
 apps/plugins/lib/SOURCES       |    2 
 apps/plugins/lib/sqlite3_aux.h |   63 +++++
 apps/plugins/lib/rockbox_vfs.c |  451 +++++++++++++++++++++++++++++++++++++++++
 apps/plugins/SOURCES           |    1 
 6 files changed, 614 insertions(+)