Planet Scale is a MySQL compatible hosted database as a service
Questions tagged [planetscale]
72 questions
0
votes
0 answers
can I use JSON types with planetscale and prisma?
I'm using Prisma to define a schema, and planetscale to host the DB.
this means using the mysql driver with prisma.
I would like to use JSON types, but can't seem to get them to work
planetscale supports it for…
dcsan
- 11,333
- 15
- 77
- 118
0
votes
0 answers
Cannot connect Planetscale DB to NextJS project (Prisma Error: P1001)
Project architecture
Background
Trying to connect a DB to my NextJS project. Decided to use https://www.mockaroo.com/ to generate mock DB. Then used the Planetscale browser console to create the table and insert the values with the SQL generated…
Crunchy
- 186
- 10
0
votes
0 answers
Schema in production is different that in development
I'm having some trouble using prisma and planetscale
{
"id": 1,
"name": "Flor Esmaltada",
"price": 75,
"image": "https://ik.imagekit.io/gabriellazcano/imajo/Flor_2/flor_2_blanca_transparente_5RPp4nKfA.png",
"description": "Flor…
Gabriel Lazcano
- 1
- 1
0
votes
0 answers
Prisma, is it able to use underscore name convetion?
Prisma, is it able to use underscore name convetion?
I personally don`t like camel case because of readability..
But it seems to use underscore when composing things like constrained index or unique. And it seems to automatically change to camelCase…
dontknowhy
- 2,480
- 2
- 23
- 67
0
votes
1 answer
JPA Efficient way of checking for child records before deleting parent?
I am using PlanetScale (Database) which doesn't allow foreign keys, so I am trying to enforce referential integrity in the application instead of the database. Is there an easy and efficient way of checking for child records before deleting the…
tchristofferson
- 183
- 1
- 1
- 14
0
votes
0 answers
Inconsistent result when bitwise AND an inversed value on MySQL (PlanetScale/Vitess)
I have a SET column that has 10 values, and I'm querying against a specific row that has 2nd and 10th values set, therefore, it's 514 (1000000010).
Now, I encounter an issue that, the result is different whether SET is involved.
SELECT b'1000000010'…
Ren
- 79
- 7
0
votes
1 answer
PlanetScale doesnt let me create a new deploy request?
I just pushed a schema change to our dev branch on planet scale. Then wanted to go through the deploy request, but ran into an error:
I understood what the problem was and fixed it. Then pushed again to our dev branch. But now there is no option to…
antonwilhelm
- 5,768
- 4
- 19
- 45
0
votes
0 answers
Access denied for user "****", after deploying my application to Heroku
I got this error, when I deployed my node application to heroku, the database is planetscale. I put in the right env variable in my heroku, the db works in dev, but I don't know why it's giving this error after I deployed it to heroku. I have tried…
Chigalakingsley
- 71
- 3
- 8
0
votes
1 answer
ERROR HY000 (1105): unknown: rpc error: code = Unavailable desc = last resolver error: produced zero addresses when attempting to query PlanetScale DB
I'm getting an Error: Error in connector: Error querying the database: Error querying the database: Error querying the database: Server error: ERROR HY000 (1105): unknown: rpc error: code = Unavailable desc = last resolver error: produced zero…
Ian MacFarlane
- 2,300
- 1
- 16
- 9
-1
votes
1 answer
How can I import local hosted MySQL database to PlanetScale
Am making a website, hosted on netlify, and i've made the database on MySQL workbench, how do I import it into my PlanetScale? to be live.
Omar Alkhateeb
- 21
- 3
-1
votes
2 answers
Query for specific columns sqlalchemy
I have the table soldiers:
class Soldier(Base):
__tablename__ = "soldiers"
id = Column(String(36), default=lambda: str(uuid4()), primary_key=True, unique=True)
name = Column(String(50), nullable=False)
service_number =…
Lee Skies
- 31
- 6