4 ms·
I've actually prototyped this recently, but never got around to packaging it up into a library. There are a few neat adjacent things that it can be used for (e
by antimatter15 6y ago
I've actually prototyped this recently, but never got around to packaging it up into a library.
There are a few neat adjacent things that it can be used for (e.g. opening big SQLite files on disk without reading it all to memory), building something like Datasette (https://github.com/simonw/datasette https://github.com/simonw/datasette) that can run queries on data hosted as static files, or for (as you suggested) using SQLite in a browser with persistence.
For that particular use case, there's a bit of complexity related to mutexes and stuff in trying to prevent simultaneous browser tabs doing write operations from corrupting the database.