Yes, agreed on SQLite/Postgres. But I'm going to benchmark RocksDB next and see what the performance characteristics are. I suspect the LSM tree storage engine of RocksDB might perform better since agents are so write heavy when running highly concurrent workloads. After all, you are streaming LLM tokens into disk and fanning them out to subscribed clients.
replyYou might want to start here: https://docs.cozodb.org/en/latest/releases/v0.3.html
replyThank you for sharing a benchmark pretty much exactly like the parent comment is planning to do.
replyAlso thanks for the incidental exposure to a DB I'd never heard of before... with a browser-based demo CozoDB may be a good way to start experimenting with Datalog.
That project has 0 commits for 2 years.
replyWhat does that have to do with their research on the exact topic OP was looking into?
replyAbandoned research of unknown quality is strong signal to downprioritize that direction
replySounds pretty stable
replyv0.7 with the following disclaimer:
reply> Versions before 1.0 do not promise syntax/API stability or storage compatibility.