What's the best relational database model for Nostr? Just event and tag tables or tags as JSON objects inside the events table? Or maybe best to use a native array column for tags?
Does the randomness of the hex keys (event id, pubkey) affect the indexing performance?
I’ve learned to generally avoid jsonb fields as much as possible. It never seems like a mistake until it does.
Please Login to reply.
No replies yet.
