server: add orm for db connections

[Drew-Macgibbon]

Drizzle:

Pros:

• cost reduction by bundling joins into a single query
• great ts support

Cons:

• may not be production ready (relatively new, not as battle tested)
• small development team
• documentation is not as good

prisma:

Pros:

• Prisma 5.0 was just released, it addresses the cold start issues
• great documentation and by far the more popular choice
• larger development team

Cons:

• Performing joins is not optimized, and requires multiple queries to the DB (PG Bouncer should mitigate this) it is also being worked on
• PostGIS support is a work in progress (spacial queries for location-specific functionality)

Decision

We will use Prisma, it will allow us to move faster, and by the time the cons become problematic (10k+ users) I suspect the Prisma team will have fixed the issues.

[Drew-Macgibbon]

duplicate issue