Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Why SQLite Uses Bytecode
(whybytecode.html)
3.2. Dataflow Programs Are Easy To Parallelize
In a dataflow program, each processing node can be assigned to a
different thread. There needs to be some kind of threadsafe queuing
mechanism for transferring intermediate results from one node to the
next. But no synchronization primitives are typically ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
3. Checklist For Choosing The Right Database Engine
... Many concurrent writers? → choose client/server
If many threads and/or processes need to write the
database at the same instant (and they cannot queue up and take turns)
then it is best to select a database engine that ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
2. SQLite Is Embedded, Not Client-Server
... An application interacts
with the database engine using function calls, not by sending messages
to a separate process or thread.
The fact that SQLite is embedded and serverless instead of being
client/server is a feature, not a bug.
Client ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... For example, a DROP TABLE statement cannot be run while another thread
is reading from that table on the same database connection because
dropping the table would delete the table out from under the concurrent
reader.
The SQLITE_LOCKED result code ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
3.1.6. Application-defined memory allocators
... In a multi-threaded application, access to the sqlite3_mem_methods
is serialized if and only if SQLITE_CONFIG_MEMSTATUS is enabled.
If SQLITE_CONFIG_MEMSTATUS is disabled then the methods in
sqlite3_mem_methods must take care of their own serialization needs.
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3. The Tcl interface to the SQLite library
... This provides a small performance boost in single-threaded applications.
-readonly BOOLEAN
If true, then open the database file read-only. If false, then the
database is opened for both reading and writing if filesystem permissions
allow, or for reading ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... SQLite automatically coordinates concurrent access to the same
document from multiple threads and/or processes. Two or more
applications can connect and read from the same document at the
same time. Writes are serialized, but as writes normally only
take ...
|
|
Vulnerabilities
(cves.html)
3. Status Of Recent SQLite CVEs
... See
forum thread b25edc1d4662
for the bug report.
CVE-2023-32697
Not a bug in SQLite
This is a bug in the SQLite JDBC library, which is a wrapper library that
provides access to SQLite from Java. SQLite JDBC is ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... If the application wanted
to keep all content in memory, it could continue reading and parsing the
other pages using a background thread after drawing the first page. Or,
since reading from SQLite is so efficient, the application might
instead ...
|
|
SELECT
(lang_select.html)
... See the discussion on
SQLite Forum thread 7481d2a6df8980ff
for additional information.
2.6. Removal of duplicate rows (DISTINCT processing)
One of the ALL or DISTINCT keywords may follow the SELECT keyword in a
simple SELECT statement. If the simple SELECT ...
|
Page generated by FTS5 in about 77.69 ms.