Vitor Pamplona on Nostr: What's the best relational database model for Nostr? Just event and tag tables or ...
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?
Published at
2023-03-24 22:56:56Event JSON
{
"id": "c1f3b19b33f7bc4ebff97720a9f70664cf011952211686c5c0c45ef92938941a",
"pubkey": "460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c",
"created_at": 1679698616,
"kind": 1,
"tags": [],
"content": "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? \n\nDoes the randomness of the hex keys (event id, pubkey) affect the indexing performance? ",
"sig": "7ee4d9218df8c9555233f39bae1551a47927da6c58f11091044741673461122ae758b7c50b4e9db8f723db5dd0748ea9f949c27b94f0f2fe7a59cbd9ad847b11"
}
