>It took me all of 1 hour to learn how to use prisma.
That is not how this works at all. You don't know what you don't know until you need "how do I do this query in prisma". You then spend an hour trying to figure it out, and maybe it isn't possible, then on to the next thing. It takes more than an hour to learn SQL, so if it takes you an hour to learn Prisma, you are missing something.
I would rather forget everything about Prisma the second I wake up in the morning and have to read their docs on how to do everything all over again, every single day, than try to understand what the heck is going on in SQL's docs.
> It took me all of 1 hour to learn how to use prisma. It’s not as hard as you make it seem.
That's because the ORM cannot do a lot. Unless you're doing extremely simple SQL queries it will not handle what you want it to do. Now what? Drop into RAW sql and lose all type safety and you are on your own.
No thanks, I started using Prisma for https://listifi.app and switched it over to knex.js because the second I hit a query that Prisma couldn't handle I was on my own. Knex on the other hand could handle everything because it's a simple query builder.
They have a vs code extension for editing the prisma schema.
It’s not hard to see that you make fields “String” @unique, etc.
Just make one model and that’s 80% of anything you ever need.
Want to make a relation? Make a new model
model Posts { users User[] }
Hit save, it adds the required code to relate it to the User model.
Run the generate command. Make a client instance.
Create something: db.NameOfModel.create()
And as you’re typing, typescript is auto completing it.
There’s barely anything else to learn. And it’s a quick doc search away.
Don’t hate on it because you love sql, it’s a great tool.