one thing you may want to do is separate the actual DB logic and what I call the index provider

that basically allows you to swap the query planner and index generation logic, and allows making search very easy (tokenize => save as individual index entries)

index changes become easy too, as all you need to do is reindex all events in place, with no interruptions, and after that’s done enable the new indexes