4 ms·
Interesting! I really like your wasm compiled SQLite more than the pure Go one, so it is what I use most of the time. What exactly are you trying to port?
by koeng 1y ago
Interesting! I really like your wasm compiled SQLite more than the pure Go one, so it is what I use most of the time.
What exactly are you trying to port?
- ncruces 1y agoA VFS that allows you to directly open a Litestream replication target (e.g. S3) as a read-only database and run queries against it without ever having to download the entire database (e.g. to an ephemeral instance that doesn't even have the disk space for it).
- koeng 1y agoInteresting. Any plans for a cache? Or would that just be a litestream thing
- ncruces 1y agoI… honestly don't know. I saw the announcement some time ago (the revamped post) and started following their repo. They did mention caching to hide latency. When I saw the v0.5.0 tag, I dived into just porting it. It's just over a couple hundred lines, and I have more experience with SQLite VFSes than most, so why not. But it's still pretty shaky.
- ncruces 1y agoMy version of the VFS should be ready for testing. After some testing, I expect it to be working correctly in the vast majority of cases, but the performance may disappoint. The original still needs work. https://github.com/ncruces/go-sqlite3/tree/litestream https://github.com/ncruces/go-sqlite3/tree/litestream