atomic-server icon indicating copy to clipboard operation
atomic-server copied to clipboard

Sqlite storage

Open AlexMikhalev opened this issue 2 months ago • 3 comments

Related Issues

closes #443

Checklist

  • [x] Add changelog entry linking to issue, describe API changes
  • [x] Add or update tests if needed
  • [ ] Update docs if needed

After experimenting with open dal, my conclusion is that the best replacement for sledge is SQLite in WAL mode. This is an implementation of it, including a connection pool which will take care of multi-node deployment. With SQLite instead of sled an Atomic server can be deployed on top of Turso or Cloudflare durable objects which will minimise infrastructure management - and allow standard backup and recovery tools. On the dev side, we can remove Tantivy and make a multi-criteria collection - the issue with export/import is a tantivy lock.

AlexMikhalev avatar Sep 19 '25 08:09 AlexMikhalev