Small. Fast. Reliable.
Choose any three.
Choose any three.
|
TH3
(th3.html)
5. Mutation Testing
... The script compiles the sqlite3.c source file into assembly language
("sqlite3.s") if necessary.
The script loops through instructions in the assembly language file
to locate branch operations.
The script makes a copy of the original sqlite3.s file ...
|
|
C API: Binding Values To Prepared Statements
(c3ref/bind_blob.html)
sqlite3_bind_blob(), sqlite3_bind_blob64(), sqlite3_bind_double(), sqlite3_bind_int(), sqlite3_bind_int64(), sqlite3_bind_null ...
... The sqlite3_bind_pointer(S,I,P,T,D) routine causes the I-th parameter in
prepared statement S to have an SQL value of NULL, but to also be
associated with the pointer P of type T. D is either a ...
|
|
Why Is SQLite Coded In C
(whyc.html)
3. Why Isn't SQLite Coded In A "Safe" Language?
... None of the safe programming languages existed for the first 10 years
of SQLite's existence. SQLite could be recoded in Go or Rust, but doing
so would probably introduce far more bugs than would be fixed, and it
seems ...
|
|
Isolation In SQLite
(isolation.html)
... Readers can be active at the beginning of a write, before any content
is flushed to disk and while all changes are still held in the writer's
private memory space. But before any changes are made to the database ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
10. Dubious SQL Is Allowed Without Any Error Or Warning
The original implementation of SQLite sought to follow
Postel's Law which
states in part "Be liberal in what you accept".
This used to be considered good design - that a system would accept
dodgy inputs and try to do the ...
|
|
STRICT Tables
(stricttables.html)
1. Introduction
... Some developers appreciate the freedom that SQLite's flexible typing
rules provide and use that freedom to advantage.
But other developers are aghast at SQLite's
flagrant rule-breaking and prefer the traditional rigid type
system found in all other ...
|
|
Long Term Support
(lts.html)
... Cross-platform Code →
SQLite runs on any platform with an 8-bit byte,
two's complement 32-bit and 64-bit integers,
and a C compiler. It is actively
tested on all currently popular CPUs and operating
systems.
The ...
|
|
C API: Obtaining SQL Values
(c3ref/value_blob.html)
sqlite3_value_blob(), sqlite3_value_double(), sqlite3_value_int(), sqlite3_value_int64(), sqlite3_value_pointer(), sqlite3_value_text ...
... If sqlite3_value object V was initialized
using sqlite3_bind_pointer(S,I,P,X,D) or sqlite3_result_pointer(C,P,X,D)
and if X and Y are strings that compare equal according to strcmp(X,Y),
then sqlite3_value_pointer(V,Y) will return ...
|
|
sqldiff.exe: Database Difference Utility
(sqldiff.html)
3. Limitations
... For several of SQLite's
bundled virtual tables (FTS3, FTS5, rtree and others), the surprising effects
may include corruption of the virtual table content.
If the --vtab option is passed to sqldiff.exe, then it ignores all
underlying shadow tables ...
|
|
Built-In Mathematical SQL Functions
(lang_mathfunc.html)
... exp(X)
Compute e (Euler's number, approximately 2.71828182845905) raised
to the power X.
floor(X)
Return the first representable integer value less than or equal to X.
For positive numbers, this function rounds toward zero.
For negative numbers ...
|
Page generated by FTS5 in about 68.45 ms.