| BaH.DBSQLite: | Modinfo | Source |
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.
| Version | 1.11 |
|---|---|
| Author | Bruce A Henderson |
| License | BSD |
| Copyright | Wrapper - 2007-2009 Bruce A Henderson |
| Copyright | SQLite - 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. |
| Modserver | BRL |
| History | 1.11 |
| History | Update to SQLite 3.6.15. |
| History | Fixed prepared statement reuse issue. |
| History | Fixed problem where open/live queries could cause problem when committing. |
| History | Added getTableInfo() support. |
| History | Added blob support. |
| History | 1.10 |
| History | Update to SQLite 3.5.6. |
| History | Fixed lack of error reporting during query execution. |
| History | Transaction queries are finalized more quickly. |
| History | Statement should generally be reset before acquiring error message. |
| History | 1.09 |
| History | Update to SQLite 3.5.2. Now using the Amalgamated version. |
| History | Implementation of Date, DateTime and Time types. |
| History | 1.08 |
| History | Fixed null column types not being handled. |
| History | 1.07 |
| History | Fixed problem with lastInsertedId() not returning.. the last inserted id. |
| History | 1.06 |
| History | Update to SQLite 3.4.2. |
| History | 1.05 |
| History | Fixed database Close to cleanup non-finalized queries. |
| History | 1.04 |
| History | Improved error message details. |
| History | 1.03 |
| History | Fixed NextRow returning True on empty queries. |
| History | 1.02 |
| History | Fixed issue with mis-count of bound parameters. |
| History | 1.01 |
| History | Added hasPrepareSupport() and hasTransactionSupport() methods. |
| History | 1.00 Initial Release |
| History | Includes SQLite 3.3.13 source. |