DevOPs Help needed: Deploying backend, db, frontend and git version control?

System Information
  • Strapi Version: 4.1.7
  • Operating System: Windows 10
  • Database: SQLite
  • Node Version: npm
  • NPM Version:
  • Yarn Version:

Hello, I am new to deploying Strapi. I am currently using Next,js for the frontend and considering deploying to Digital Ocean.

My goal is to have Local environment connect to GitHub repo, a remote Stage and Production environment. I want to easily move code and DB across all 3 environments.

I have been reading the docs about deployment. I does give some information, but something aren’t clear about the whole scope of the project. What would be the best DevOps setup for the full project , including the frontend and DB?

The docs mention how for local setup the recommendation is to use SQLite DB. However SQLite isn’t recommend for Production. In the case of Digital Ocean they have PostgresSQL DB configuration.
So how does the data from local SQLite DB transfer to PostgresSQL? What about pulling down the data to local? I have found a plugin Import/Exports Entries. Import Export Entries | Strapi Market. It looks like it could help. What about the public/uploads?

Is it best practice to have 2 different git repos for backend and frontend? They would then be deployed separately? :thinking: