PG extensions and database credentials
Hello team, I have 2 questions:
1) I added
generator client {
provider = "prisma-client-js"
previewFeatures = ["postgresqlExtensions"]
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
extensions = [pgvector(map: "vector"), pgcrypto]
}
but there was an error: pgvector and pgcrypto do not exist in your server, make sure to run or add them before using them.
1) How can I add extensions like pgvector, pgcrypto, etc ?
2) Where can I get the database credentials ( Host, User, Password, Database name), since the URL does not have those?7 Replies
You selected the bot's instantaneous insights. Let me compile your answer right away!
I'd be happy to help you with your questions about Prisma and PostgreSQL extensions. Let me address each of your questions:
1) To add PostgreSQL extensions like pgvector and pgcrypto in Prisma, you can use the
postgresqlExtensions preview feature. Here's how you can do it:
First, enable the preview feature in your schema.prisma file:
This example adds both pgvector and pgcrypto extensions. You can add or remove extensions as needed.
After updating your schema, you can apply these changes to your database using Prisma Migrate:
For more detailed information, you can refer to the PostgreSQL extensions documentation.
2) Regarding database credentials, Prisma typically uses a connection URL stored in an environment variable. The connection URL contains all the necessary credentials. Here's an example of what it might look like:
You would replace USER, PASSWORD, HOST, PORT, DATABASE, and SCHEMA with your specific database details.
If you're setting up a new project, you might define these credentials yourself. If you're working with an existing project, you should check the project's .env file or ask your team's database administrator for the correct credentials.
For more information on connection URLs, you can refer to the Connection details documentation.
Remember to keep your database credentials secure and never commit them to version control.
š¤ Alright, thanks for letting us know that there's still some help needed. A team member will reply to you shortly.
In the meantime, please let us know any additional info, questions, or which parts of the answer may need clarification.Hey š
1. Support for adding extensions like pgvector, pgcrypto is coming very soon. At the moment, it is not possible with Prisma Postgres.
2. Can you share your usecase for needing database credentials instead of API Key? Do you require it to connect to a database IDE?
1. Understood
2. Yes DB IDE and other stuff like pg library used in another project without Prisma
You can use this guide to connect Prisma Postgres with your database IDE:
https://www.prisma.io/docs/postgres/tooling#connecting-to-prisma-postgres-instance-with-3rd-party-database-editors
Tooling | Prisma Documentation
Learn about connecting directly to your database via TCP tunnel
awesome, thanks
waiting for the extensions
We are working on it š
Hey @nks1302-jack šš¾ , Prisma Postgres now has
pgvector extension support, along with a few other extensions. You can see an implementation example in the launch article here.
Give it a try and let us know if you have any feedback šš¾ !Prisma
ORM 6.13.0, CI/CD Workflows & pgvector for Prisma Postgres
Prisma ORM v6.13.0 introduces Prisma Config & multi-schema support in GA, pgvector for Prisma Postgres, a new Management API for CI/CD, SQL view enhancements, and a redesigned Prisma Console UI.