Hi Guys ๐
welcome back.
Finally, today it's time to create our database, so don't waste time, and get started.
How can you create your database?
It's simple! You have to run the following script:
npx prisma db push
This script creates in your prisma
folder a SQLite database called dev.db
.
The database's name is taken from the variable DATABASE_URL
in the .env
file and inside of the file you can find the next table.
Ok, now you have your database so it's time to get back at the challenge left open last article.
Run the script
yarn dev
{ posts: [] }
Ok, there aren't data but it works ๐ฅณ
So now you have a database and you can search data inside it, at this point, it's time to create relations between our entities, but it's the goal of the next article ๐คช
That's all for today guys!
See you soon
Bye Bye ๐
You can find the code relative to this post here
Top comments (3)
It is possible to have a setup up with mongo db? I'm trying to setup with mongo but constantly getting an error.
Hey @gersonec ,
Try to take a look at this repo. You can find a fastify app with prisma and mongodb.
Let me know if you resolve the problem.
Another check you can do is to check if you have the option
?authSource=admin
in your connection string.That option in the connection string solved my problem! Thanks a lot!