I actually just did this recently. I looked at a bunch of solutions for my dev environment, but Claude kept pushing me back to a really simple one: use Postgres.

Postgres has template database that effectively give you a really easy means of "cloning" a database. On AFS (and several other file systems), copy-on-write is pretty much native.

▲

gonzalohm 6 days ago | parent [-]

I was also looking into this for dev environments but I haven't been able to solve "rebases". If someone merges to prod then the dev environment is "out of sync" and you have to clone the DB again. It's pretty painful to orchestrate

	▲	SkyPuncher 6 days ago \| parent [-]
		We're using rails, so it mostly just comes down to pulling main and running migration. I don't really worry about conflicts on branches since most features aren't long lived enough.