sgbeal

48 ms·

661.
by sgbeal 4y ago
> I played with it for a minute, and the feature I want is just a checkbox to reset the database each time I run the query. After experimenting, i'm extremely hesitant to add the option to _automatically_ nuke the db each time input
662.
by sgbeal 4y ago
> What you do is build a very cut-down Linux system, bubybox style, as wasm, and deliver that. Though i'd very much like to see such a thing, that's well, well, _well_ outside the scope of this project. If someone wants to crea
663.
by sgbeal 4y ago
> you're either selling something or you just don't know what you're talking about. There's no need to be combative. i've been programming since the 80s (mid-90s professionally), and in _no way_ long to return to
664.
by sgbeal 4y ago
> Yep, definitely Firefox. In To be clear, i wasn't badmouthing FF (all of fiddle's develoment so far, aside from occasional individual tests) has been in FF on Linux. That one particular FF feature kinda gets my goat, though,
665.
by sgbeal 4y ago
> This is fairly easy to recreate on your computer. It is trivial to. The only tiny hiccup is that the wasm file cannot be served via a file:// URL due to XHR restrictions, so you'll need a local webserver for it. No big d
666.
by sgbeal 4y ago
> Thats interesting, so it will be an "official" WASM JS binding for SQLite? That's not guaranteed/official yet but it has been discussed and seems to be where we're headed. In the end it's Richard's de
667.
by sgbeal 4y ago
> I played with it for a minute, and the feature I want is a checkbox to reset the database each time I run the query. That's a good idea. There are tons of options i'd _like_ to add to it but have not simply for UI space'
668.
by sgbeal 4y ago
> root root 573376 2010-10-20 09:55 /usr/lib/libsqlite3.so.0.8.6 In all fairness, though: sqlite3 was much smaller in 2010 ;). Similarly, libdb and libmysqlclient were probably smaller in 2008/2009. My locally-install
669.
by sgbeal 4y ago
> I’m currently on mobile, but was excited when `shift + enter` still executed the sql! You got lucky - that was untested on non-keyboarded machines ;). There's a "run" button at the bottom intended primarily for mobile us
670.
by sgbeal 4y ago
> This throws me back to the good ol' days of fitting all software in a few dozens/hundreds of KBs on Speccy and similar systems. And yet very few developers would want to go back to the days when we had no syntax highlighting
671.
by sgbeal 4y ago
> make the shell prompt interactive On my dev system i have a build of fiddle which uses the jquery.terminal plugin as the main interface (with a button to toggle between it and the current UI), but it relies on 3rd-party code which is n
672.
by sgbeal 4y ago
> This is nice, but more of a console than a fiddle. It's a binding of the sqlite3 console app, so that's an appropriate contrast. We're not trying to supplant such services as sqlfiddle and the wild world of wasm is entir
673.
by sgbeal 4y ago
> ... another nice WASM-based browser SQLite user interface. Thank you for pointing that one out. Every conceptually similar project is a great source of ideas. sqlite's fiddle app is literally less than 2 weeks old so still has lot
674.
by sgbeal 4y ago
> There is a project called "Absurd SQL" to back SQLite with a custom block based FS on top of IndexedDB. It is somewhat absurd but it works incredibly well! (The fiddle dev here...) That is, AFAIK, the current state of the art
675.
by sgbeal 4y ago
> I doubt wasm-bindgen will be your cup of tea as it’s Rust stuff, though perhaps there may be value in looking at what it generates. Yeah, Rust isn't part of the sqlite project's toolchain, but wasm is entirely new to the proj
676.
by sgbeal 4y ago
> 330kb over the wire with brotli. Thats sizable, but definitely usable in a heavier web app. My almost-most-used website (boardgamegeek.com) currently serves 500-odd kb of minified CSS and 2MB of minified JS. That is to say: in the cont
677.
by sgbeal 4y ago
> definitely considerably worse than wasm-bindgen’s, Thank you, wasm-bindgen is a new term for me (wasm as a whole is new to me since about 2 weeks). i'll add that to the list of tools to check out, as we're actively exploring
678.
by sgbeal 4y ago
> Happy to see some zero-dependency VanillaJS. You're welcome :). Frankly, since the HTML5-related JS changes were standardized, jquery is no longer the "absolute must-have" it was prior to that, and i strive to use only v
679.
by sgbeal 4y ago
> We can finally get rid of IndexedDB, Not quite yet: indexeddb can be stored persistently whereas wasm-side sqlite dbs cannot (unless they're stored _in_ an indexeddb). Someday the JS filesystem APIs may offer such a thing, but rig
680.
by sgbeal 4y ago
> And the web server, depending on the `Accept-Encoding` header, would serve the right file. This web server (also part of the sqlite family of projects) doesn't yet know how to do that. https://sqlite.org/althttpd
681.
by sgbeal 4y ago
> I know that I’m never impressed with the JavaScript side of the bindings produced by Empscripten i don't mind saying, having spent much of the past 2 weeks in and around that code, that much of the generated part of the JS/wa
682.
by sgbeal 4y ago
> ... is there some renewed/newfound interest in SQLite lately? If so, what's behind that? Though i share that observation, in this particular case it's very likely coincidence. i've worked with Richard since 2008 on
683.
by sgbeal 4y ago
sql.js is quite similar but not quite the same thing. They produce a high-level wrapper of the C API, but they do not offer a binding of the shell app (which is what fiddle is). The latter requires, due to how emscripten wraps the C functio
684.
by sgbeal 4y ago
> 898KB even without compression. Pretty good. gzip'd it's roughly half of that but that particular web server (althttpd) doesn't (yet?) know how to compress output payloads.
685.
by sgbeal 4y ago
> Given that this SQLite variant is WASM-based, how does this relate to Cloudflare recent D1 announcement where you can use Workers (WASM) to connect to an SQLite datastore? They're conceptually similar but, while i'm intimatel
686.
by sgbeal 4y ago
> For production use, presumably you’d use an optimized binary That particular one is built with -Oz (optimized for the smallest size). Development itself is done with -O0 (no optimizations) because the compile time difference is somethi
687.
by sgbeal 4y ago
> and it's only 900KiB extra bundle size! Depending on how it's compiled, yes. It can be as large as 2MB when built with no optimizations.
688.
SQLite 3 Fiddle(sqlite.org)
765 points by sgbeal 4y ago|136 comments
689.
by sgbeal 4y ago
Richard Hipp, of sqlite fame, just announced the project's new WASM-based "fiddle" app in the sqlite forum ( https://sqlite.org/forum/forumpost/5cfd681451 ), providing a way for users to run a slightl
690.
by sgbeal 4y ago
The article's author seems surprised that there's a flat-file forum. What if we told them that the Fossil SCM is a flat-file (sqlite3) forum, wiki, _and_ SCM all in the same flat file? (Commenting on the original article requires

More ›