atomic-server
atomic-server copied to clipboard
Sqlite storage
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.