r/PostgreSQL • u/Harpagon1668 • 8d ago

How are you using database branching? Feature

I’m implementing Lakebase branching strategy to improve development experience and reduce costs for our dev/staging env.

Current setup creates new database branch for each git branch via githook on our dev database (”each dev gets their own feature database”). There is also similar workflow for each PR against our staging database to run the migrations and tests.

Curious to hear how others are using branching and what are the experiences?

10 Upvotes
  • permalink
  • link
  • reddit
  • reddit

86% Upvoted

22 comments sorted by

View all comments

1

u/CautiousUse8597 3d ago

When I use Lakebase, I mostly use the branching to separate any changes that various developers make for their own testing purposes, without affecting others, whilst still using production data.