SQLite
This article is a stub. You can help the IndieWeb wiki by expanding it.
SQLite is a relational database that stores an entire database in a single file. Unlike most databases, it is accessed as a library rather than a separate process.
IndieWeb Examples
Peter Molnar uses SQLite3 FTS4 engine for full text searching his site.Christian Weiske uses SQLite as temporary datastore when re-building his static blog after pushing changes onto the server
Jacky Alciné uses SQLite as the primary database in Koype, Shock, Koype and Lighthouse. It also powers the property searching functionality of Koype via a custom virtual table.
fluffy uses SQLite as the primary database in Publ, and prefers that storage engine for Feed on Feeds.
Previous Examples
- Until ~2015ish
Kyle Mahan is experimenting with SQLite as the primary datastore for Red Wind.
Software Examples
- Sandstorm recommends that apps use SQLite if possible because each application runs in its own container, and therefore cannot share a single e.g., MySQL instance.
See Also
- database
- Show changes in git diff displays for binary databases through the clever use of the sqlite cli as binary-to-text converter
- https://www.sqlite.org/json1.html for querying against JSON blobs
- https://dgl.cx/2020/06/sqlite-json-support for autogenerating columns from JSON for indexing purposes
- SQLime, an online sandbox for SQLite queries. (Source on GitHub.)
- https://www.sqlite.org/mostdeployed.html
- For longevity considerations, note that SQLite is a US Library-of-Congress-recommended storage format
- Fork: https://github.com/libsql/libsql with an alternative code of conduct based more on other codes of conduct: https://github.com/libsql/libsql/blob/main/CODE_OF_CONDUCT.md
- Code of Conduct: Thoughts on SQLite’s CoC
- guide on good settings for server-use: https://kerkour.com/sqlite-for-servers