feat: Add option to install DrizzleORM - Githubissues

sidebase / create-sidebase

Create a Nuxt 3 web application with the sidebase stack

MIT License

25 stars 3 forks source link

feat: Add option to install DrizzleORM #31

Closed zoey-kaiser closed 7 months ago

zoey-kaiser commented 1 year ago

Depends on #30

Adds support for another ORM: Drizzle.

Questions:

As I added another ORM, that conflicts with PrismaORM, do we want to seperate which ORM you want into another questions, or keep it so that in theory you could install both? In this PR, as it is a POC, I added it to the modules list, meaning through this PR, you could install two different ORMS.

Checklist:

[ ] issue number linked above after pound (#)
- replace "Closes " with "Contributes to" or other if this PR does not close the issue
[ ] manually checked my feature / checking not applicable
[ ] wrote tests / testing not applicable
[ ] attached screenshots / screenshot not applicable

zoey-kaiser commented 1 year ago

@BracketJohn, the next questions for me would be:

Is my implementation good? I used the Drizzle docs to integrate it into Nuxt, as well as this tutorial: https://dev.to/aaronksaunders/drizzle-orm-sqlite-and-nuxt-js-getting-started-374m
I decided to use better-sqlite3 as the database.
- PrismaORM uses sqlite, so it made sense to stick with it
- This packaged looked the best of the supported sqlite packages
- best in benchmarks See stats overview
- Good rating
- Active matience
Do we want to add some kind of middleware to make using the queries even easier (like with PrismaORM)
Do you have any other recommendations on how we could improve the DX of Drizzle in sidebase?