Fosstodon

0 posts0 participants0 posts today

data0Nice trick to still run <a href="https://indieweb.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> <a href="https://indieweb.social/tags/wasm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#wasm</a> in browser with <a href="https://indieweb.social/tags/opfs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#opfs</a> enabled if you can't set <a href="https://indieweb.social/tags/coep" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#coep</a> / <a href="https://indieweb.social/tags/coop" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#coop</a> on server<a href="https://toot.cafe/@tomayac/114128600602436482" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://toot.cafe/@tomayac/114128600602436482</a><a href="https://indieweb.social/tags/http" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#http</a> <a href="https://indieweb.social/tags/webserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#webserver</a> <a href="https://indieweb.social/tags/serviceworkers" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#serviceworkers</a>

Paul LWho here knows enough <a href="https://mastodon.online/tags/webplatfrom" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#webplatfrom</a> and <a href="https://mastodon.online/tags/webapi" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#webapi</a> to know if relative links exists with the Origin Private File System (<a href="https://mastodon.online/tags/OPFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OPFS</a>)?thanks much for RT and dig to find people knowing...

data0The <a href="https://indieweb.social/tags/wasm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#wasm</a> build of <a href="https://indieweb.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> opens up great new possibilities in the <a href="https://indieweb.social/tags/browser" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#browser</a>, especially when coupled with the Origin Private File System (<a href="https://indieweb.social/tags/opfs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#opfs</a>). I've used it to implement importing huge <a href="https://indieweb.social/tags/csv" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#csv</a> or <a href="https://indieweb.social/tags/jsonl" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#jsonl</a> <a href="https://indieweb.social/tags/datasets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#datasets</a> 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 <a href="https://indieweb.social/tags/golang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#golang</a> to get rid of <a href="https://indieweb.social/tags/cgo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#cgo</a>![1/2]

Thomas Steiner :chrome:I’ll be in Milan, Italy 🇮🇹 for <a href="https://toot.cafe/tags/Codemotion" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Codemotion</a> tomorrow and (half of) the day after to talk about <a href="https://toot.cafe/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a>, <a href="https://toot.cafe/tags/WebAssembly" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebAssembly</a> (<a href="https://toot.cafe/tags/Wasm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Wasm</a>), and the Origin Private File System (<a href="https://toot.cafe/tags/OPFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OPFS</a>). My talk is tomorrow, 16:30 🕟: <a href="https://conferences.codemotion.com/milan2023-live/agenda/" rel="nofollow noopener noreferrer" target="_blank">https://conferences.codemotion.com/milan2023-live/agenda/</a>. If you’re at the conference, be sure to say “ciao” 🤌!

Martti MalmiIris uses LokiJS for in-memory storage and Dexie for persistence. Both are pretty good, but it's a bit of a hassle to have 2 databases. Could try sqlite wasm. I wonder if also <a class="mention hashtag" href="https://mostr.pub/tags/nostrdb" rel="nofollow noopener noreferrer" target="_blank">#nostrdb</a> could be used on wasm and persisted on origin private filesystem like sqlite. <a href="https://sqlite.org/wasm/doc/trunk/persistence.md#opfs" rel="nofollow noopener noreferrer" target="_blank">https://sqlite.org/wasm/doc/trunk/persistence.md#opfs</a>

Thomas Steiner :chrome:📢 The Origin Private File System (OPFS) is a cross-browser solution for your performance-critical, file-based storage needs on the Web! <a href="https://front-end.social/@chrisdavidmills" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@chrisdavidmills</a> has documented everything you need to know about the API over on MDN: <a href="https://developer.mozilla.org/en-US/docs/Web/API/File_System_API/Origin_private_file_system" rel="nofollow noopener noreferrer" target="_blank">https://developer.mozilla.org/en-US/docs/Web/API/File_System_API/Origin_private_file_system</a>.💡 This is what powers Photoshop (<a href="https://developer.chrome.com/blog/how-photoshop-solved-working-with-files-larger-than-can-fit-into-memory/" rel="nofollow noopener noreferrer" target="_blank">https://developer.chrome.com/blog/how-photoshop-solved-working-with-files-larger-than-can-fit-into-memory/</a>) and SQLite Wasm (<a href="https://developer.chrome.com/blog/sqlite-wasm-in-the-browser-backed-by-the-origin-private-file-system/" rel="nofollow noopener noreferrer" target="_blank">https://developer.chrome.com/blog/sqlite-wasm-in-the-browser-backed-by-the-origin-private-file-system/</a>). #️⃣ <a href="https://toot.cafe/tags/OPFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OPFS</a> <a href="https://toot.cafe/tags/ProjectFugu" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ProjectFugu</a> 🐡

Kristof Zerbe<a href="https://indieweb.social/tags/Link" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Link</a> | Understanding OPFSStorage in web apps can be a real pain, but nearly every year the possibilities expand. Thomas Steiner (<a href="https://toot.cafe/@tomayac" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@tomayac</a>), 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.<a href="https://web.dev/origin-private-file-system/" rel="nofollow noopener noreferrer" target="_blank">https://web.dev/origin-private-file-system/</a><a href="https://indieweb.social/tags/webapps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#webapps</a> <a href="https://indieweb.social/tags/storage" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#storage</a> <a href="https://indieweb.social/tags/opfs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#opfs</a><a href="https://kiko.io/notes/2023/understanding-opfs/" rel="nofollow noopener noreferrer" target="_blank">https://kiko.io/notes/2023/understanding-opfs/</a>

Thomas Steiner :chrome:🥳 It’s happening: the Intent to Deprecate and Remove for Web SQL has been sent: <a href="https://groups.google.com/a/chromium.org/g/blink-dev/c/fWYb6evVA-w/m/pziWcvboAgAJ" rel="nofollow noopener noreferrer" target="_blank">https://groups.google.com/a/chromium.org/g/blink-dev/c/fWYb6evVA-w/m/pziWcvboAgAJ</a>; read more about our plans on the blog: <a href="https://developer.chrome.com/blog/deprecating-web-sql" rel="nofollow noopener noreferrer" target="_blank">https://developer.chrome.com/blog/deprecating-web-sql</a>.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): <a href="https://developer.chrome.com/blog/sqlite-wasm-in-the-browser-backed-by-the-origin-private-file-system/" rel="nofollow noopener noreferrer" target="_blank">https://developer.chrome.com/blog/sqlite-wasm-in-the-browser-backed-by-the-origin-private-file-system/</a>.There’s also a Web SQL 🔜 SQLite Wasm migration guide: <a href="https://developer.chrome.com/blog/from-web-sql-to-sqlite-wasm/" rel="nofollow noopener noreferrer" target="_blank">https://developer.chrome.com/blog/from-web-sql-to-sqlite-wasm/</a>.#️⃣ Hashtags: <a href="https://toot.cafe/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://toot.cafe/tags/WebSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebSQL</a> <a href="https://toot.cafe/tags/Wasm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Wasm</a> <a href="https://toot.cafe/tags/WebAssembly" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebAssembly</a> <a href="https://toot.cafe/tags/OPFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OPFS</a> <a href="https://toot.cafe/tags/ProjectFugu" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ProjectFugu</a>

Codie こでぃーSomethin im working on <a href="https://tech.lgbt/tags/opfs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#opfs</a> <a href="https://tech.lgbt/tags/dev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dev</a> <a href="https://tech.lgbt/tags/webdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#webdev</a> <a href="https://tech.lgbt/tags/minecraft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#minecraft</a>

Thomas Steiner :chrome:📢The File System Standard adds an origin private file system (OPFS) 📂 as a storage endpoint private to the origin of a page providing optional access to a special kind of file 🗂️ that’s highly optimized for performance. My latest article has all facts! <a href="https://developer.chrome.com/articles/origin-private-file-system/" rel="nofollow noopener noreferrer" target="_blank">https://developer.chrome.com/articles/origin-private-file-system/</a> <a href="https://toot.cafe/tags/OPFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OPFS</a> <a href="https://toot.cafe/tags/ProjectFugu" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ProjectFugu</a>

Thomas Steiner :chrome:🎒 From Web SQL to SQLite Wasm—the database migration guide: <a href="https://developer.chrome.com/blog/from-web-sql-to-sqlite-wasm/" rel="nofollow noopener noreferrer" target="_blank">https://developer.chrome.com/blog/from-web-sql-to-sqlite-wasm/</a>With SQLite Wasm backed by the Origin Private File System (<a href="https://toot.cafe/tags/OPFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OPFS</a>), there's a replacement for the deprecated Web SQL. My latest article guides you when migrating your data from <a href="https://toot.cafe/tags/WebSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebSQL</a> to <a href="https://toot.cafe/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> Wasm.

Inautilo<a href="https://mastodon.social/tags/Development" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Development</a> <a href="https://mastodon.social/tags/Overviews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Overviews</a> (Almost) everything about storing data on the web · Options to store data locally on a user’s device for client-side or offline access <a href="https://ilo.im/10hh92" rel="nofollow noopener noreferrer" target="_blank">https://ilo.im/10hh92</a> · by <a href="https://mas.to/@patrickbrosset" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@patrickbrosset</a>_____ <a href="https://mastodon.social/tags/WebDevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebDevelopment</a> <a href="https://mastodon.social/tags/WebDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebDev</a> <a href="https://mastodon.social/tags/WebApplication" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebApplication</a> <a href="https://mastodon.social/tags/WebApp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebApp</a> <a href="https://mastodon.social/tags/Browser" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Browser</a> <a href="https://mastodon.social/tags/Chrome" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Chrome</a> <a href="https://mastodon.social/tags/Firefox" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Firefox</a> <a href="https://mastodon.social/tags/Edge" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Edge</a> <a href="https://mastodon.social/tags/Safari" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Safari</a> <a href="https://mastodon.social/tags/Storage" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Storage</a> <a href="https://mastodon.social/tags/WebStorage" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebStorage</a> <a href="https://mastodon.social/tags/IndexedDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IndexedDB</a> <a href="https://mastodon.social/tags/CacheAPI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CacheAPI</a> <a href="https://mastodon.social/tags/OPFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OPFS</a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a>

El Greco<a href="https://toot.cafe/@tomayac" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@tomayac</a> Just finished watching the recording of the Fugu Chat from BlinkOn 17. I particularly enjoyed the very last remark by Ben Morss: <a href="https://yewtu.be/watch?v=5Yzd3nCvIAM&t=27m25s" rel="nofollow noopener noreferrer" target="_blank">https://yewtu.be/watch?v=5Yzd3nCvIAM&t=27m25s</a>He refers to the recent beta release of sqlite3 WebAssembly which enables to create AND persist a sqlite database in your browser: <a href="https://sqlite.org/releaselog/3_40_0.html" rel="nofollow noopener noreferrer" target="_blank">https://sqlite.org/releaselog/3_40_0.html</a> For persisting the database they are using a (theoretically) unlimited 👀 browser-side storage (OPFS): <a href="https://webkit.org/blog/12257/the-file-system-access-api-with-origin-private-file-system/" rel="nofollow noopener noreferrer" target="_blank">https://webkit.org/blog/12257/the-file-system-access-api-with-origin-private-file-system/</a><a href="https://masto.ai/tags/Fugu" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Fugu</a> <a href="https://masto.ai/tags/ProjectFugu" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ProjectFugu</a> <a href="https://masto.ai/tags/OPFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OPFS</a> <a href="https://masto.ai/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> <a href="https://masto.ai/tags/sqlite3" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite3</a> <a href="https://masto.ai/tags/WebDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebDev</a>

Recent searches

Search options

Administered by:

Server stats:

#opfs