Looking for Guidance on Setting Up a Deployment Workflow for My Next.js App
Unanswered
Erwan posted this in #help-forum
ErwanOP
Hi, my name is Erwan,
I’m looking for a short training or some guidance to help me set up a proper deployment workflow for my application.
Right now, I’m stuck on the production update process for my app hosted on a Hostinger VPS. I’ve explored CI/CD solutions, but I’m facing a specific issue: when working locally, I don’t have access to the production database (Prisma with PostgreSQL). Because of that, certain updates that depend on real production data can’t be properly tested or applied.
To clarify my situation:
I’ve built a Next.js application that allows users to post and browse second-hand product listings. The app is deployed on a Hostinger VPS, and I’d like to establish a professional and reliable workflow to maintain and update it efficiently.
I’d really appreciate any advice, resources, or training opportunities that could help me move forward.
( I'm a beginner )
I’m looking for a short training or some guidance to help me set up a proper deployment workflow for my application.
Right now, I’m stuck on the production update process for my app hosted on a Hostinger VPS. I’ve explored CI/CD solutions, but I’m facing a specific issue: when working locally, I don’t have access to the production database (Prisma with PostgreSQL). Because of that, certain updates that depend on real production data can’t be properly tested or applied.
To clarify my situation:
I’ve built a Next.js application that allows users to post and browse second-hand product listings. The app is deployed on a Hostinger VPS, and I’d like to establish a professional and reliable workflow to maintain and update it efficiently.
I’d really appreciate any advice, resources, or training opportunities that could help me move forward.
( I'm a beginner )
7 Replies
@Erwan Hi, my name is Erwan,
I’m looking for a short training or some guidance to help me set up a proper deployment workflow for my application.
Right now, I’m stuck on the production update process for my app hosted on a Hostinger VPS. I’ve explored CI/CD solutions, but I’m facing a specific issue: when working locally, I don’t have access to the production database (Prisma with PostgreSQL). Because of that, certain updates that depend on real production data can’t be properly tested or applied.
To clarify my situation:
I’ve built a Next.js application that allows users to post and browse second-hand product listings. The app is deployed on a Hostinger VPS, and I’d like to establish a professional and reliable workflow to maintain and update it efficiently.
I’d really appreciate any advice, resources, or training opportunities that could help me move forward.
( I'm a beginner )
Braconid wasp
Google/AI: "How to connect to a database from local that is on a VPS which is not exposed to public"
Usually you'd either use SSH tunnel or VPN
ErwanOP
it's a common practice SSH tunnel ?
@Erwan it's a common practice SSH tunnel ?
Braconid wasp
Yeah, if you just need to access the prod DB temporarily, then it's the best solution
ErwanOP
thanks a lot and i have a bucket r2 cloudflare for images. Plus i think the address ip which allows to manage upload/delete.. is the address of the vps and not localhost, can it be done with ssh tunnel ?
ErwanOP
I'm looking for a Next.js production deployment workflow with CI/CD and the ability to develop new features locally and then push them to production.
Do you know who I could reach out to for a step-by-step explanation? I'm even willing to pay for training, but since I'm a beginner, I'm looking for some guidance.
(I tried setting up an SSH tunnel, but I couldn’t get it to work — the SSH connection itself was successful, but I still couldn’t access my production database locally despite being connected through SSH. It was probably a mistake on my part.)
Do you know who I could reach out to for a step-by-step explanation? I'm even willing to pay for training, but since I'm a beginner, I'm looking for some guidance.
(I tried setting up an SSH tunnel, but I couldn’t get it to work — the SSH connection itself was successful, but I still couldn’t access my production database locally despite being connected through SSH. It was probably a mistake on my part.)
ErwanOP
Anyone have an idea ?