gbadev.org forum archive

This is a read-only mirror of the content originally found on forum.gbadev.org (now offline), salvaged from Wayback machine copies. A new forum can be found here.

DS development > Any SQLite Successes?

#172366 - Drovor - Wed Feb 03, 2010 1:35 am

I downloaded the most recent build of SQLite and was able to build it with the devkitPro library template and include the lib in my project. However any sqlite command I try exits with an Out of Memory error.

I'm using the following flags:
CFLAGS += -DOS_OTHER=1 -DSQLITE_THREADSAFE=0 -DSQLITE_OMIT_LOAD_EXTENSION=0\
-DSQLITE_DISABLE_LFS=1 -DSQLITE_MAX_LENGTH=256 -DSQLITE_MAX_SQL_LENGTH=256\
-DSQLITE_DEFAULT_CACHE_SIZE=100 -DSQLITE_DEFAULT_TEMP_CACHE_SIZE=50\
-DSQLITE_MAX_ATTACHED=1

I've tried the "amalgamation" build as well as from the regular source.

Has anyone been able to use SQLite? Any pointers?

#172403 - ninjalj - Thu Feb 04, 2010 11:55 pm

Maybe you meant -DSQLITE_OMIT_LOAD_EXTENSION=1?

In DSLinux, we compile SQLite with --disable-threadsafe --disable-dynamic-extensions. For me, it crashes randomly, even though I have 32MB RAM in slot 2.