ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Developer tools · #prisma
Learn how to implement offset and cursor-based pagination in Prisma to prevent memory overflow and database latency in large datasets.
A technical decision guide for NestJS developers comparing TypeORM and Prisma, focusing on type safety, architectural patterns, and deployment constraints.
Stop using 'skip' for large datasets in Prisma. Learn why offset pagination slows down your app and how to implement constant-time cursor-based pagination for scalable feeds.
Learn how to implement cursor-based pagination in Prisma to avoid the performance degradation of offset-based skip/take methods in large datasets.
Learn how to diagnose and fix 'Prisma Client: Transaction timeout' errors by optimizing interactive transactions and configuring timeout settings for heavy writes.
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
typescript
postgresql