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 )
16 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 ?
@Erwan 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.)
Braconid wasp
Vercel is ultra simple to set up, you can put your app there
ErwanOP
yes it's simple but overpricing for production and big projects
@Erwan yes it's simple but overpricing for production and big projects
Braconid wasp
are you sure free plan is not enough for you?
if you don't know how to set up ssh tunel then i doubt your project is considered big
you should be alright with free plan
ErwanOP
Yes, it’s a small project for now, but as it scales and evolves, I don’t want to tell my client that they have to pay more for the same services
@Erwan Yes, it’s a small project for now, but as it scales and evolves, I don’t want to tell my client that they have to pay more for the same services
Braconid wasp
AWS Amplify should be cheaper then
@Braconid wasp AWS Amplify should be cheaper then
ErwanOP
oh okay i have never use aws it's beginner friendly ?
@Erwan oh okay i have never use aws it's beginner friendly ?
Braconid wasp
Well Vercel is definitely way more friendly