database_sqlite3.lsp
Module: Sqlite3
SQLite3 subclass of DF.DB. Only lists Sqlite3 specific functions.
Version: 1.1.1
Author: Greg Slepak
Location: http://www.taoeffect.com/newlisp/database_sqlite3.lsp.txt
Features not found in newLISP's sqlite3.lsp:
- Multiple connections
- Multiple active SQL statements
- Supports reuse of SQL statements through parameter rebinding
- Supports BLOB data-type as per DF.DB and DF.BLOB specification
- Conforms to generic DF.DB interface
- Grabs integers directly through 64-bit function
- Can go through results row-by-row
- Allows specification of custom sqlite3 library page with SQLITE3_LIBRARY_PATH
- Uses the latest Sqlite3 library functions if they are available
- Better error handling
Requirements
See module DF.DB for requirements.Version history
1.1.1 • improved readability in error logging, fixed binding of integers on 32-bit newlisp builds
1.1.0 • support for DF.BLOB
1.0.0 • initial release- § -
Sqlite3
syntax: Sqlite3
Represents a connection to an SQLite3 database. Create one like so:
(instantiate Sqlite3 [str-filepath [flags [vfs-module]]])If str-filepath is specified a connected instance will be returned or nil upon failure to connect. If they are not specified then an unconnected instance will be returned.
see: documentation for Sqlite3:open for an explanation of the parameters.
- § -
Sqlite3:open
syntax: (Sqlite3:open str-filepath [flags [vfs-module]])
str-filepath specifies the path to the sqlite3 database, but it can also be ":memory:" to indicate an in-memory database.
flags and vfs-module are optional parameters as defined in the sqlite reference documentation for sqlite3_open_v2. Your installation of sqlite3 may need to be updated for this to be available.
For return values see DF.DB:open.
- § -
Sqlite3:set-timeout
syntax: (Sqlite3:set-timeout int-ms)
Sets the sqlite3's busy timeout for this connection in milliseconds.
By default the timeout is set to 30 seconds.
return: nil or non-nil on success
- ∂ -
generated with newLISP and newLISPdoc