3 ms·
>Doesn't support in-place editing of a db. I wonder why that is. Is it just a fuction they simply didn't create a binding for? Or is it some performance concer
by bobajeff 11y ago
>Doesn't support in-place editing of a db.
I wonder why that is. Is it just a fuction they simply didn't create a binding for? Or is it some performance concern?
- AndrewGaspar 11y agoNot OP, but I imagine it's a couple things: 1) No clear mapping between file APIs that SQLite uses and browser file APIs. 2) SQLite uses blocking file I/O internally which is generally a big no-no for JavaScript due to it being single threaded.
- TazeTSchnitzel 11y agoSQLite is proably saving files in emscripten's virtual filesystem (emscripten's implementation of fopen() etc. by default makes them work on memory), and the sql.js API just reads and writes the file there.