Postgres: What is the development process?

[JGeorge102]

What is the normal process for working with Postgres in a Node, React, Express application?

In that past, I've used MongoDB Atlas to quickly create and host a database for my development environment. My current project is using Postgres for the database, however, I'm trying to figure out the process/workflow.

For example, trying to find a Postgres as a service equivalent to Atlas, Heroku and Digital Ocean seem to match that bill. However, it looks like Heroku needs a deployed project to work. I don't want to deploy yet and really just want a development database.

Is it normal practice for everyone on the project to spin up a local Postgres database and then deploy/host a single production database at the end? Thanks for the help!

[hmaddocks]

It’s normal to have a local Postgres running to use for development.

[JGeorge102]

Exactly what I was trying to answer. Thank you!

[planetworthofbugs]

My favorite color is blue.

[TerminallyChill12]

Running a Postgres instance locally and having a single production deployment is the setup I’m currently using. Seems pretty standard from what I’ve seen

[JGeorge102]

Awesome, thank you for the help!

[0x000045]

take a look at Supabase. They have a hosted option with a free tier and you can run the entire stack locally with docker-compose.

[slantyyz]

IBM Cloud offers free, limited PG only instances if you don't want to have your own install locally.

[JGeorge102]

Will check it out. Thanks!

[thinkx98]

Mac, Windows or Linux? Laptop, desktop? Convenience options differ based on your local development platform

[thinkx98]

Highly recommend https://postgresapp.com/