-
@ mleku
2025-03-12 11:37:35i think you need to have a second table with pubkeys that refers to the event ids also, to do a full graph traversal i am very hazy on how to do things with sql, been a long time, i'm starting to get used to making custom index schemes explicitly with badger so yeah you do need a pubkeys table as well, each pubkey linked to others via several semantics, follow, mute and event id