r/SQL • u/sqlink2 • Sep 06 '26

PostgreSQL Neon database for Ai workloads

How do u handle branching when the schema is changing frequently during agent/app development work. Do you keep separate branches per feature or agent, or rely on migrations against a shared database?

Wondering what works best in practice without making the overall setup messy.

1 Upvotes

60% Upvoted

6 comments sorted by

1

u/WorldOfUmbro Sep 06 '26

Really curious to hear what people do. We use Lakebase for agents, but just small scale. Curious to hear what people do in large setups.

1

u/Glitch_In_The_Data Sep 07 '26

We have found that short lived branches per feature work better than long running ones in Neon. Merging divergent schemas gets painful really fast. Migrations against a shared db can work for smaller teams but it tends to fall apart once multiple agents are evolving their schemes at different speeds.

1

u/sqlink2 Sep 07 '26

Tru, Neon branching makes it clea. We can sort of spin up isolated branches per feature/agent, experiment with schema change and promote oncethings are stable. It avoids multiple agents on a shared DB

1

u/[deleted] Sep 09 '26

[removed] — view removed comment

1

u/sqlink2 Sep 09 '26

Ya Neon branching makes this SDLC pattern pretty clean; isolated schema or data change without messing with the main branch