BaH.DBSQLite: Modinfo Source  

Database Driver - SQLite

An SQLite database driver for Database.

The DBSQLite database driver allows you to connect to SQLite databases through the standard API provided by the Database Framework module.

Requirements

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.

Accessing an SQLite Database

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.

Prepared Statement Placeholders

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.

SQL with SQLite

For a complete guide to SQLite's support of SQL92, we have provided the SQL reference documentation.

Module Information

Version1.11
AuthorBruce A Henderson
LicenseBSD
CopyrightWrapper - 2007-2009 Bruce A Henderson
CopyrightSQLite - The original author of SQLite has dedicated the code to the public domain. Anyone is free to copy, modify, publish, use, compile, sell, or distribute the original SQLite code, either in source code form or as a compiled binary, for any purpose, commercial or non-commercial, and by any means.
ModserverBRL
History1.11
HistoryUpdate to SQLite 3.6.15.
HistoryFixed prepared statement reuse issue.
HistoryFixed problem where open/live queries could cause problem when committing.
HistoryAdded getTableInfo() support.
HistoryAdded blob support.
History1.10
HistoryUpdate to SQLite 3.5.6.
HistoryFixed lack of error reporting during query execution.
HistoryTransaction queries are finalized more quickly.
HistoryStatement should generally be reset before acquiring error message.
History1.09
HistoryUpdate to SQLite 3.5.2. Now using the Amalgamated version.
HistoryImplementation of Date, DateTime and Time types.
History1.08
HistoryFixed null column types not being handled.
History1.07
HistoryFixed problem with lastInsertedId() not returning.. the last inserted id.
History1.06
HistoryUpdate to SQLite 3.4.2.
History1.05
HistoryFixed database Close to cleanup non-finalized queries.
History1.04
HistoryImproved error message details.
History1.03
HistoryFixed NextRow returning True on empty queries.
History1.02
HistoryFixed issue with mis-count of bound parameters.
History1.01
HistoryAdded hasPrepareSupport() and hasTransactionSupport() methods.
History1.00 Initial Release
HistoryIncludes SQLite 3.3.13 source.