Documentation Source Text

SQLite is built using a 
[https://en.wikipedia.org/wiki/DO-178B|DO-178B]-inspired process.
The [testing|testing standards] for SQLite are among the highest for
commercial software.

<p>
SQLite is [copyright|open-source] but it is not open-contribution.
All the code in SQLite is written by experts.
The project does not accept "pull requests" or other code from 
anonymous passers-by on the internet.







<p>
All of these factors combine to make SQLite a very trouble-free
software library.

SQLite is built using a 
[https://en.wikipedia.org/wiki/DO-178B|DO-178B]-inspired process.
The [testing|testing standards] for SQLite are among the highest for
commercial software.

<p>
SQLite is [copyright|open-source] but it is not open-contribution.
All the code in SQLite is written by a small team of experts.
The project does not accept "pull requests" or patches from 
anonymous passers-by on the internet.

<p>
The developers of SQLite intend to support the product through
the year 2050.  To this end, the source code is carefully documented
to promote long-term maintainability.  We prefer mature and stable
over trendy and cutting-edge.

<p>
All of these factors combine to make SQLite a very trouble-free
software library.

[footprint|small],
[faster than the filesystem|fast],
[self-contained], 
[high-reliability],
[full-featured SQL|full-featured],
SQL database engine.
SQLite is the [most used] database engine in the world.
It is built into all mobile phones and most computers and
comes bundled inside countless other applications that people
use every day.
<a href="about.html">More Information...</a>














<p>
SQLite [https://sqlite.org/src|source code]
is in the [public-domain] and is free to 
everyone to use for any purpose.

<h3>Latest Release</h3>
<a href="releaselog/3_27_0.html">Version 3.27.0</a> ([dateof:3.27.0]).
<a class="button" href="download.html">Download</a>
<a class="button" href="chronology.html">Prior Releases</a>

<h3>Common Links</h3>
<tcl>common_links</tcl>

[footprint|small],
[faster than the filesystem|fast],
[self-contained], 
[high-reliability],
[full-featured SQL|full-featured],
SQL database engine.
SQLite is the [most used] database engine in the world.
SQLite is built into all mobile phones and most computers and
comes bundled inside countless other applications that people
use every day.
<a href="about.html">More Information...</a>

<p>
The SQLite [file format] is stable, cross-platform, and
backwards compatible and the developers pledge to keep it
that way through at least the year 2050.  SQLite database
files are commonly uses as a container to transfer rich 
content between systems
[affshort|&#91;1&#93;]
[appformat|&#91;2&#93;]
and as a long-term archival format 
for data
[recommended storage format|&#91;3&#93;].
There are over 1 trillion SQLite databases in active use.

<p>
SQLite [https://sqlite.org/src|source code]
is in the [public-domain] and is free to 
everyone to use for any purpose.

<h3>Latest Release</h3>
<a href="releaselog/3_27_0.html">Version 3.27.0</a> ([dateof:3.27.0]).
<a class="button" href="download.html">Download</a>
<a class="button" href="chronology.html">Prior Releases</a>

<h3>Common Links</h3>
<tcl>common_links</tcl>

[https://www.loc.gov/preservation/digital/formats/fdd/fdd000461.shtml#local]
<li>
[https://www.loc.gov/preservation/resources/rfs/data.html]
</ul>

<p>
As of this writing (2018-05-29) the only other recommended storage formats
for datasets are JSON and CSV.

<h2>What Is A Recommended Storage Format?</h2>

<p>
Recommended storage formats are formats which, in the opinion of the
preservationists at the Library of Congress, maximizes the chance of
survival and continued accessibility of digital content.

[https://www.loc.gov/preservation/digital/formats/fdd/fdd000461.shtml#local]
<li>
[https://www.loc.gov/preservation/resources/rfs/data.html]
</ul>

<p>
As of this writing (2018-05-29) the only other recommended storage formats
for datasets are XML, JSON, and CSV.

<h2>What Is A Recommended Storage Format?</h2>

<p>
Recommended storage formats are formats which, in the opinion of the
preservationists at the Library of Congress, maximizes the chance of
survival and continued accessibility of digital content.