SQLite (official Git mirror)
The source tree of SQLite, the self-contained SQL database engine embedded in phones, browsers and countless applications, mirrored to GitHub by its developers.
sqlite/sqlite
- Stars
- 10.7k
- Forks
- 1.7k
- Language
- C
- Licence
- NOASSERTION
- Last push
- 14 Oct 2026
On GitHub: Official Git mirror of the SQLite source tree
Open on GitHubSQLite is a SQL database engine in a C library. A whole database lives in a single ordinary file, and there is no server process. That makes it the default choice for application storage, mobile apps, desktop software, tests and quick data exploration. The sqlite3 command-line shell comes with macOS and is packaged for all major Linux distributions.
This repository is the official Git mirror of the source tree. Development itself happens in the Fossil version control system on sqlite.org, which also hosts the documentation, the forum and the downloads. The SQLite source code is in the public domain.
Read the mirror to study how a production database is built: the parser, query planner, virtual machine and B-tree storage layer. The project does not take changes through GitHub pull requests; bug reports and discussion go through the forum on the official site.
See also
- 0067 Your first SQL queries: SELECT, WHERE, ORDER BY, LIMIT and GROUP BY Read data from a table, keep only the rows you want, sort them, take the first few, and summarize groups with COUNT,… Beginner · How-to · Any system Article Queries 15 Oct 2026
- 0068 SQL joins explained: INNER, LEFT and finding rows with no match A join combines rows from two tables using a matching condition. INNER JOIN keeps only matches, LEFT JOIN keeps every row from… Intermediate · Concept · Any system Article Joins 15 Oct 2026
- 0069 NULL in SQL: why = NULL never matches and how to handle missing values NULL means "unknown", so comparisons with it are neither true nor false. Use IS NULL, COALESCE and careful aggregates to avoid rows… Intermediate · Concept · Any system Article Queries 15 Oct 2026
- 0070 Indexes and EXPLAIN: making SQL queries fast An index is a sorted lookup structure that lets the database jump to matching rows instead of reading the whole table. EXPLAIN… Advanced · Concept · Any system Article Indexes & performance 15 Oct 2026
- 0071 Fix: column “x” must appear in the GROUP BY clause or be used in an aggregate function PostgreSQL rejects a grouped query that selects a column with more than one possible value per group. Add the column to GROUP… Intermediate · Fix · Any system Article Queries 15 Oct 2026
- 0077 SQL cheat sheet: a runnable reference for everyday queries One SQL file that builds a tiny database and demonstrates filtering, sorting, grouping, joins, CASE, CTEs, window functions, safe updates and indexes.… Beginner · Reference · Any system Script Joins · Queries 15 Oct 2026
History
Every saved edit is kept. The plot on the sleeve draws one line per edit. Open any edit to see exactly what changed.
- commitpedia-admin +876 chars