







Hosting read-only SQLite databases on static file hosters like Github Pages - phiresky/sql.js-httpvfs
Peersky Browser (@peersky@mastodon.social)
Attached: 2 images ๐ In v1.0.0-beta.14 you can now: - Browse your local file:// directories inside PeerSky and publish them straight to IPFS or Hypercore with one click. The distributed web should feel this easy. ๐โจ https://github.com/p2plabsxyz/peersky-browser/releases/tag/v1.0.0-beta.14
SQLSync
SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.

GitHub - zombiezen/go-sqlite: Low-level Go interface to SQLite 3
Low-level Go interface to SQLite 3. Contribute to zombiezen/go-sqlite development by creating an account on GitHub.
@same.supply
โฉ๏ธ reply to @same.supply: also kinda works with local files, but file management and sync are making me question if the benefits of "web distribution" are worth the headache of web permissions
TigerFS
A filesystem backed by PostgreSQL, and a filesystem interface to PostgreSQL. TigerFS mounts a database as a directory. Every file is a real row. Writes are transactions. Multiple agents and humans can read and write concurrently with full ACID guarantees, locally or across machines. Any tool that works with files works out of the box.
Add OPFS support by dengkunli ยท Pull Request #1490 ยท duckdb/duckdb-wasm
This PR adds OPFS (Origin Private File System) support for duckdb-wasm. With OPFS support, we could persist the database in the browser ๐ฅ API To remain simple and intuitive, no new api is added, ju...
Litestream
Litestream is an open-source, real-time streaming replication tool that lets you safely run SQLite applications on a single node.

jedisct1/hf-mount-encrypted
Mount Hugging Face Buckets and repos as local filesystems, with client-side encryption.
๐ Decentralized Extension Distribution (P2P "Bodega"/"Hoard") ยท Issue #42 ยท p2plabsxyz/peersky-browser
Organize and distribute WebExtensions via decentralized hosting (e.g., IPFS, Hypercore) using a predictable folder structure. Tasks: Define folder structure convention: /extensions/{name}/{version}...
PowerSync: Backend DB - SQLite sync engine | For Postgres, MongoDB, MySQL, SQL Server
Automatically sync your backend database with in-app SQLite and avoid the complexities of using APIs to move app state over the network.

The local-only web
In this post, I explore the potential of the File System Access API to create local-only web experiences. I discuss how this API, combined with tools like Logseq, allows for on-device data storage outside the browser sandbox. While exciting, I also acknowledge the current limitations, such as the need to re-grant file access on refresh, the lack of a visual indicator for local-only sites, and the difficulty of preventing data exfiltration entirely. Despite these challenges, I believe this area holds significant potential and deserves further exploration.
Short ๐งต on bsky38.com 's stack! We use sqlite.
Bailey Townsend ๐ฆ
Will probably do a thread on bsky38.com 's stack tonight. We tried our best to not rely too much on Bluesky's AppView by using things like typeahead.waow.tech, porxie, and slingshot. But it is a Bsky lexicon centric app so we used some since it was the easiest way to get likes