alflervag

3 ms·

1. 1.▲
   by alflervag 2y ago

   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
2. 2.▲
   by alflervag 2y ago

   Thank you for this. The generated texts are very informative and educational, so I really see the benefit here.
3. 3.▲
   by alflervag 2y ago

   Nice, I wasn’t aware of this one.
4. 4.▲
   by alflervag 2y ago

   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.
5. 5.▲
   Careful with That Lock, Eugene(kaveland.no)

   60 points by alflervag 2y ago|15 comments
6. 6.▲
   by alflervag 3y ago

   I’m surprised to hear you using this for database normalization. Could you expand on how OpenRefine is helpful here?
7. 7.▲
   by alflervag 3y ago

   Jailer works well with ssh port forwarding.
8. 8.▲
   by alflervag 3y ago

   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