i don't really need a full blown graph db for wot though. just a few indices (followers of A, who A follows) for all A. plus a few other things

Reply to this note

Please Login to reply.

Discussion

Follows are a weak trust signal, but it's better than nothing.

right, there would be more to the algo obviously. but just those two indices would already be really useful for lots of things. the full algo would be personalized pagerank + custom metrics (zaps, reactions, etc)

Have you thought about how to make those metrics available to other nostr clients? I’m thinking specifically of nostr:npub1gcxzte5zlkncx26j68ez60fzkvtkm9e0vrwdcvsjakxf9mu9qewqlfnj5z‘s Trusted Assertions NIP.

not really no

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

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