Automatically create SQLite database and run Prisma migrations in Docker for Next.js app
I have a Dockerfile that builds a Next.js application using Prisma with a SQLite database. I'd like to know if there's a recommended or automated way to create the SQLite database file and run the necessary Prisma migrations directly inside the Docker container, before the Next.js app starts. What's the best practice to achieve this setup?
Possible error in docs?
https://www.prisma.io/docs/guides/nextjs#25-set-up-prisma-client
Here i copied the following:
```import { PrismaClient } from '@prisma/client'
import { withAccelerate } from '@prisma/extension-accelerate'
...
Coolify: MongoDB Replica Set
Does anybody have the "Custom MongoDB Configuration" to resolve the replica set issue?? Kindly help.
Also, if I create replica set on my VPS(via Coolify), all the replica sets are in the same location, then whats the use of it??...
Lost prod data, is there backup?
Hey, I lost my prod data. Is it possible to restore latest snapshot?
Can’t connect to a db
Hi guys, I have two db in a environment and I’m not able to connect with one of them, even to the prisma studio where a receive a erro 500.
How can I solve this?...
Getting P5000 issue
This request could not be understood by the server: {"type":"UnknownJsonError","body":{"code":"P6002","message":"The provided API Key is invalid. Reason: No Authorization header is present."}} (The request
We were charged $400 and I can't see why!
We have 4 databases.
Development / Staging / Production / Till
All of them had ~100k DB requests. we were billed for 22M requests
Please fix our invoice asap and reimburse us the money....
Issue migrating a vector field
```evelyn % npx prisma migrate dev
Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": PostgreSQL database "postgres", schema "public" at "aws-0-us-east-1.pooler.supabase.com:5432"
...
fulltext argument missing
Why
@@fulltext argument is missing here? I am using MySQL and "prisma": "^6.1.0"
Docs: https://www.prisma.io/docs/orm/prisma-client/queries/full-text-search...
Custom error becomes normal error
what's the probably reason why my custom classes throws normal error in nextjs ?
```ts
export default class ServerError extends Error {
issues: IError;
...
InitializationError
this is my controller
async function signUp(req: Request, res: Response) {
req.body.password = await hashPassword(req.body.password);
req.body.birthDate = new Date(req.body.birthDate).toISOString();
try {...
Change behavior of @updatedAt when upgrading from 5.21.1 to 6.5.0?
Hi,
When upgrading from version 5.21.1 to 6.5.0 I noticed that some of my snapshot tests where failing to a change of order. Digging down I noticed that my records all have the same
updatedAt value in version 5.21.1 and now different values in Prisma 6.5.0.
I found this issue on GitHub: https://github.com/prisma/prisma/issues/22326. Was this basically resolved somehow? Unfortunately me and ChatGPT could not find a relevant commit that changes this behavior....Prisma Select TypeError
ok - my issue might be unrelated:
This works:
```js
function manyFoo(select?: Prisma.fooSelect) {...
Is it possible to run migrations manually on the database server via raw SQL and not use Prisma?
Hi because I'm a bit stuck with migrations stalling and hanging due to Unsupported index of BM25, I am considering just running migrations on the database server manually via raw sql generated from prisma's migration files. i know its not the best thing to do but i gotta do what works.
what are some of the implications of doing this?...
Prisma db pull Extremely Slow on Supabase with Custom Schema
Issue: Prisma
- Using PostgreSQL on Supabase
- Prisma version:...
db pull is extremely slow when introspecting a schema on Supabase.
Details:- Using PostgreSQL on Supabase
- Prisma version:...
Primsa Studio Help
Hi! I am just looking for some help with regards to prisma studio. I current have this model
```model Unit {
id Int @id @default(autoincrement())
name String @unique...
Module not found after v6.5.0 upgrade
After upgrading to v6.5.0 these errors occur.
```
✔ Generated Prisma Client (v6.5.0) to ./node_modules/.pnpm/@[email protected][email protected][email protected][email protected]/node_modules/@prisma/client in 63ms
...
How does Prisma ORM build select Top in SQL Server?
My problem, can reply this query
SELECT TOP 1000 * FROM [User]
ORDER BY [id] ASC
OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY;
...
Empty migration when baselining a database
Hi
I'm following this https://www.prisma.io/docs/orm/prisma-migrate/workflows/baselining to baseline a MariaDB database.
```
npx prisma migrate diff \
--from-empty ...
Migration just stalls and hangs.
sometimes, when i perform prisma migrate to either create a new migration or run migration, it just hangs. what are some of the reasons for that happening?
we haven't gone production yet but this is super scary. it happens to me from a fresh database after like 2 or 3 days later. we do have a custom BM25 index.
its scary because the only way to get migration to work again is if i do a complete drop database and start over....