ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Developer tools · #prisma
can I get a list of enums values of a model on the client-side like for select option? Sample enum enum user_type { superadmin admin user } I want this as a select-option on the client-side. How can I get them as JSON data?
Goal: Determine whether Prisma Client’s $transaction callback provides full atomicity when an error is thrown after some writes have already succeeded within the same transaction scope. Constraints: The transaction API reuses a single connection for the callback, uses SAVEPOINTs for nested writes on supported databases, and automatically rolls back on any th
I am writing a postgreSQL database. The ID must be auto-incrementing. model User { id String @id @default(cuid()) name String? email String? @unique emailVerified DateTime? @map("email_verified") image String? createdAt DateTime @default(now()) @map(name: "created_at") updatedAt DateTime @updatedAt @map(name: "updated_at") posts Post[] accounts Account[] ses
Prisma enforces UTC storage for all DateTime values across supported database providers. When utilizing PostgreSQL, the TIMESTAMPTZ type is used to ensure data is stored in UTC, but the Prisma Client returns these as standard JavaScript Date objects. Because timezone conversion occurs at the application layer, there is a disconnect between the database sessi
I've tried to connect Prisma with postgreSQL several times. prisma show this error message : "Error: undefined: invalid port number in "postgresql://postgres:password@localhost:5432/linker")". -error -prisma/.env DATABASE_URL=postgresql://postgres:password@localhost:5432/linker -schema.prisma datasource db { provider = "postgresql" url = env("DATABASE_URL")
I am using Prisma with Postgres. I need to use $queryRaw for a particular query due to use of unsupported tsvector type in the underlying table. In this query, I also need to use an 'in' statement where the items in the 'in' list need to be parameterised.. I have tried this const ids = [41, 55] const result = await prisma.$queryRaw`select * from users where
Since I have moved to the new Apple Silicon architecture my docker setup with nextjs and postgres is not working anymore. The database inside the docker cannot be found by the nextjs server where I am using prisma. The prisma client can't reach the postgres database on port 5432. Can't reach database server at test-postgres : 5432 The migration also does not
I am using prisma, postgres, docker, kubernets. npx prisma migrate dev working. and npx prisma generate produce below output: ✔ Generated Prisma Client (2.23.0) to ./node_modules/@prisma/client in 68ms You can now start using Prisma Client in your code. Reference: https://pris.ly/d/client import { PrismaClient } from '@prisma/client' const prisma = new Prism
Goal: Use an in‑memory SQLite database together with Prisma’s preview referentialIntegrity feature so that integration tests enforce foreign‑key constraints identical to a production PostgreSQL instance while keeping credentials out of the test environment. Constraint: The referentialIntegrity preview is experimental and its implementation relies on SQLite P
postgresql
docker
sqlite