mjadobson
Joined 13 years ago
Karma
202
Submissions
19
Member since
Oct 26
Joined 13 years ago
I thought the bundle size of wasm-sqlite would be prohibitive, but it's surprisingly quick to download and boot. Reducing network reliance solves so many problems and corner-cases in my web app. Having access to local data makes everything very snappy too - the user experience is much better. Even if the user's offline data is wiped by the browser (offline storage limits are a bit of a minefield), it is straightforward to get all synced changes back from the server.
1. Summarise some prose (from a textbook) into bullet points
2. Convert these to flashcards
3. Make these flashcards more concise
I then verify they are correct/relevant, only keeping those that are worthwhile.
Some of the API naming is similar (db_version, site_id, seq, commit_alter, etc), although the project source is very different (C rather than Rust, different feature set).
crsqlite is no longer maintained so I might be interested in migrating.