Sql.js is awesome. It powers sqlteaching.com (on the client side), and the whole site took about 50 hours of work between my wife and I. Most of that time was on the curriculum.
FYI this is what powers the interactive SQL engine for the SQL classes on the Khan Academy. If you've never seen them, it is really cool.<p><a href="http://www.brianbondy.com/blog/168/sql-on-khan-academy-enabled-by-sqlite-sqljs-asmjs-and-emscripten" rel="nofollow">http://www.brianbondy.com/blog/168/sql-on-khan-academy-enabl...</a><p><a href="https://www.khanacademy.org/computing/computer-programming/sql" rel="nofollow">https://www.khanacademy.org/computing/computer-programming/s...</a>
Would be interesting to see how this benchmarks against the in-memory db of lovefield (<a href="https://github.com/google/lovefield" rel="nofollow">https://github.com/google/lovefield</a>)
Unfortunately, there are a few major downsides to sql.js:<p>1. Not API compatible with node-sqlite3, so you can't just drop it in and use it with knex or other wrappers.<p>2. Doesn't support in-place editing of a db. You have to load the entire DB into memory, modify it, and then save it back, making it unsuitable for any concurrent application.<p>I love the idea of the project though, and it would be awesome not to have to deal with compiling sqlite or using node-pregyp to build embedded chromium apps.
What I would love to see is a SQLite rewrite in Rust. Just enough to support WebSQL and appease Mozilla's concern about the lack of alternative implementations.
Did someone try to compile Zebra Crossing (ZXing) to JavaScript using Emscripten? I searched a lot, but sadly didn't find anyone who succeeded. And I don't have enough knowledge about C++ to try it myself.
SQL.js is a great library -- we use it on <a href="http://sqlbolt.com/" rel="nofollow">http://sqlbolt.com/</a> to teach SQL right in the browser in a platform agnostic way.
Been using this library for a while now. Works great, I based my app <a href="https://www.lightroomdashboard.com" rel="nofollow">https://www.lightroomdashboard.com</a> on it
I wonder how well this would work for shipping game assets in the browser. One of the nice things I miss about flash was having a single compiled object to store on the server and distribute to end users which contained all the assets and sounds needed for the game. Stuffing all your assets into a sqlite database and sending that over the wire would keep everything nice and tidy.