Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Why SQLite Does Not Use Git
(whynotgit.html)
3. A Git-User's Guide To Accessing SQLite Source Code
If you are a devoted Git user, you can still easily access SQLite.
This section gives some hints on how to do so.
|
|
NULL Handling in SQLite
(nulls.html)
... 5.
Borland Interbase does not support CASE expressions.
The following script was used to gather information for the table
above.
-- I have about decided that SQL's treatment of NULLs is capricious and cannot be
-- deduced by logic ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
4.1. We've never done it that way before
... Presumably, many developers who are aghast at SQLite's flexible
typing feel this way because they have just never encountered anything
like it before. All prior exposure to databases and especially SQL
databases has involved rigid typing, and the readers ...
|
|
Defense Against The Dark Arts
(security.html)
1.1. Untrusted SQL Inputs
... This also sandboxes SQLite's memory so that a write-after-free
error in some other part of the application will not cause
problems for SQLite, or vice versa.
To control memory usage in the printf() SQL function, compile
with ...
|
|
Transaction
(lang_transaction.html)
... If database
connection X is holding a read transaction, it is possible that some
other database connection Y might change the content of the database
while X's transaction is still open, however X will not be able to see ...
|
|
RETURNING
(lang_returning.html)
... SQLite's syntax for RETURNING is modelled after
PostgreSQL.
The RETURNING syntax has been supported by SQLite since version 3.35.0
(2021-03-12).
1.1. Typical Use
The RETURNING clause is designed to provide the application with the ...
|
|
SQLite Database Speed Comparison
(speed.html)
... For Matt's
results, visit
Obsolete URL: http://www.sergeant.org/sqlite_vs_pgsync.html
SQLite was tested in the same configuration that it appears
on the website. It was compiled with -O6 optimization and with
the -DNDEBUG=1 switch which disables ...
|
|
C API: Standard File Control Opcodes
(c3ref/c_fcntl_begin_atomic_write.html)
SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ...
... The SQLITE_FCNTL_BUSYHANDLER
file-control may be invoked by SQLite on the database file handle
shortly after it is opened in order to provide a custom VFS with access
to the connection's busy-handler callback. The argument is of type ...
|
|
Powersafe Overwrite
(psow.html)
... Enabling PSOW does not decrease SQLite's ability
to recover from a torn page.
Changes In SQLite Version 3.7.10
The VFS for SQLite version 3.7.10 (2012-01-16)
adds a new device characteristic
named SQLITE_IOCAP_POWERSAFE_OVERWRITE. Database ...
|
|
How SQLite Is Tested
(testing.html)
4.1.2. Google OSS Fuzz
... OSS Fuzz uses a AFL-style guided fuzzer running on Google's infrastructure.
The Fuzzer automatically downloads the latest check-ins for participating
projects, fuzzes them, and sends email to the developers reporting any
problems. When a fix is checked ...
|
Page generated by FTS5 in about 70.47 ms.