ApexFossa45

PostsComments

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

Interesting, I see the correct schema, but no data, within the proxied database at export DATABASE_URL="postgres://postgres:MYPASSWORD@localhost:5432/MYAPP_database" but not export DATABASE_URL="postgres://postgres:MYPASSWORD@localhost:5432/MYAPP_server". Even after running the migrations it worked. I wonder if something is not letting me see the data? @kapa.ai

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

@kapa.ai Hi kappa, is there a way to force a migration from dev into the production database? It's possible there is a mismatch based on what I see. I'm seeing if running something like npx prisma migrate deploy, with the database_url pointing to prod would work?

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

tbh, i might just give up for the moment and use something like Adminjs or openapi/swagger to view my data: https://adminjs.co/ 🤷‍♂️ . I didn't expect prod connection to be so difficult, i'll have to come back to it later though for sure (appreciate the help though!)

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

@kapa.ai got it thanks. is there a command, way that i can backup data from my fly.io instance?

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

@kapa.ai got it, where is the data in production fly.io database coming from then? if i do ssh then npx prisma migrate deploy, will that overwrite existing data?

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

@kapa.ai thanks, i think it connected, but the tables are empty/non existant. it can't find File table, nor Session. why?

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

@kapa.ai got it thanks. what would be the password and database if i'm using the proxy? would it be the same as the production database from fly.io?

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

@kapa.ai thanks, i did try updating the url to have postgresql:// to start with, and the format: postgresql://[username:password@]host[:port]/database. i am getting this error within prisma studio: Message: Error in Prisma Client request: Invalid prisma.file.findMany() invocation: error: Error validating datasource db: the URL must start with the protocol postgresql:// or postgres://. --> schema.prisma:4 | 3 | provider = "postgresql" 4 | url = env("DATABASE_URL") | Validation Error Count: 1

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

@kapa.ai thanks, it's not working. When I run wasp db studio, it says wasp start db must be called to run the database, but it cannot connect due to the url. even when using npx prisma studio command, it says environment variable not found DATABASE_URL. although i do see it within the .wasp/out/server/.env file (the production url)

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

@kapa.ai thanks! but it doesn't let me. it says 'Wasp has detected that you have defined DATABASE_URL env var in your .env.server file. To have Wasp run the dev database for you, make sure you remove that env var first." - which I need to keep to proxy to that database, so I am confused?

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

@kapa.ai thanks, i can see the database within pgadmin tool, the tables are in my database app on fly.io, but they are empty. Additionally, i cannot start wasp db studio, as it says port 5432 is already in use. any help please?

72 replies

WWasp

•Created by ApexFossa45 on 1/5/2025 in #🙋questions

How to connect to production database

@kapa.ai thanks, when trying to proxy the database to localhost (option 1), it says: nico@Narev001:~/Projects/aicreationscentral$ wasp start db ❌ --- [Error] You are using custom database already: ----------------------------- Wasp has detected that you have defined DATABASE_URL env var in your .env.server file. To have Wasp run the dev database for you, make sure you remove that env var first.

72 replies

WWasp

•Created by ApexFossa45 on 12/16/2024 in #🙋questions

Routing to another page

thank you! the bot is very handy :boi:

7 replies

WWasp

•Created by ApexFossa45 on 11/28/2024 in #🙋questions

How to redirect from server in google oath 2.0 to my new domain?

no problem, and thanks team for the continued support! :boi:

24 replies

WWasp

•Created by ApexFossa45 on 12/6/2024 in #🙋questions

How to render pdfs within an opensaas project

@martinsos Hi, yes that is exactly it. I have the pdf in the /public folder, and to reference it within the front-end I use <a href="/mypdf.pdf"></a>, for example

9 replies

WWasp

•Created by ApexFossa45 on 12/6/2024 in #🙋questions

How to render pdfs within an opensaas project

@Vinny (@Wasp) hi, thank you for following up. I resolved ghe issue, yep. I had uploaded a corrupted pdf by mistake, which is why it wasnt showing. I uploaded a working one, and then it worked! Thanks, apex

9 replies