Tilman Roeder
Tilman Roeder
This might be related to #165, are your running your tests on a Mac?
Hm yeah. Not sure what we can do outside of making deno itself faster? We could try to buffer writes internally and only go to deno when sqlite requests a...
Interesting! Enabling WAL is tricky, since that requires memory-mapping the file; (although we might be able to make it work by hacking around with a shared WASM buffer? But it...
It might be possible to enable WAL, if we use EXCLUSIVE locking: https://sqlite.org/wal.html#noshm (given that we don’t have a good way to get mapped files in deno for now)
This might be the issue? Either way we should probably bump the version, so we might as well and see if that fixes the issues you’re seeing 😊
@andykais can you confirm if upgrading SQLite fixes the issue? 😅
@andykais do you have a minimal example to reproduce the issue by any chance? I don’t think we can make progress on debugging the issue otherwise 😅
Hm, I'm still torn what would be the best approach here. There are four situations / things one might want to do: 1. get exactly one row (throws when `numRows...
I really like this idea and think something like this could work quite nicely! Doing this from JS would probably be relatively slow, but you could build a table of...
Just to capture some recent thoughts here: This is definitely possible (see https://www.sqlite.org/c3ref/create_function.html): - We can have users register (per-db) functions; the SQLite API allows us to pass some arbitrary...