(sqlite.org)

506 points whatever3 | 1 comments | 15 Oct 24 17:45 UTC | HN request time: 0s | source

Show context

jjcm ◴[15 Oct 24 18:58 UTC] No.41851916[source]▶

As a general question, in what scenarios is it more beneficial to send the full DB and let the browser handle the queries? Maybe phrased a better way - when would I use this to improve a user experience over the traditional server-hosted db model?

replies(4): >>41851976 #>>41851993 #>>41852807 #>>41855888 #

1. ThatPlayer ◴[15 Oct 24 20:33 UTC] No.41852807[source]▶

>>41851916 #

Personally I'm using it for a statically hosted website, so a server-hosted database was never an option. Also with the right driver, it's possible to stream the chunks of the database as needed rather than sending the full database: https://github.com/mmomtchev/sqlite-wasm-http

I can even do Sqlite's full text search without downloading the entire FTS database. Just most of it, if the search term is short enough.

↑

Sqlite3 WebAssembly