SQLite
A small, self-contained SQL database engine that stores a whole database in one file.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
3 more ways to get SQLite
Other download sites
Run by third parties, not by The SQLite developers. Prefer the official page above when it works.
Package managers
- Chocolatey
choco install sqlite - Homebrew
brew install sqlite
About SQLite
SQLite is a self-contained SQL database engine written in C. It is built into mobile phones and most computers and bundled inside many everyday applications. The project also provides the sqlite3 command-line shell for creating, querying and editing database files by hand.
It supports a full SQL dialect, including window functions, JSON functions, math functions and date and time functions, with extensive documentation. A browser-based 'Try it live' page lets you run queries without installing anything. The source code is in the public domain.
Strengths
- Whole database in a single file with no server to run
- Public-domain source code usable for any purpose
- Broad SQL support including window and JSON functions
- Thorough documentation and regular releases
Limitations
- Mainly a library; the bundled sqlite3 shell is command-line only
- No graphical browser included
Details
- Pricing
- FreeFree for any purpose; the source code is in the public domain.
- License
- Proprietary (Public domain)
- Developer
- The SQLite developers
- Platforms
- Windows, macOS, Linux, Command line
- How it runs
- Downloadable app
- Account
- Not required
- Works offline
- Yes
- Best suited for
- Developers and power users who need a lightweight local SQL database
- Categories
- Database tools, Developer tools
- Last verified
- Added
- Provenance
- Facts checked against the developer's own pages and store listings, 1 sources on file.
Alternatives to SQLite
Compare allSoftware that can replace SQLite for an important use case, and what changes if you switch.
DuckDB
In-process analytical database that queries CSV, JSON and Parquet directly.
DuckDB is also an embedded, in-process database but aimed at analytics, querying CSV, JSON and Parquet files directly, released under the MIT license.
Similar software
Related functionality, not necessarily a direct replacement.
DB Browser for SQLite
Opens a SQLite file in a spreadsheet-like window so you can look at the data without writing SQL.
Letos
A free, open-source desktop app for creating, editing and browsing SQLite databases, formerly SQLiteStudio.
LiteCLI
A command-line SQLite client with auto-completion and syntax highlighting.
sqlite-utils
A Python command-line tool and library for creating, querying and transforming SQLite databases.
Datasette
Publishes SQLite databases as an explorable website and JSON API.
PostgreSQL
The open-source relational database with 35 years behind it, known for correctness, extensibility and a long feature list.
