1
Why SQLite Uses Bytecode
Every SQL database engine works in roughly the same way: It first translates the input SQL text into a "prepared statement". Then it "executes" the prepared statement to generate a result.
SQLite
SQLite is a C-language library that implements a small , fast , self-contained , high-reliability , 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…
- Popular posts
- 45
- Total points
- 14,486
- HN comments
- 10,582
- Rank
- #56 company
Visit sqlite.org → On Hacker News May 2013 – May 2026
Databases & Data 43Software Engineering 30Systems & Performance 9Tech Industry & Business 3Web & Frontend 1Society, Policy & Culture 1
2
JSONB has landed
JSONB is a rewrite of the SQLite JSON functions that, depending on usage patterns, could be several times faster than the original JSON functions. This enhancement has now landed on trunk .
3
SQLite as an Application File Format (2014)
An SQLite database file with a defined schema often makes an excellent application file format. Here are a dozen reasons why this is so:
4
Why SQLite Does Not Use Git
SQLite does not use the Git version control system. SQLite uses Fossil instead, which is a version control system that was specifically designed and written to support SQLite.
5
What if OpenDocument used SQLite? (2014)
Suppose the OpenDocument file format, and specifically the "ODP" OpenDocument Presentation format, were built around SQLite. Benefits would include:
6
C Is Best (2025)
Since its inception on 2000-05-29, SQLite has been implemented in generic C. C was and continues to be the best language for implementing a software library like SQLite. There are no plans to recode SQLite in any other programming language at this time.
7
Sqlite 3.30.0
This page provides a high-level summary of changes to SQLite. For more detail, see the Fossil checkin logs at https://sqlite.org/src/timeline and https://sqlite.org/src/timeline?t=release . See the chronology a succinct listing of releases.
8
SQLite 3.32
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
9
10
11
SQLite Release 3.25.0 adds support for window functions
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
12
SQLite Release 3.37.0
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
13
Strict Tables – Column type constraints in SQLite - Draft
SQLite strives to be flexible regarding the datatype of the content that it stores. For example, if a table column has a type of "INTEGER", then SQLite tries to convert anything inserted into that column into an integer. So an attempt to insert the string '123' results in an integer 123 being inserted. But if the…
14
Why SQLite does not use Git (2018)
The document you seek is not available. Please consider one of the links below or use the Search feature on the right-hand side of the menu bar above.
15
Clang-11.0.0 Miscompiled SQLite
It appears that the clang-11.0.0 compiler mis-compiles sqlite3.c version 3.32.1. I have checked in a change to SQLite that appears to work around the problem. But there might be other bugs. Therefore, use clang-11.0.0 with caution and test your applications carefully!
16
SQLite 3.33
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
17
SQLite 3.42.0
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
18
SQLite 3.8.0 Release with next-generation query planner
Beginning with this release, SQLite will not compile on Windows version prior to Windows Vista (circa 2007), due to a switch to using Slim Reader/Writer Locks (SRWLs) which are faster but which are not available on WindowsXP and earlier.
19
20
21
SQLite Release 3.8.11.1
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
22
SQLite Release 3.39.0
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
23
SQLite 3.43
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
24
SQLite Archive Files (2018)
An "SQLite Archive" is a file container similar to a ZIP archive or Tarball but based on an SQLite database.
25
26
SQLite: Infinite loop due to the ‘order by limit’ optimization
Verify that you are human by typing in the 8-character text password shown below.
27
The Use of assert() in SQLite
The assert(X) macro is part of standard C , in the <assert.h> header file. SQLite adds three other assert()-like macros named NEVER(X), ALWAYS(X), and testcase(X).
28
Quirks, Caveats, and Gotchas in SQLite
The SQL language is a "standard". Even so, no two SQL database engines work exactly alike. Every SQL implementation has its own peculiarities and oddities, and SQLite is no exception to this rule.
29
SQLite Release 3.40.0
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
30
SQLite 3.39.3
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .