Stack Overflow
Stack Overflow

Questions tagged [planetscale]

Planet Scale is a MySQL compatible hosted database as a service

72 questions
1
vote
1 answer

Not able to do Laravel migrations on Planetscale database

I'm a newbie in Laravel, I was trying(testing) to deploy my website on a cloud server. I have already deployed my larvel website on 'Fly.io' with a proper link. The only thing left to connect was the database, but creating a database on fly.io is…
Vaibhav K. Patil
  • 57
  • 1
  • 4
1
vote
0 answers

Planetscale: Creating unique index fails when a date column has a default value

I created this table in Planetscale CREATE TABLE `community` ( `id` serial PRIMARY KEY, `name` varchar(256), `email` varchar(256) NOT NULL, `created_at` timestamp(2) NOT NULL DEFAULT (now()), `last_updated_at`…
inginia
  • 412
  • 1
  • 6
  • 15
1
vote
2 answers

Why can't npx prisma db push find my prisma schema?

I'm trying to setup my first t3 app and I have no idea how prisma works. Trying to set up my database following a tutorial and I cannot get my prisma schema to push. I follow the tutorial precisely and it still doesn't work. Command: $npx prisma db…
manski
  • 131
  • 1
  • 10
1
vote
0 answers

Using fulltext search in MYSQL with ngram parser enabled is it possible to search for 1 character words with ngram_token_size set to 2?

I am using Planetscale which has a pretty big limitation in that you can't edit the mysql configuration so I cannot set ngram_token_size which defaults to 2. The problem with this is I need to use this for logographic languages such as Chinese which…
OultimoCoder
  • 244
  • 2
  • 7
  • 24
1
vote
2 answers

Prisma Next-Auth PlanetScale: foreign key constraints are not allowed

I am following the official docs to setup next-auth with prisma: https://next-auth.js.org/adapters/prisma. After copying these models (Session, Account, VerificationToken) into my schema.prisma I get the following error when I try to do a prisma db…
currenthandle
  • 1,038
  • 2
  • 17
  • 34
1
vote
1 answer

MySQL seeded table is missing a column

I'm building a ReactJS/Node.js World Cup score prediction web app, and I just stumbled upon an odd problem. Apparently, when I seed my db, one column is missing. I have a "seed.js" file containing data from every World Cup game. Each game is an…
Marcelo Franco
  • 21
  • 3
1
vote
1 answer

Prisma, increase the connection limit? (Planet Scale)

Timed out fetching a new connection from the connection pool. More info: http://pris.ly/d/connection-pool (Current connection pool timeout: 10, connection limit: 17) I query the database through prisma and suddenly that error appears. How should…
dontknowhy
  • 2,480
  • 2
  • 23
  • 67
1
vote
1 answer

Cloud Run, is it possible to connect SSL/TLS database server

I use planetscale serverless database server right now and my main web server is built by Cloud Run https://planetscale.com/docs/concepts/secure-connections They are forcing ssl/tls unconditionally. Now, my cloud run uses https. I have also…
dontknowhy
  • 2,480
  • 2
  • 23
  • 67
1
vote
1 answer

Prisma, how to preserve foreign data?

It's been a few months since I started prisma and I'm still confused. In a normal database, foreign key data also exists in table data. However, according to the prisma document, in prisma, the data does not exist at the database level. So where is…
dontknowhy
  • 2,480
  • 2
  • 23
  • 67
1
vote
1 answer

drop primary key giving error saying it doesn't exist but won't allow me to add since it says one alraedy exists

I have a mysql table: +---------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------+-------+ | hash | varchar(255) | NO | PRI | NULL | …
reactor
  • 1,722
  • 1
  • 14
  • 34
0
votes
0 answers

Prisma $executeRaw`` function inside Next.js 13 route handlers throws 'Raw query failed. Code: 1105' Error

I have a a button that sends an api request to my Route Handler in Next.js 13. I am trying to delete a post from the database using a dynamic query built from parameters. However, it is throwing a weird error when I try to call this route. The code…
1voy
  • 11
  • 3
0
votes
0 answers

Connect PlanetScale to Netlify

I try to connect my React Next application between PlanetScale and Netlify, but I fail and the console return an 'internal server error 500'. I've following the tutorial https://planetscale.com/docs/tutorials/deploy-to-netlify I create a new…
Knupel
  • 323
  • 2
  • 14
0
votes
1 answer

PlanetScale github flow get stuck at `prisma db push`

I have a github workflow for automating the process of create a planetscale branch and pushing the migration for review. I initially create a branch and then next step is to login to the branch db and push the schema change. In the Run migrations…
Emmanuel Amodu
  • 163
  • 2
  • 14
0
votes
0 answers

Cannot connect Planetscale DB (Prisma Error: P1001)

Im trying to push to Planetscale using Prisma, but keep getting the next error: Error: P1001: Can't reach database server at aws.connect.psdb.cloud:3306 Please make sure your database server is running at aws.connect.psdb.cloud:3306. I setup…
Tal Yaakov
  • 1
0
votes
0 answers

Error: P1001 comming in vscode when pushing db in prisma cloud

Error: P1001: Can't reach database server at aws.connect.psdb.cloud:3306 Please make sure your database server is running at aws.connect.psdb.cloud:3306. This error is comming on using this command "npx prisma db push" how can i resolve this error,…
Sidharth Shukla
  • 1
  • 1
1
2
3 4 5