alflervag

If this is of interest I suggest taking a look at what Robin is doing at https://kaveland.no/eugene/

TLDR; Eugene helps you write zero downtime schema migration scripts for PostgreSQL databases by giving you a friendly report warning you about any anti patterns or potential problems.

Thank you for this. The generated texts are very informative and educational, so I really see the benefit here.

Nice, I wasn’t aware of this one.

A really interesting idea. Checking what locks a database migrations holds in CI so you can automatically add warnings to pull requests that are likely to cause downtime.

I’m surprised to hear you using this for database normalization. Could you expand on how OpenRefine is helpful here?

Jailer works well with ssh port forwarding.

We’ve used this tool to subset a decent sized database (~1500 tables, mostly 5th normal form) with success. The UI is pretty good for exploring the database and getting a configuration up and running.

The resulting configuration is in plain text which makes it very easy to commit to source control and even batch edit.

Extracting data can be done on the command line without running the UI and is thus well suited for pipelines.

We had a few questions and the author was very friendly and helped us understand how to solve our issues.

Big +1 from me.