Is the best postgres damus relay really written in typescript? I feel like something more performant could be used. Might write one in scala using same db schema.
Discussion
Nostr relay *🤦♂️
Would be nice to see relay implementations to use the same schema and allow relay operators to easily switch between one implementation to another while maintaining the same events DB.
Schemas are driven by the DB. Schemas, indexes, and queries need to be tailored to capabilities and strengths of each DB engine.
Typescript was a great choice too. Postgres seems to be doing all the heavy lifting.