#Firefox, as of v111, now supports the #OPFS browser-side filesystem, meaning that our #sqlite#javascript /#WASM API can now create persistent client-side databases in Firefox :-D.
https://t.co/XvA8EMKY5u
🥳My first major contribution to #sqlite (#JavaScript and #WebAssembly bindings) will be released along with sqlite version 3.40: https://t.co/MSLYEKPs9q. It supports browser-side persistent databases using @ChromiumDev's Origin-Private FileSystem or localStorage/sessionStorage.
Stopped by twitter for the first time in ages and its usability is still horrid. i opine that a full half of the rage vented on twitter is subconsciously induced by its painful UI.
@geoffreylitt OPFS storage being accessible outside of the browser would give malicious software a way to "sideload" content into/take content from arbitrary sites. It would also force the browser to contend with other apps locking those files.
@geoffreylitt@svoisen sqlite conventionally uses posix-style locking but OPFS currently exclusively locks when it opens a file, so that's what we have to live with. The non-OPFS FS API is not something we've looked at. Getting sqlite-over-OPFS out to the world is the current priority.
Big news in web app persistence: SQLite + Chrome are collaborating to create an official SQLite WASM build, backed by performant filesystem APIs!
I'm mostly very excited for this. But there is one catch that I'm still trying to understand... 1/
@geoffreylitt@jlongster Both absurd-sql and sql.js were instrumental in helping us (sqlite team) understand how to take on the OPFS task. We experimented with absurd-sql-like IDB storage but it's simply too easy to corrupt sqlite dbs stored there.
@sc13ts Subversion uses sqlite, too, but much differently. Fossil's core SCM data is NOT relational (and it's immutable) but fossil converts that data into something SQL-friendly. https://t.co/94rPsRuphy
@sc13ts Probably the biggest example of something hard in git which is "trivial" in fossil is the timeline: a real-time navigation of all project history. git is not equipped to move through history like fossil can. sqlite does most of fossil's heavy lifting.
@SJGames it turns out that the first(?) #OGRE story was published in 1931(!!!), writing about a fictional war of 1941-43 in which soldiers fired 30-caliber rounds as powerful as 6 pounds of TNT: https://t.co/b869zopGgi (Murray Leinster, "Morale: A Story of the War of 1941-43")
Hey, @SJGames - your bronze Mark IV #Ogre#mini is now done. With a couple layers of gloss varnish, it's looking pretty snazzy (i don't mind saying). Possibly my best paint job to date. My repeated eternal thanks to @TwoBatsGaming for the wash formula which made this possible.
@fateswarning86 It's not about Reagan, per se, it's just that 1983-86 had so many memorable, unbeatable hits. It was a golden era for modern music. REO Speedwagon, baby!
@doctorow@nyrath That's not different from human job specialization. Cars work "by magic" with "mechanical magicians" to fix them. Computers work "by magic" with software people to maintain them. Health care... etc., etc., etc. We necessarily rely on specialists in every field.
@SJGames After painstakingly adding micro-highlights with gold ink... The difference is too subtle to convey with my camera, but i'm exceedingly pleased with the results (especially in daylight, rather than this florescent light). Can't wait to get this sealed.