KDb/Drivers/SQLite: Difference between revisions

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

@@ Line 1: / Line 1: @@
-==Requirements for libsqlite3==
+==Requirements for libsqlite3 builds==
 Configure as follows:
   mkdir builddir
@@ Line 19: / Line 19: @@
 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