How to Get Started with Prisma? ORM
Is this outdated? https://youtu.be/bSyDUIus3BA?si=V_2EV9_jNUuCVaiS
Prisma
YouTube
How to create a PostgreSQL Database with Prisma's Data Platform
â— Version 2.28.0 Release notes: https://github.com/prisma/prisma/releases/tag/2.28.0
Prisma's 2.28.0 release includes some super convenient improvements to the project creation flow in the Prisma Data Platform. This allows you to provision a new PostgreSQL Database with Heroku, choose a template schema for common types of projects, and populate...
25 Replies
In the tutorial, the guy picks the name for the project and picks a sample structure and goes from there. When I tried doing the same, all I was asked for was the name of the project and it was created. I am confused though because I did not get to pick Postgresql or the repo name or anything.
Yeah that guide is out of date. Are you looking to have a hosted PostgreSQL db?
Yes
We're no longer offering that 🙂
I would recommend something like supabase or neon.tech for that
Supabase
Supabase | The Open Source Firebase Alternative
Build production-grade applications with a Postgres database, Authentication, instant APIs, Realtime, Functions, Storage and Vector embeddings. Start for free.
Neon
Neon — Serverless, Fault-Tolerant, Branchable Postgres
Postgres made for developers. Easy to Use, Scalable, Cost efficient solution for your next project.
I mean this is all I am trying to do. In the video, he skipped the step for how to obtain this DATABASE_URL
He said to use your own postgresql link, so I am not sure how to initialize my own db or get the link for this
hmmm well, if you're looking for just local testing, I would probably recommend using docker to run a postgresql db locally. Here's a how to guide from their site. https://www.docker.com/blog/how-to-use-the-postgres-docker-official-image/
Tyler Charboneau
Docker
How to Use the Postgres Docker Official Image | Docker
Check out our guide on how to use the Postgres Docker Official Image, including options for customization and data storage tips.
This is the requirements for the project. Sorry for sending a long description, I am completely new to Prisma and connecting the web to the database. However I would like your help to be sure that I am on the right track. Based on the description, is hosting it locally sufficient? (Note: I am working in a group).
Also, postgres is not required. I could go based on Oracle or Sqlite instead if that is whats causing the problem.
Yes. The DB will be hosted locally on your machine, but it is a real database and is not
JSON or local storage. If you're concerned I'd reach out to your instructor.If you'd prefer, our Quickstart uses SQLite: https://www.prisma.io/docs/getting-started/quickstart
Prisma
Quickstart with TypeScript & SQLite
Get started with Prisma ORM in 5 minutes. You will learn how to send queries to a SQLite database in a plain TypeScript script using Prisma Client.
Unknown User•8mo ago
Message Not Public
Sign In & Join Server To View
Yes this seems like the appropriate option, thanks a lot, Ill check it out!
Based on the project description, I think Prisma is required
Unknown User•8mo ago
Message Not Public
Sign In & Join Server To View
Oh neon is a database?
Do you recommend Neon over SQLite then?
Unknown User•8mo ago
Message Not Public
Sign In & Join Server To View
Okay, thanks
Ill check the link Jon sent for SQLite then check neon out if this doesn't work
Is Neon a relational DB?@EXILE
Unknown User•8mo ago
Message Not Public
Sign In & Join Server To View
Sorry if tagging isn't allowed. I have followed the initial steps in this doc to setup prisma ORM.
This was the generated DATABASE_URL, am I supposed to modify it or is everything setup now?
Because in the tutorial video he had his own personalized link. Mine doesn't look personalized, so I am not sure if Sqlite has been setup now or if I need to take further action?
Unknown User•8mo ago
Message Not Public
Sign In & Join Server To View
SQLite differs from other databases in that it's a database inside of a file. So, yes, that looks correct.
Also, just give it a go and find out! If you follow the quickstart instructions you will end up with a functioning app 🙂