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?