feat: ORM for db migrations - Githubissues

incubrain / astrotribe

A global network of astronomers helping to inspire and educate the next generation.

https://astrotribe.vercel.app

6 stars 2 forks source link

feat: ORM for db migrations #83

Open Drew-Macgibbon opened 1 year ago

Drew-Macgibbon commented 1 year ago

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
unlikely hires will know

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
hires are more likely to know
has db client GUI

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.