Stack Overflow
Stack Overflow

Questions tagged [planetscale]

Planet Scale is a MySQL compatible hosted database as a service

72 questions
5
votes
2 answers

PlanetScaleDb Prisma Setup - server does not allow insecure connections, client must use SSL/TLS

I am starting a brand new PlanetScale backed project, with a Prisma setup. I followed the instruction on this official documentation (aside from changing the name of the database) and after locally proxying into the database, I found myself unable…
TheMilkMan
  • 143
  • 2
  • 7
4
votes
3 answers

How do I connect to a MySQL database server running on PlanetScale with SSL from node.js on localhost?

I'm trying to connect to the MySQL server on PlanetScale, but can't as it requires SSL. Here's their doc for that, but it's unclear what it says. https://planetscale.com/docs/concepts/secure-connections Here's the connection URL:…
DreamBold
  • 2,727
  • 1
  • 9
  • 24
3
votes
1 answer

Request error PrismaClientValidationError on NextJS 13

I'm making a school project and I'm using NextJS 13, and trying to connect to the MYSQL database using Prisma with PlanetScale, but while trying to register a user I'm getting: Request error PrismaClientValidationError: Invalid…
AyameIgor
  • 33
  • 3
3
votes
2 answers

Authentication failed against database server at `aws.connect.psdb.cloud`, the provided database credentials for `name` are not valid

Im using planestscale with prisma on a next js app that I'am trying to host on vercel but it runs on localhost without any error but as soon as I go to depolyment I count this error Authentication failed against database server at…
ibo
  • 51
  • 3
2
votes
0 answers

Drizzle timestamp datenow invalid default value

I am new to Drizzle ORM and I am trying to make a simple schema where there is a created_at column that has default value of date of when did the account got created. This is the schema export const users = mysqlTable('users', { id:…
Parzival
  • 93
  • 6
2
votes
2 answers

Python Planetscale DB MySQL Connection

I have been trying to make a Python program that connects to a Planetscale MySQL DB, I have used 2 libraries that are mysql-connector-python and mysqlclient. I think I have entered the correct details every time with both but it hasn't worked. I…
axelrothing
  • 51
  • 1
  • 1
  • 10
2
votes
1 answer

How I can connect to planetscale with nestjs

I had created a nest app with many tables in mysql using typeorm . when i try to connect the database to planetscale it show corresponding error : [Nest] 9160 - 03/23/2023, 3:56:07 AM **ERROR [ExceptionHandler] can't push predicates on…
Muhammed Hashim
  • 23
  • 3
2
votes
0 answers

How do i remove a data using Cascade with Prisma

model Comment { id Int @id @default(autoincrement()) content String @db.MediumText replyId Int? reply Comment? @relation(name: "ReplyComments", fields: [replyId], references: [id],onDelete: NoAction, onUpdate: NoAction) comments…
SeongBaek CHO
  • 33
  • 3
2
votes
1 answer

Do I need to use Prisma's connect & disconnect API? Or is it not safe to just update my Relations via IDs as strings?

I am using prisma + mysql (on planetscale). When I link two items that are in different tables, I normally use connect or disconnect: const getUser = await prisma.user.update({ where: { id: 9 }, data: { posts: { | connect: { | …
antonwilhelm
  • 5,768
  • 4
  • 19
  • 45
2
votes
1 answer

Prisma returns empty response when fetching data

I have data in the table but prisma returns empty response. Database is hosted on Planetscale and it is MySQL. This is schema of the table: model BindingTeacherLessons { bindingId Int teacherId Int lessons Int binding Binding…
Chickenbiscuito
  • 48
  • 5
2
votes
1 answer

Foreign key constraints are not allowed (Prisma)

Currently facing an issue whilst attempting to push schema changes to planetscale db. Not sure what I may be doing wrong. I am fairly new to prisma, so I would appreciate some help :). generator client { provider = "prisma-client-js" …
Adrian Hossen
  • 21
  • 1
  • 3
1
vote
1 answer

Out of sort memory when using OrderBy (using Prisma)

I am getting the following error ResourceExhausted desc = Out of sort memory, consider increasing server sort buffer size (errno 1038) (sqlstate HY001) When running a query with sorting in it, such as. const documentId = 0x12345 await…
ToddBFisher
  • 11,370
  • 8
  • 38
  • 54
1
vote
0 answers

Django PlanetScale CA Cert Path

I have deployed a Django webapp on Vercel which uses a PlanetScale database. I have stored the PlanetScale connection strings as environment variables in Vercel. Django seems to be able to see the env variables; however, I am getting a…
Chup91
  • 66
  • 7
1
vote
1 answer

Deferred JOIN: can't handle JOIN USING without authoritative tables

I have a basic database in which I'm trying to implement the deferred join technique. However, on Planetscale I keep getting the following error: can't handle JOIN USING without authoritative tables. I'm not terribly well-versed in MYSQL, but I'm…
wes
  • 734
  • 6
  • 14
1
vote
1 answer

Next Auth Cannot Login - Prisma Adapter, Planet Scale, Google

I've seem similar problems and tried some suggestions, even deleted my whole database and created it again, but nothing seems to work. So Im trying to log in into my application via the Google Provider in Next Auth using the Prisma Adapter and…
Daniel Guedes
  • 387
  • 1
  • 4
  • 14
1
2 3 4 5