virtualice 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.
virtualice @CobaltVelvet

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.

· Web · 11 · 13

@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.

@wxcafe ah presque j'y ai pensé juste après

@CobaltVelvet
BEGIN; SET TRANSACTION READ ONLY;
Even better when you're just exploring :D