descriptionUnofficial git mirror of the SQLite sources
last changeFri, 17 Nov 2017 21:01:04 +0000 (17 21:01 +0000)
content tags
sqlite git mirror @

SQLite Git Mirror

Self-contained implementation of most of the SQL-92 specification

An unofficial git mirror of only the source code from the main SQLite repository at which is part of the SQLite project.

Building SQLite

In order to clone and build SQLite from this git repository, a substitute manifest and manifest.uuid file (these are fossil vcs specific files) must be created or the build will fail.

The following script may be executed with the current directory set to the working directory of the git clone in order to create or update these files:

# See for license details
# Creates a minimal manifest and manifest.uuid file so sqlite (and fossil) can build
git rev-parse --git-dir >/dev/null || exit 1
echo $(git log -1 --format=format:%H) > manifest.uuid
echo C $(cat manifest.uuid) > manifest
git log -1 --format=format:%ci%n | sed 's/ [-+].*$//;s/ /T/;s/^/D /' >> manifest

The above script simply records the hash of the current HEAD commit in manifest.uuid (and as the manifest’s "C"omment) and the UTC time of the commit in ISO format (preceded by "D ") in the manifest file.

The above script must be run at least once from the top-level of the working directory of the git clone for make to succeed and should be run before make whenever HEAD has changed otherwise the sqlite_source_id() information will be incorrect.

The above script is also available from the project in the create-fossil-manifest file.

After having created the substitute manifest and manifest.uuid files, simply build as normal (i.e. run ./configure with any desired options and then run make).

About This Mirror

This git mirror has been created using the information found in the project. Please see that project’s README.txt file for more information.

The fossil check-in hash of the fossil SQLite repository check-in corresponding to a commit can be found in the "fossil" notes (i.e. refs/notes/fossil). (Use git log --show-notes=fossil to see them.) Once you have the fossil check-in hash (e.g. git log --show-notes=fossil -1 version-3.8.5) you can then view the original commit in the SQLite fossil repository at (e.g.

Please note that this mirror is updated only once a day so it may take up to 24 hours for commits to the main SQLite fossil repository at to appear here.

IMPORTANT: Since this is strictly a mirror, if the upstream fossil repository should rewrite history in any way, the refs in this repository will be force updated without notice!

The Great 2017 Rebuild

In March of 2017, the official SQLite repository started using a new hash algorithm. As a result, the older version of fossil being used was no longer capable of keeping this mirror up-to-date.

Switching to a newer fossil version produced some minor differences in the commit objects (the exported tree objects the commits refer to are identical between the two versions). This caused all the refs to be force-updated. Unfortunately it was unavoidable in order for this mirror to remain current.

Since the tree objects themselves are identical, rebasing any work built on the old ref values to the new ref values should be relatively painless.


Since this is strictly a mirror of the code from the native SQLite fossil repository, the standard SQLite license applies.


Downloads are available from the main SQLite download area or from links found at

Visit the project page (source code etc.) at


Visit the SQLite project’s home site at

16 hours ago D. Richard... Improved fix for ticket [da78413751863] that does not... master
17 hours ago Dan KennedyAdd some missing "finish_test" lines to the end of...
20 hours ago D. Richard... New assert() statements in the rowvalue IN expression...
22 hours ago D. Richard... Clarification of comments on sqlite3FindInIndex()....
24 hours ago Dan KennedyDo not count temporary databases that have been attache...
29 hours ago Dan KennedyAvoid creating a master journal if all or all but one... master-journal-temp-files
40 hours ago Dan KennedyIn the LSM extension,
42 hours ago D. Richard... Add a missing "finish_test" to the end of the stmtvtab1...
2 days ago D. Richard... Futher improvements to the .testctrl interface in the...
2 days ago D. Richard... UI improvements on the .testctrl dot-command in the...
3 days ago D. Richard... In the parse tree, combine LIMIT and OFFSET into a...
3 days ago D. Richard... Add the ability to read from read-only WAL-mode databas...
3 days ago Dan KennedyFix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality...
4 days ago D. Richard... Improvement to a comment. No changes to code.readonly-wal-recovery
5 days ago D. Richard... Remove some branches in walTryBeginRead() that were
6 days ago D. Richard... In wal.c: improved comments, new assert() and testcase...
3 weeks ago version-3.21.0
3 weeks ago release
2 months ago version-3.20.1
3 months ago version-3.19.4
3 months ago version-3.20.0
5 months ago version-3.18.2
5 months ago version-3.18.1
5 months ago version-3.19.3
5 months ago version-3.19.2
5 months ago version-3.19.1
5 months ago version-3.19.0
7 months ago version-3.18.0
9 months ago version-3.17.0
10 months ago version-3.16.2
10 months ago version-3.16.1
10 months ago version-3.16.0
16 hours ago master
17 hours ago apple-osx
29 hours ago master-journal-temp-files
2 days ago appendvfs
3 days ago begin-concurrent
3 days ago branch-3.8.9
4 days ago readonly-wal-recovery
7 days ago update-delete-limit-fix
2 weeks ago fcntl_shm_read
2 weeks ago begin-concurrent-pnu
2 weeks ago checkindex
2 weeks ago like-compare-opt
3 weeks ago mistake
3 weeks ago rtree-integrity-check
3 weeks ago branch-3.21
4 weeks ago sqlite3ext-fix