News for hackers. Stuff that matters.
Re:SQLite compiled into JavaScript via Emscripten by bobajeff on Thursday September 10, 2015 @06:05PM (#10200851)
>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?

Re:SQLite compiled into JavaScript via Emscripten by AndrewGaspar on Thursday September 10, 2015 @06:47PM (#10201034)
Not 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.
Re:SQLite compiled into JavaScript via Emscripten by TazeTSchnitzel on Thursday September 10, 2015 @07:29PM (#10201177)
SQLite 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.