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