KDb/Drivers/SQLite: Difference between revisions
| Line 1: | Line 1: | ||
==Requirements for libsqlite3== | ==Requirements for libsqlite3 builds== | ||
Configure as follows: | Configure as follows: | ||
mkdir builddir | mkdir builddir | ||
| Line 19: | Line 19: | ||
See also explanation in [http://blogs.kde.org/node/4156 Deploying SQLite] blog entry. | See also explanation in [http://blogs.kde.org/node/4156 Deploying SQLite] blog entry. | ||
==Status in distros== | |||
Debian: OK | |||
TODO... | |||
==Collations== | |||
Links | |||
*http://stackoverflow.com/questions/611459/how-to-sort-text-in-sqlite3-with-specified-locale | |||
*http://www.sqlite.org/c3ref/load_extension.html | |||
*http://www.sqlite.org/lang_corefunc.html#load_extension | |||
Revision as of 21:42, 16 December 2011
Requirements for libsqlite3 builds
Configure as follows:
mkdir builddir cd builddir REQUIRED_CPPFLAGS="-DSQLITE_ENABLE_COLUMN_METADATA=1" REQUIRED_OPTIONS="--enable-load-extension" RECOMMENDED_CPPFLAGS="-DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 \ -DSQLITE_SECURE_DELETE=1 -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1 \ -DSQLITE_ENABLE_RTREE=1 -DSQLITE_ENABLE_STAT2=1 \ -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1 -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 \ -DSQLITE_SOUNDEX=1" RECOMMENDED_OPTIONS="--enable-threadsafe" CPPFLAGS="$REQUIRED_CPPFLAGS $RECOMMENDED_CPPFLAGS" \ ../sqlite-src-???/configure --prefix=.... $REQUIRED_OPTIONS $RECOMMENDED_OPTIONS
--enable-load-extension is a must to have support for setting up unicode collations.
Optional: append --enable-debug for debug version.
See also explanation in Deploying SQLite blog entry.
Status in distros
Debian: OK
TODO...
Collations
Links