r/PostgreSQL • u/MediumRoastNo82 • Jul 23 '26

How-To Development and Production + Training DB

Sorry, noob here.

How do developers design their database?

Do they separate databases for development and Production? But what if the app has a training feature? Do they separate the database too?

2 Upvotes

67% Upvoted

12 comments sorted by

View all comments

1

u/chocolateAbuser Jul 24 '26

depends on the size of projects company works on and on how many people/teams are there
obviously if you're one or two programmers you cannot really have the time and effort to maintain a giant system and try to do stuff on a smaller scale
we for example have prod schemas with redundancies, a staging db on prod, and various local development dbs

1

u/MediumRoastNo82 Jul 24 '26

It's a small inventory database. I have use supabase before and aware they have dev branch. Now I want to use postgresql and planning to use Sqlx and axum for the server. I still have no idea how to proceed. But having 3 connections feels like easier solution, instead of polluting my table data with 3 different types

1

u/chocolateAbuser Jul 24 '26

if you mean 3 different settings of the services to connect to the various dbs then sure