sgbeal

34 ms·

601.
by sgbeal 4y ago
> very cool to look at the unpacked module, in all its wasm glory Very nice :). Be aware that the copy of sqlite3.wasm on the sqlite.org/wasm site gets updated fairly frequently, so may differ from that at any moment. That particula
602.
by sgbeal 4y ago
> I think there may be a space for super-large multi-GB files served from static storage being accessible from SQlite as well. Another one would be this full-text search of a 43GB SQLite database of Wikipedia's full text search To t
603.
by sgbeal 4y ago
> SQLite was one of the first large C code bases to be ported to the web. Thank you very much for that info. i'll update the sqlite wasm docs with that. Edit: updated, thank you! < https://sqlite.org/wasm/info
604.
by sgbeal 4y ago
> Browser support is currently limited to Chrome and Edge. Firefox and Safari don't support this yet. Within the sqlite project we're fairly convinced that FF and Safari will catch up as soon as their larger customers start tar
605.
by sgbeal 4y ago
> That's why it's used in millions of Android devices s/millions/billions/g. It is widely believed to be either the single most widely-deployed piece of software in the world, or maybe second behind zlib (we have
606.
by sgbeal 4y ago
> Sqlite updates are solid and as far as I know, do not break your code. That applies to the C code. The wasm code is still in beta, and won't see a public beta release until 3.40 is released in November. See the notes about API sta
607.
by sgbeal 4y ago
> Oooff, 266 KB is a hefty price to pay. i think you'll find that many high-end websites often download more than a megabyte of CSS and JS code. imdb.com home page: 2.13mb transferred for 6.odd mb data. drive.google.com: 4.75mb tran
608.
by sgbeal 4y ago
> On the topic of caching, since SQLite is (intentionally or not) going to be setting an example with their docs and demos[0], I would suggest that SQLite should demonstrate the industry best practices with regards to caching as well. St
609.
by sgbeal 4y ago
> As a little pro-tip, the demos appear to be serving a gzip compressed WASM file, but offering a brotli compressed version for clients that say they accept it would be even better: That is interesting, but the repository you're loo
610.
by sgbeal 4y ago
> Most websites have no reason to use it; simple key/value localStorage is enough for many sites or apps that need some sort of storage. In case you hadn't noticed it, the new sqlite features include using localStorage and sess
611.
by sgbeal 4y ago
> WebSQL would have been tied to one specific version of SQLite, and developers would have to work to the lowest supported version. There would have been no extension mechanism. Not only that, but WebSQL disables a lot of mundane functio
612.
by sgbeal 4y ago
> I find it kinda sad that browsers get to remove Web SQL on shaky grounds (which was just sqlite available to JS) i recently had to work with WebSQL in the context of comparing it to sqlite's new WASM support (of which i'm the
613.
by sgbeal 4y ago
Woot! It's lovely to see someone other than oneself hype one's own code ;). The first beta of the wasm/js bits will be officially released along with sqlite3 version 3.40. We've been working on them since (IIRC) May. i f
614.
by sgbeal 4y ago
> Isn't fossil younger than git? They were initially developed in parallel. To the very best of my recollection, Richard had no knowledge of git when he started fossil. Fossil's initial development dates back to 2005, IIRC, (ed
615.
by sgbeal 4y ago
> The whole point of using SQLite as a foundation for distributed, edge, or other stuff is that it's a solid foundation that can be trusted to not change too much. Just to clarify: sqlite3 changes almost literally every day[^1]. How
616.
by sgbeal 4y ago
> Also, SQLite's VFS API can do a lot there already. For example, I remember seeing SQLite compiled to WASM, using a VFS that downloads a remote database on S3 using HTTP Range requests. (I don't think it supported writing to t
617.
by sgbeal 4y ago
> Part of the beauty of SQLite is the single .c/.h thing. Noting that it's not _developed_ that way. Its many files are compounded together by the build process to produce the amalgamation build. In a mixed-language project (Ru
618.
by sgbeal 4y ago
> The web app we develop has occasional issues with Safari that we need to look into. Things not working in both Firefox and Chrome is extremely rare for us and usually fixed pretty easily in the rare case we notice it. FWIW, that mirror
619.
by sgbeal 4y ago
i can't speak to the high-level wrappers, but the native C API for MySQL is atrocious , the one for PostGres is meh , and the OCI is also (in my very limited experience) also meh . sqlite's C API (its core-most product) is a dr
620.
by sgbeal 4y ago
> Do you work for fly.io? Horrible way to represent the company like this! Wha!?!?? The top post is very specifically about sqlite3, not fly.io (whatever that is). Your comment about it was taken entirely within the context of sqlite, no
621.
by sgbeal 4y ago
> but if the intent was "show me places sqlite is used as a database backend for user-facing web software", the Nim forum Perhaps more appropriately, sqlite's own forum is sqlite-backed: < https://sqlite.org&#
622.
by sgbeal 4y ago
> edit: not sure why this is being downvoted? not being able to define a range of port seems like a huge oversight. It's likely been downvoted because your feature request demonstrates that you're not asking about sqlite. sqlit
623.
by sgbeal 4y ago
> For some reason, IME, SQLite feels the hardest to use of the popular databases. sqlite is, above all else, a C API for interacting with a database. Try using the C APIs for Postgres or MySQL or Oracle/OCI, and i _guaranty_ you you
624.
by sgbeal 4y ago
Funnily enough: the WebSQL standardization effort was abandoned _because_ all implementors were basing theirs on sqlite (citation: https://www.w3.org/TR/webdatabase/ ). By convention, standards efforts (except for
625.
by sgbeal 4y ago
> I’d like to use a web service or app backed primarily by SQLite and see how it goes. Look no further than sqlite's own source control system: < https://fossil-scm.org > i've used that site almost daily since t
626.
by sgbeal 4y ago
> ... in millions of devices... cough _Billions_ cough with a capital "B". Very nearly every non-trivial electronic device built over the past 10-15 years. (Non-trivial being very roughly: "anything with a UI or havin
627.
by sgbeal 4y ago
FWIW... i've been in Richard's presence several times when he was asked how to pronounce it by various people and he's invariably answered, "pronounce it however you like !" (i belong to the ess-queue-lite school o
628.
by sgbeal 4y ago
> it's probably more about developer time, maintenance burden, etc. That's a large part of it, yes. The sqlite project has only 2 full-time core developers and, AFAIK, only 3 current part-timers who tend to work on more "o
629.
by sgbeal 4y ago
> Yes, but they probably should not be buying experimental products for this purpose. You misunderstand. i didn't back the phone/laptop. i backed the first pine64 boards, which were marketed as being much more capable than they
630.
by sgbeal 4y ago
> So you backed a developer-oriented project all about open source software and your test to see if it was garbage or not is to consume proprietary video content and play video games through virtualization? The referenced Kickstart was f

More ›