Small. Fast. Reliable.
Choose any three.
Choose any three.
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... The intended audience is programmers who want to understand and/or modify
the pager code and reviewers working to verify the design
of SQLite version 3.
2.0 Overview
Locking and concurrency control are handled by the
pager module.
The ...
|
|
C API: OS Interface Object
(c3ref/vfs.html)
sqlite3_syscall_ptr(), struct sqlite3_vfs
... If a suffix is added to the zFilename parameter, it will
consist of a single "-" character followed by no more than
11 alphanumeric and/or "-" characters.
SQLite further guarantees that
the string will be valid and unchanged until xClose() is ...
|
|
The Percentile Extension
(percentile.html)
1. Overview
The percentile extension provides four aggregate functions
that compute a percentile score and/or the median value for a distribution.
The percentile
extension is not in the SQLite core. It is not part of the
amalgamation. The percentile extension is ...
|
|
C API: Online Backup API.
(c3ref/backup_finish.html)
sqlite3_backup_init(), sqlite3_backup_step(), sqlite3_backup_finish(), sqlite3_backup_remaining(), sqlite3_backup_pagecount()
... The error code and message for the failed call to sqlite3_backup_init()
can be retrieved using the sqlite3_errcode(), sqlite3_errmsg(), and/or
sqlite3_errmsg16() functions.
A successful call to sqlite3_backup_init() returns a pointer to an
sqlite3_backup object.
The sqlite3_backup object may be used ...
|
|
35% Faster Than The Filesystem
(fasterthanfs.html)
2.3. Variations
... Other compile-time options such as using -O3 instead of -Os or
using -DSQLITE_THREADSAFE=0 and/or some of the other
recommended compile-time options might help SQLite to run even faster
relative to direct filesystem reads.
The size of ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... However, a few of the changes in version 3.6.0 are incompatible and
might require modifications to application code and/or makefiles.
This document is a briefing on the changes in SQLite 3.6.0
with special attention to ...
|
|
Uniform Resource Identifiers
(uri.html)
3.3. Recognized Query Parameters
... If this query parameter (or
the SQLITE_IOCAP_IMMUTABLE bit in xDeviceCharacteristics)
asserts that a database file is immutable and that file
changes anyhow, then SQLite might return incorrect query
results and/or SQLITE_CORRUPT errors.
mode=romode=rwmode=rwcmode=memory
The mode ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... To access the content of a custom application file format, one needs
a tool specifically engineered to read and/or write that format.
Pile-of-Files Formats.
Sometimes the application state is stored as a hierarchy of
files. Git is ...
|
|
How To Compile SQLite
(howtocompile.html)
2. Amalgamation Versus Individual Source Files
... Building the necessary C programs and transforming and/or creating the
C-language source code for SQLite is a complex process.
To simplify matters, SQLite is also available as a pre-packaged
amalgamation source code file: sqlite3.c. The amalgamation ...
|
|
Automatic Undo/Redo With SQLite
(undoredo.html)
... Enable and/or disable menu options a buttons
#
proc status_refresh {} {
variable _undo
if {!$_undo(active) || [llength $_undo(undostack)]==0} {
.mb.edit entryconfig Undo -state disabled
.bb.undo config -state disabled
} else {
.mb.edit entryconfig Undo -state normal
.bb ...
|
Page generated by FTS5 in about 159.06 ms.