This module is a wrapper around SQLite. SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. More info at SQLite's about page.
The SQLite documentation is your friend. SQLite version 3 C/C++ API reference
SQLite is used in core so far only by the database module. No other modules should access SQLite's APIs directly. To use sql databases in your project, check the database module documentation. So far the API is refined to support Web SQL Databases, but improvements are accepted.
Because SQLite is a 3rd party library, it needs to be periodically updated. The following steps need to be followed:
sqlite-opera-patch. If the patch does not apply cleanly,
then a new patch needs to be produced, commited, and the tag needs to
be updated to refer to the new commit.