Nostr Database strategies:
1. Build indexes for every possible combination of filters: It's fast, but needs a ton (GBs) of memory and 10x your database size in disk. Works great for servers.
2. Don't index all tags: Some filters just won't work and it won't find stuff, but it is fast and memory/disk efficient. Works great for small apps that have known filter needs.
3. Delete events as soon as the app doesn't need them anymore: It's fast and memory/disk efficient, but search sucks and figuring out what can be deleted is a major hassle.
Did I miss anything?