Doug Hoyte on Nostr: Hey guys, sorry for the delay! Just to clarify: You'd like it so a particular user ...
Hey guys, sorry for the delay!
Just to clarify: You'd like it so a particular user (authenticated in some way, maybe NIP-42?) can only access a subset of the keys in the DB?
I think that would be possible (assuming authentication is implemented of course). As Mike sas, it wouldn't be quite as easy as with SQL, where you could add a WHERE clause to all the required queries. However, I think you could do it in a way that wouldn't affect performance drastically.
If the sets of events for each user are mostly disjoint (not too many duplicated), then you could possibly run a strfry instance for each user. A running instance has a relatively low overhead, especially if you scale down the various thread counts.
Just to clarify: You'd like it so a particular user (authenticated in some way, maybe NIP-42?) can only access a subset of the keys in the DB?
I think that would be possible (assuming authentication is implemented of course). As Mike sas, it wouldn't be quite as easy as with SQL, where you could add a WHERE clause to all the required queries. However, I think you could do it in a way that wouldn't affect performance drastically.
If the sets of events for each user are mostly disjoint (not too many duplicated), then you could possibly run a strfry instance for each user. A running instance has a relatively low overhead, especially if you scale down the various thread counts.