Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The SQLite Amalgamation
(amalgamation.html)
1. Executive Summary
... The amalgamation
contains everything an application needs to embed SQLite.
Combining all the code for SQLite into one big file makes SQLite
easier to deploy — there is just one file to keep track of.
And because all code is ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
Moving From SQLite 3.5.9 to 3.6.0
SQLite version 3.6.0 (2008-07-16)
contains many changes. As is the custom with
the SQLite project, most changes are fully backwards compatible.
However, a few of the ...
|
|
SQLite Version 3 Overview
(version3.html)
... It is retained as part of the historical record of SQLite.
Modern programmers should refer to
more up-to-date documentation on SQLite available elsewhere
on this website.
SQLite Version 3 Overview
SQLite version 3.0 introduces important changes to ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
1. Overview
... If you are an SQLite user whose has stumbled over some quirk of
SQLite that is not mentioned here, please let the developers know
by posting a brief message on the
SQLite Forum.
|
|
Measuring and Reducing CPU Usage in SQLite
(cpu.html)
1. Overview
The graph below shows the number of CPU cycles used by SQLite on a
standard workload, for versions of SQLite going back about 10 years.
Recent versions of SQLite use about one third as many the CPU cycles
compared to ...
|
|
Hints for Debugging SQLite
(debugging.html)
Debugging Hints
The following is a random assortment of techniques used by the
SQLite developers to trace, examine, and understand the behavior of the
core SQLite library.
These techniques are designed to aid in understanding the
core SQLite library itself ...
|
|
How To Compile SQLite
(howtocompile.html)
1. Overview
Compile SQLite like this:
Unix and Mac → ./configure && make
Windows → nmake /f Makefile.msc
The commands above will build the amalgamation and the
Command Line Interface (aka: CLI). There are no (required) dependencies,
so the commands above should ...
|
|
SQLite Frequently Asked Questions
(faq.html)
Frequently Asked QuestionsHow do I create an AUTOINCREMENT field?What datatypes does SQLite support?SQLite lets me insert a string into a database column of type integer!Why doesn't SQLite allow me to use '0' and '0.0' as ...
|
|
The Use Of assert() In SQLite
(assert.html)
1. Assert() And Similar Macros In SQLite
... Since SQLite uses 100% MC/DC testing, the presence of a
testcase(X) macro indicates that not only is it possible for X to be either
true or false, but there are test cases to demonstrate this.
SQLite version 3 ...
|
|
Architecture of SQLite
(arch.html)
Introduction
This document describes the architecture of the SQLite library.
The information here is useful to those who want to understand or
modify the inner workings of SQLite.
A nearby diagram shows the main components of SQLite
and how they ...
|
Page generated by FTS5 in about 777.28 ms.