Rui CarmoSQLite is my database engine of choice for simple, no-frills stuff, and has of late become popular enough for me not to have to bother compiling it from scratch anywhere.
| Category | Date | Link | Notes |
|---|---|---|---|
| Extensions | 2023 | sqlite-vss | an extension for efficient vector search |
| sqlean.py | a bundle of pre-packaged extensions for Python |
||
| Unofficial SQLite package registry | an interesting set of public extensions |
||
| 2022 | sqlite-html | An extension for parsing HTML |
|
| 2008 | SpatiaLite | An extension to support spatial data in conformance with OpenGIS |
|
| Forks | 2023 | libsql | A fork of SQLite that allows for open contributions |
| 2022 | litetree | A branching database |
|
| Networking | 2023 | FerretDB | a proxy that converts MongoDB 6.0+ wire protocol queries to Postgres or SQLite |
| 2022 | Postlite | A Postgres wire protocol for remote access to SQLite |
|
| Replication | 2023 | litefs | FUSE-based file system for replicating SQLite databases across a cluster of machines |
| 2022 | litestream | streaming replication |
|
| marmot | A distributed SQLite replicator |
||
| rqlite | |||
| Tools | 2024 | sqlite-studio | a single binary SQLite explorer with an embedded web UI |
| 2023 | sqinn-go | A library that makes it easy to run |
|
| 2006 | SQLite Control Center |