News for hackers. Stuff that matters.
Re:Thin PostgreSQL Clones by grncdr on Tuesday January 25, 2022 @07:10AM (#30070911)
This looks like a really useful tool for staging and development environments, and it's even OSS that can be self-hosted! Does anybody here have any real-life experiences with it they could to share?
Re:Thin PostgreSQL Clones by shabble on Wednesday January 26, 2022 @05:39AM (#30083880)
I'm using it (mostly locally at the moment) for semi-automating testing of django db data migrations, and it's really great.

I've previously spent a fair bit of time tuning postgres for fast/less durable settings to speed up testing, and this puts all of that to shame when you need to start with any non-trivial schema/data and revert back to it.

I had been testing out some ideas with `docker commit` to save derived images which included a premade db, then reverting to that, but I don't think it's worth bothering with since I found dblab.

Haven't yet tried using it CI, and I suspect it might need a somewhat-custom-than-normal VM setup to use ZFS than you could easily do on most hosted CI runners, but it's on my list of things to investigate/setup eventually.

Re:Thin PostgreSQL Clones by akartasov on Tuesday January 25, 2022 @07:31AM (#30071054)
There are several public Case Studies of real users (from small teams to quite large companies): https://postgres.ai/resources/

For more real-life feedback, welcome to the Database Lab Community Slack: https://slack.postgres.ai/

Re:Thin PostgreSQL Clones by krab on Tuesday January 25, 2022 @08:30AM (#30071550)
I implemented a similar idea for a few companies. The response was always very positive.

In one company, it grew into a cluster of a few servers for higher capacity and availability. This load balancing and management code is a quite more complex than the original single-server snapshotting script. Unfortunately, it's not open source. For several years, the single server was enough. Go for it. :-)