James Long

@nolanlawson you are correct! Switching to `getAll` and summing 400,000 items takes ~3100ms instead of a wild ~8100ms. That's Chrome btw, with cursors Firefox only takes ~5100ms (I've found cursors...

I'll do some more digging, but I think cursors might be find in absurd-sql's case. The problem with cursors seems to be the jumping back and forth between IDB and...

It's already cached in `openFile`: https://gist.github.com/jlongster/ec00ddbb47b4b29897ab5939b8e32fbe#file-webkitfilesystem-backend-js-L8 I'm going to open a PR with initial implementation though. It's using the sync API which is a lot simpler. Wait until then to...

Just opened a PR: https://github.com/jlongster/absurd-sql/pull/13

Oh wow, this is super interesting, thanks @pkhuong! > or maybe simplify the locking mechanism to jump over the "reserved/pending" states, and only have shared & exclusive. That's actually how...

I think locking the file for a whole time that a `BEGIN TRANSACTION` and `COMMIT` happens should be robust -- if things can change underneath that it seriously undermines the...

Hello! > Do you have a sense for the performance of storing Blobs in IndexedDB vs using this library? For that use case, using SQLite is probably not appropriate. Storing...

Sorry, I just saw this now! I will take a look tonight and merge it in. Thanks!

Done. Use the same URLs above. That's very weird; I'm using nightly now (19.0a1) and with the rendering turned off still get ~200ms with LLJS and ~90ms without it. That's...

Just tried it on my wife's Macbook Air (newest model) with Firefox 16, and got similar numbers to mine.