Are you maintaining a separate relational db so you can look up Alice’s followers without cycling through every kind 3 note in your db?
no that would be retarded. i would process kind 3s as they come in and update the who follows who index
Please Login to reply.
And the who follows who index is in a relational DB? Or LMDB?
nostrdb is lmdb. you don't need relational for anything. its all key values anyways.
even sql builds its indices on btrees... relational or lmdb its still btrees all the way down