The DBSQLite database driver allows you to connect to SQLite databases through the standard API provided by the Database Framework module.
Everything you need to compile and work with SQLite databases is provided with the module, including the source to SQLite itself.
There are no external requirements.
To enable an SQLite connection, you pass a dbtype of "SQLITE" to the LoadDatabase function.
The second parameter, dbname, should be either an SQLite database file (either an existing one, or the
name of one you wish to create), or ":memory:", which will create an in-memory database.
Note that in-memory databases last only as long as the connection is open.
Host, port, user and password parameters are not required for this driver.
SQLite can have placeholders of the form "?" or "?nnn" or ":aaa" where "nnn" is an integer and "aaa" is an identifier. Each placeholder has an associated number which is its sequence in the query or the "nnn" in the case of a "?nnn" form. It is allowed for the same valued-placeholder to occur more than once in the same SQL, in which case all instances of that placeholder will be filled in with the same value.
For a complete guide to SQLite's support of SQL92, we have provided the SQL reference documentation.