I'm new to the database space, let alone creating one for nostr. where could I get started?
I do think we'd need some special permissions for kind 30041 (modular content - publishing multiple sections of an article) because of publishing notes at high frequency and 1986 (embeddings), of which the vectors could get quite large.
Maybe we can iterate on best practices and specs for both perspectives relay and events?
https://wikifreedia.xyz/nkbip-01/npub1m4ny6hjqzepn4rxknuq94c2gpqzr29ufkkw7ttcxyak7v43n6vvsajc2jl
https://wikifreedia.xyz/nkbip-02/npub1m3xdppkd0njmrqe2ma8a6ys39zvgp5k8u22mev8xsnqp4nh80srqhqa5sf
I was just reading these today! I'll have to make sure I'm handling NIP01 fully correctly before I can begin adding advanced improvements like this! I've already handled database interactions because the only data it accepts right now is events and I'm successfully rate limiting that. I just want to add more rate limits for requests and all types of messages. But the rate limiting is more for the websocket messages now and not the database.
alright, I think rate limiting is working :) . Time to make some tests for it! I've never made tests for anything. Wish me luck.