mirrors my own experience creating a persistent event log. I started with JSON, then JSONL, etc until finally landing on SQLite.