3 ms·
If you want SQLite backed by S3, maybe something like SQLite in :memory: mode with Litestream would work? Edit: actually not sure if you can use :memory: mode
by abound 2y ago
If you want SQLite backed by S3, maybe something like SQLite in :memory: mode with Litestream would work?
Edit: actually not sure if you can use :memory: mode since Litestream uses the WAL (IIRC), so maybe a ramfs instead
- anon291 2y agoThere are many solutions. The particular example I was using SQLite via webassembly and then resorting to HTTP's fetch api for a read-only solution.
- candiddevmike 2y agoIn my experience, SQLite on S3 is ridiculously slow. The round trip for writes is horrendous, so you end up doing batch saves, but you need a WAL, which has the same problem as the main DB file.