Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: One-Step Query Execution Interface
(c3ref/exec.html)
sqlite3_exec()
... The application must ensure that the 1st parameter to sqlite3_exec()
is a valid and open database connection.
The application must not close the database connection specified by
the 1st parameter to sqlite3_exec() while sqlite3_exec() is running.
The application must not ...
|
|
An Asynchronous I/O Module For SQLite
(asyncvfs.html)
... When files opened via
this VFS are written to (using the vfs xWrite() method), the data is not
written directly to disk, but is placed in the "write-queue" to be
handled by the background thread.
When files opened with ...
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... Prior to deleting the journal file, if a power failure
or crash occurs, the next process to open the database will see that
it has a hot journal and will roll the changes back.
After the journal is deleted, there ...
|
|
Run-Time Loadable Extensions
(loadext.html)
6. Statically Linking A Run-Time Loadable Extension
... If you will be opening multiple database connections in your application,
rather than invoking the extension entry points for each database
connection separately, you might want to consider using the
sqlite3_auto_extension() interface to register your extensions and
to cause them ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
9.5. Deleting Or Renaming A Hot Journal
... During recovery at step 4.2 SQLite locates
the hot journal by looking for a file in the same directory as the
database being opened and whose name is derived from the name of the
file being opened. If either ...
|
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... If URI handling is globally
enabled, all filenames passed to sqlite3_open(), sqlite3_open_v2(),
sqlite3_open16() or
specified as part of ATTACH commands are interpreted as URIs, regardless
of whether or not the SQLITE_OPEN_URI flag is set when the database
connection is opened ...
|
|
Using SQLite In Multi-Threaded Applications
(threadsafe.html)
4. Run-time selection of threading mode
... If neither flag is specified or if
sqlite3_open() or sqlite3_open16() are used instead of
sqlite3_open_v2(), then the default
mode determined by the compile-time and start-time settings is used.
This page last modified on 2023-12-05 14:43 ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... In its place, the xOpen method is enhanced to open a temporary file
of its own invention when the filename parameter is NULL.
Added the xGetLastError() method to sqlite3_vfs for returning
filesystem-specific error messages and error codes back to ...
|
|
Long Term Support
(lts.html)
... Extensive, detailed documentation →
SQLite has candid, developer-friendly,
and open-source documentation. Docs are written by and
for programmers.
(A few examples:
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8])
The extensive documentation helps new developers
come up to ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... How did my database become empty?)
Unless opened with flags to prevent it, a SQLite database is created
if it does not already exist. Newly created databases are initially empty.
This can confuse people who inadvertantly open different database files ...
|
Page generated by FTS5 in about 162.06 ms.