Small. Fast. Reliable.
Choose any three.
Choose any three.
|
ALTER TABLE
(lang_altertable.html)
... If some future version of SQLite adds new ALTER TABLE capabilities,
those capabilities will very likely use one of the two procedures
outlined above.
8. Why ALTER TABLE is such a problem for SQLite
Most SQL database engines store the ...
|
|
Benefits of SQLite As A File Format
(aff_short.html)
... the equivalent procedural
code, and since the number of bugs per line of code is roughly
constant, this means fewer bugs overall.
Accessibility
SQLite database content can be viewed using a wide variety
third-party tools.
Content stored in an ...
|
|
Distinctive Features Of SQLite
(different.html)
... In manifest typing, the datatype is a property of the value itself, not
of the column in which the value is stored.
SQLite thus allows the user to store
any value of any datatype into any column regardless of the ...
|
|
Long Term Support
(lts.html)
... Not boiler-plate
comments, but useful comments that explain the meaning of variables
and objects and the intent of methods and procedures.
The code is designed
to be accessible to new programmers and maintainable over a span
of decades.
Disaster ...
|
|
The RBU Extension
(rbu.html)
2.3. RBU Update C/C++ Programming
The RBU extension interface allows an application to apply an RBU update
stored in an RBU database to an existing target database.
The procedure is as follows:
Open an RBU handle using the sqlite3rbu_open(T,A,S) function.
The T ...
|
|
How To Compile SQLite
(howtocompile.html)
4. Building The Amalgamation
... Suppose the SQLite source tree is stored in a directory named "sqlite".
Plan to construct the amalgamation in a parallel directory named (for
example) "bld". First construct an appropriate Makefile by either
running the configure script at the top of ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... If the busy method is invoked without an argument, the name of the callback
procedure last set by the busy method is returned. If no callback procedure
has been set, an empty string is returned.
The "enable_load_extension" method
The extension ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... I/O procedures are now always redefinable.
Three new objects are defined for specifying I/O procedures:
sqlite3_vfs, sqlite3_file, and sqlite3_io_methods.
Three new interfaces are used to create alternative OS interfaces:
sqlite3_vfs_register(), sqlite3_vfs_unregister(), and
sqlite3_vfs_find().
A new interface has been ...
|
|
The SQLite Amalgamation
(amalgamation.html)
... And because all code is in
a single translation unit, compilers can do
better inter-procedure and inlining optimization
resulting in machine code that is between 5% and 10% faster.
2. The SQLite Amalgamation
The SQLite library consists of 111 ...
|
|
SQLite Backup API
(backup.html)
... This procedure works well in many scenarios and is usually very
fast. However, this technique has the following shortcomings:
Any database clients wishing to write to the database file while a
backup is being created must wait until the shared ...
|
Page generated by FTS5 in about 28.38 ms.