alflervag
Re:Schema changes and the Postgres lock queue
on Sunday June 23, 2024 @02:33AM (#40765199)
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.
Re:Eugene is a CLI tool for reviewing Postgres SQL migration scripts
on Wednesday May 08, 2024 @05:49AM (#40296105)
Thank you for this. The generated texts are very informative and educational, so I really see the benefit here.
Re:Careful with That Lock, Eugene
on Sunday April 14, 2024 @03:56AM (#40029473)
Nice, I wasn’t aware of this one.
Re:Careful with That Lock, Eugene
on Saturday April 13, 2024 @02:50PM (#40025149)
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.
Re:OpenRefine
on Sunday October 22, 2023 @05:02AM (#37973902)
I’m surprised to hear you using this for database normalization. Could you expand on how OpenRefine is helpful here?
Re:Jailer, a unique open-source database tool
on Tuesday August 08, 2023 @11:09AM (#37050157)
Jailer works well with ssh port forwarding.
Re:Jailer, a unique open-source database tool
on Tuesday August 08, 2023 @11:05AM (#37050073)
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.