fosstodon.org is one of the many independent Mastodon servers you can use to participate in the fediverse.
Fosstodon is an invite only Mastodon instance that is open to those who are interested in technology; particularly free & open source software. If you wish to join, contact us for an invite.

Administered by:

Server stats:

10K
active users

The #wasm build of #sqlite opens up great new possibilities in the #browser, especially when coupled with the Origin Private File System (#opfs). I've used it to implement importing huge #csv or #jsonl #datasets right in the browser. Import, validate, search, edit, close the browser and continue tomorrow, stream the database (with on-the-fly compression!) to the server when ready – it's all possible!

Another interesting use case I came across today: use it in #golang to get rid of #cgo!

[1/2]

#Link | Understanding OPFS

Storage in web apps can be a real pain, but nearly every year the possibilities expand. Thomas Steiner (@tomayac), from the Chrome Dev Team, highlights the latest expansion in detail: the **Origin Private File System**, which allows to handle complete file structures on the web.

web.dev/origin-private-file-sy

#webapps #storage #opfs

kiko.io/notes/2023/understandi

web.devThe origin private file system

🥳 It’s happening: the Intent to Deprecate and Remove for Web SQL has been sent: groups.google.com/a/chromium.o; read more about our plans on the blog: developer.chrome.com/blog/depr.

Together with the SQLite team, we’ve prepared a replacement for Web SQL based on SQLite Wasm backed by the origin private file system (OPFS): developer.chrome.com/blog/sqli.

There’s also a Web SQL 🔜 SQLite Wasm migration guide: developer.chrome.com/blog/from.

#️⃣ Hashtags: #SQLite #WebSQL #Wasm #WebAssembly #OPFS #ProjectFugu

groups.google.comIntent to Deprecate and Remove Web SQL

🎒 From Web SQL to SQLite Wasm—the database migration guide: developer.chrome.com/blog/from

With SQLite Wasm backed by the Origin Private File System (#OPFS), there's a replacement for the deprecated Web SQL. My latest article guides you when migrating your data from #WebSQL to #SQLite Wasm.

Chrome DevelopersFrom Web SQL to SQLite Wasm: the database migration guide - Chrome DevelopersBuild the next generation of web experiences.

@tomayac Just finished watching the recording of the Fugu Chat from BlinkOn 17. I particularly enjoyed the very last remark by Ben Morss: yewtu.be/watch?v=5Yzd3nCvIAM&t

He refers to the recent beta release of sqlite3 WebAssembly which enables to create AND persist a sqlite database in your browser: sqlite.org/releaselog/3_40_0.h

For persisting the database they are using a (theoretically) unlimited 👀 browser-side storage (OPFS): webkit.org/blog/12257/the-file