Nostr Web Client

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?

fiatjaf 2y ago

On https:/github.com/fiatjaf/relayer I've done just event table, with fancy Postgres indexes for the tags, but I have no idea about performance. I believe #[1] used a separate table for tags on nostr-rs-relay, but I am not sure. #[0]?

As far as I know randomness of keys affect insert performance, not read.

Reply to this note

Please Login to reply.

Discussion

denis2342 2y ago

is that enough info?

Cameri🐦‍🔥 2y ago

Nostream uses a jsonb field for tags. But a tags table with correct indexes is more performant.

cc #[5]

Kieran 2y ago

I have about 20M tags on my DB it's hungry on CPU because tag quieries are usually the most common, threads and reactions, notifications etc, author lookups are much cheaper

Vitor Pamplona 2y ago

That was my main concern... I think I will do a separate table to make queries slightly faster.

Kieran 2y ago

Correction: 36M