Jean-Karim Bockstael is a user on octodon.social. You can follow them or interact with them if you have an account anywhere in the fediverse. If you don't, you can sign up here.

Random sysadmin tips:
SQL is a great tool but it's also highly destructive if you just forget a WHERE. Just remember to BEGIN; a transaction when you're playing with it, you can then COMMIT; after changes or ROLLBACK/quit.

Since PG is so great, you can even change table structure within a transaction and test changes.

Jean-Karim Bockstael @jkb

@CobaltVelvet That reminds me of that time I did a quick change to a user record on the production database, I was in a hurry and 800,000 user records had to be restored from backups.

· Web · 0 · 1