mfoster.io on Nostr: Nice, Dexie looks interesting. Thanks for sharing! Because SQLite is a binary, highly ...
Nice, Dexie looks interesting. Thanks for sharing!
Because SQLite is a binary, highly portable database that is self-contained. It works well with private persistent OPFS data stores https://sqlite.org/wasm/doc/tip/persistence.md#opfs.
You can load it right in WebAssembly and get the benefits of worker threads. https://sqlite-wasm-opfs.glitch.me/.
I was researching how it could utilize the concurrency benefits of shared workers from multiple tabs, iframes and windows properly. https://sqlite.org/forum/forumpost/58a377083cd24a29
There needs to be a clear understanding on how to manage the SQLite file locking with something like the WebLocks API.
https://developer.mozilla.org/en-US/docs/Web/API/Web_Locks_API
I came from the SolidProject.org world before I discovered NOSTR and CASHU. I “was” working on some decentralized personal storage ideas with federated search queries https://bit.ly/foaf-trav.
The problem I ran into, is that it needs a more robust messaging and syncing mechanism after you discover the decentralized data. So, I started looking into some CRDT syncing projects with SQLite.
One thing I really like about utilizing OPFS with a SQLite database is the privacy and the ability to just grab the database and drop it anywhere you want for backup on your local
I sent you a message on Matrix if you want to do some note comparison.
Because SQLite is a binary, highly portable database that is self-contained. It works well with private persistent OPFS data stores https://sqlite.org/wasm/doc/tip/persistence.md#opfs.
You can load it right in WebAssembly and get the benefits of worker threads. https://sqlite-wasm-opfs.glitch.me/.
I was researching how it could utilize the concurrency benefits of shared workers from multiple tabs, iframes and windows properly. https://sqlite.org/forum/forumpost/58a377083cd24a29
There needs to be a clear understanding on how to manage the SQLite file locking with something like the WebLocks API.
https://developer.mozilla.org/en-US/docs/Web/API/Web_Locks_API
I came from the SolidProject.org world before I discovered NOSTR and CASHU. I “was” working on some decentralized personal storage ideas with federated search queries https://bit.ly/foaf-trav.
The problem I ran into, is that it needs a more robust messaging and syncing mechanism after you discover the decentralized data. So, I started looking into some CRDT syncing projects with SQLite.
One thing I really like about utilizing OPFS with a SQLite database is the privacy and the ability to just grab the database and drop it anywhere you want for backup on your local
I sent you a message on Matrix if you want to do some note comparison.