As much as I'm a fan of SQL, for this id go with LMDB. The structure of nostr events is more conducive to KV. Switching from one to the other will require changing your data access layer. There's no simple drop in library replacement AFAIK. And if there were, it'd likely cost some performance and memory footprint to normalize