SQLite at the edge is getting serious. FinBodhi proves it: a local-first, private financial app that runs on SQLite over OPFS in-browser, with end-to-end encrypted sync so data never leaves your device unprotected. Backups can live locally or ride to Dropbox for safekeeping. [1]
Local-first, FinBodhi details — FinBodhi uses a double-entry model to handle complex transactions, and it offers a demo mode so you can try before you sign up. It’s designed to keep data on-device and only sync encrypted when you choose to share across devices. [1]
Caching schemas in SQLite — A pragmatic SQLite schema for application-level caching argues for a lean, on-device cache that stays queryable and avoids round-trips. This approach is aimed at pragmatic performance and simplicity for apps that need speed at the edge. [2]
Distributed SQLite with rqlite — rqlite 9.2 offers distributed SQLite, delivering fast restarts on GB-scale datasets. That’s the edge case where you want reliability and updates across nodes without leaving SQLite behind. [3]
SQLite by default in boilerplates — goilerplate is a SaaS boilerplate that uses SQLite by default, with Postgres optional. It spotlights a broader trend: SQLite-by-default tooling showing up in projects that want quick-onboarding storage. [4]
Closing thought: the edge isn’t about choosing one path forever—it’s about matching local-first pragmatism, caching discipline, and distributed health to your app’s data gravity. Watch how teams mix on-device storage with encrypted sync and selective distribution next.
Referenced POST IDs: 1, 2, 3, 4
References
Show HN: FinBodhi – Local-first, double-entry app/PWA for your financial journey
Local-first SQLite in-browser storage for privacy with encrypted sync; advocates double-entry for complex finances; compares to single-entry apps.
View sourceShow HN: A pragmatic SQLite schema for application-level caching
Show HN showcasing a pragmatic SQLite schema designed for application-level caching to streamline local data caching strategies and performance benefits.
View sourceRqlite 9.2 updates present distributed SQLite database with fast restarts for gigabyte-scale datasets.
View sourceShow HN: goilerplate – A SaaS boilerplate for Go and templ and Htmx
Show HN goilerplate SaaS boilerplate notes SQLite default, optional Postgres; templUI and payments integration.
View source