Stack Overflow
Stack Overflow

Questions tagged [planetscale]

Planet Scale is a MySQL compatible hosted database as a service

72 questions
0
votes
0 answers

Deploying NestJS Backend on Vercel/Planetscale VS AWS EC2/EBS

I'm trying to find a correct stack to deploy my backend (BE) service on. Just a note my backend will have roughly 1-3 daily users so the traffic is really low. What's familiar to be would be to spin up an AWS EC2 instance, run my BE on it, connect…
CXY
  • 33
  • 8
0
votes
0 answers

Unable to setup Planet scale database project in WSL 2 (window subsystem for linux)

I started a next js project using create-t3-app and setup planetscale with prisma. I then copied my database URL into .env and run pnpm prisma studio. However, I run into an error that states: Message: Error in Prisma Client request: Invalid…
lool
  • 345
  • 1
  • 6
  • 11
0
votes
0 answers

Prisma asks for reference relation id when using connect (planetscale)

I am using planetscale and I have a survey model that connects to the user who submitted the survey. My schema is as follows generator client { provider = "prisma-client-js" } datasource db { provider = "mysql" url = env("DATABASE_URL") …
ibo
  • 51
  • 3
0
votes
0 answers

Creating while connectOrCreate relationships in Prisma

I am getting some type errors in my Next.JS work using typescript and prisma. This is the relevant information regarding my case. model Game { id Int @id @default(autoincrement()) upvote_count Int @default(0) title …
Silverbanana
  • 1
0
votes
0 answers

Execute code when a timestamp is reached in a MySQL

I have a MySQL database that contains records with an expiresAt timestamp. When this timestamp is reached, I want to execute some code to update the record. I've considered using a background worker process with a cron job to periodically check for…
altsphaantm
  • 11
  • 1
  • 2
0
votes
0 answers

I keep getting an error on while prototyping prisma schema

I have currently finished a project I was working on and while getting ready for production, I stumbled into an error which I cannot manage to fix. Am using planetscale as my database hoster, my project uses nextjs and prismajs. Whenever I run the…
csharpdev
  • 31
  • 3
0
votes
2 answers

i tried to connect planetscale database but not possible

below is my code ` from sqlalchemy import create_engine, text db_connection_string = "mysql+pymysql://dvgrfhodw7c31y4ss9j5:dvgrfhodw7c31y4ss9j5@aws.connect.psdb.cloud/aws.connect.psdb.cloud?charset=utf8mb4" engine = create_engine( …
Gabriel Elufidodo
  • 1
0
votes
0 answers

Build Metabase with planetscale db as a production db

We are trying to deploy Metabase docker on an AWS EC2 instance with a planetscale db as a production db. However, we get the following error: Caused by: java.sql.SQLTransientConnectionException: Could not connect to address= (conn=xx) unknown error:…
kiki
  • 563
  • 4
  • 17
0
votes
0 answers

Mysql Fulltext search not working on Planetscale / Prisma

Please i can't get FULLTEXT search to work on planetscale via prisma. Vercel always returns this error: "Cannot find a fulltext index to use for the search, try adding a @@fulltext([Fields...]) to your schema". I have already added and enabled The…
Mc-adams
  • 29
  • 7
0
votes
0 answers

while running strapi cms with planetsclae I got this error

while creating stapi CMS application, creating table in backed, I seen some created table showing in planetscale. While running I got below Error create table `upload_folders_parent_links` (`id` int unsigned not null auto_increment primary key,…
sridhar chary
  • 11
  • 2
0
votes
1 answer

while connecting planetscale using strapi CMS got this Error

planetscale details are Like below DATABASE_URL='mysql://username:************@host/strapi_db_name?ssl={"rejectUnauthorized":true}' same value using to connect module.exports = ({ env }) => ({ connection: { client: 'mysql2', connection: { …
sridhar chary
  • 11
  • 2
0
votes
1 answer

Building a Real-estate SQL schema: Explicit many-to-many relationship or alternatives

We have an instance of a "Listing" model, and we want to be able to assign it a "listing type," e.g., Sale / Rent / (or Both). If it is both, how can we have both in a list to query them by their "listing type". We've been thinking about doing a…
Josue Mata
  • 1
  • 1
0
votes
1 answer

Searching for an exact word in multiple languages efficiently using MYSQL

I have a simple database table which stores id, language and text. I want to do a search for any word/character and look for an exact match. The catch is I have over 10 million rows. e.g. search for the word i would return rows with the text…
OultimoCoder
  • 244
  • 2
  • 7
  • 24
0
votes
0 answers

How to type Date types with Prisma and JSON blobs?

There seems to be an issue with prisma's serialization of JSON blobs wrt Date types. I wonder if anyone else has seen this and has some guidance/workaround. This is for a JSON field with Planetscale which is basically MySQL driver. I have an object…
dcsan
  • 11,333
  • 15
  • 77
  • 118
0
votes
1 answer

How can I save an array of image Urls in MySQL database using Prisma ORM?

I am developing an e-commerce application using Next.js, planetscale(MySQL database) & Prisma ORM. I have a form using which I can upload images. I am saving these images in Firebase Storage. In return, I receive an array of image Urls. For example,…
HKS
  • 526
  • 8
  • 32
1 2 3
4
5