nostr taught me that sql is actually slow as balls, or maybe that everything is slower than lmdb
Discussion
According to benchmarks at https://github.com/fiatjaf/eventstore my LMDB-based store is 4000x faster than SQLite.
Woah. No wonder SQL alternatives have been so popular in recent years.