←back to thread

Sqlite3 WebAssembly

(sqlite.org)
506 points whatever3 | 2 comments | 15 Oct 24 17:45 UTC | HN request time: 0s | source
Show context
TiredGuy ◴[15 Oct 24 18:04 UTC] No.41851263[source]▶
So after downloading from the official downloads page and stripping away all the mjs files and "bundler-friendly" files, a minimal sqlite wasm dependency will be about 1.3MB.

For an in-browser app, that seems a bit much but of course wasm runs in other places these days where it might make more sense.

replies(8): >>41851337 #>>41851618 #>>41851622 #>>41851724 #>>41851840 #>>41852258 #>>41854092 #>>41855860 #
jsheard ◴[15 Oct 24 18:32 UTC] No.41851622[source]▶
It's pretty compressible at least, sqlite3.js+wasm are 1.3MB raw but minifying the JS and then compressing both files with Brotli gets them down to 410KB.
replies(1): >>41852828 #
rmbyrro ◴[15 Oct 24 20:35 UTC] No.41852828[source]▶
A lot of HTML's nowadays have 100 - 300 kb. That's only the HTML (!!).

Adding 400 for such a high quality piece of DB actually borders reasonability.

And makes me think: what the hell are frontend devs thinking!? Multiple MB's in JS for a news website. Hundreds of KB's for HTML. It's totally unreasonable.

replies(2): >>41853979 #>>41854129 #
1. jsheard ◴[15 Oct 24 23:22 UTC] No.41854129[source]▶
> A lot of HTML's nowadays have 100 - 300 kb. That's only the HTML (!!).

I think you can probably blame Tailwind for that.

replies(1): >>41856625 #
2. yoavm ◴[16 Oct 24 07:51 UTC] No.41856625[source]▶
Why? More often than not the classes are combined during post-processing to the most reusable unified classes, with very short classes names.