The sqlite3 module for Qore provides a database driver for SQLite3 database files.
It requires qore 0.7.0 or greater and sqlite3 headers and libraries to build.
Module documentation: http://qore.org/manual/modules/sqlite3-module-doc.html
The driver supports the following features:
- all sqlite3 afinities (datatypes) are supported, except "date" types.
- "date" types are supported only for writing from Qore. See Sqlite3 docs for more infromations about its date handling
- multi-dimensional arrays are not supported for binding and retrieving
- is thread-safe
- transaction management is supported
- transparent character encoding conversion is supported if necessary
The driver's name is "sqlite3".
ex (with Qore 0.8.0+):
my Datasource $db("sqlite3");
The latest source code can be checked out from svn with the following command:
svn co https://svn.qore.sf.net/svnroot/qore/module-sqlite3/trunk qore-module-sqlite3
SVN browse here: http://qore.svn.sourceforge.net/viewvc/qore/module-sqlite3/trunk/
RPMs for Linux can be found at the opensuse build service here: http://download.opensuse.org/repositories/devel:/languages:/misc/
Mac OS/X users can install this module by using macports by issuing the following command
sudo port selfupdate
sudo port -vu install qore-sqlite3-module
