DEV Community

Discussion on: Set up a free PostgreSQL database on Supabase to use with Prisma

Collapse
 
aftabbuddy profile image
Aftab Alam

Hey, though you asked @thisismahmoud I think I have the answer :-)

This article is for Prisma users(and it's written from Prisma's point of view), who use it for everything ranging from DB Management, CRUD operations to Migrations. Prisma works with a PostgreSQL instance (local or cloud) and Supabase let's you connect with the DB that powers your apps directly too. So, in Supabase, Prisma has found one more great cloud-managed PostgreSQL instance that you can connect with following the instructions shared in this article.

@thisismahmoud Hope, that's an all right explanation?

Collapse
 
zernonia profile image
Zernonia

Everything make sense when you said this is for Prisma users. As I am not one of them, I got confused.

Thank you for your input yar!

Collapse
 
thisismahmoud profile image
Mahmoud Abdelwahab

Yup that's a perfect answer! thank you so much 😄

Thread Thread
 
amosbastian profile image
Amos Bastian

Then what is the benefit of using Supabase with Prisma over just having your own Postgres database on the same server as your API?

Thread Thread
 
aftabbuddy profile image
Aftab Alam

The article just shows how easy it is to use Prisma with a cloud PostgreSQL instance. Supabase letting you access the PostgreSQL instance and independently use it, is a very powerful thing. You can prefer to use Supabase client, to perform Auth, and CRUD operation, for which Supabase is known for, but if you don't want that you can also interact with the DB that powers it, to have your hand-rolled, or Prisma-rolled CRUD methods and have it behave as you like.

Prisma loves(and plays well) PostgreSQL(your instance) or PostegreSQL(cloud instance: Heroku, Supabase, Planetscale, etc.) equally. Consider this just as a reference to one more possible integration type you may chose and it's not particularly Supbase v/s. your DB.