kayenne is a user on social.wxcafe.net. 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.

kayenne @riking

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

· Web · 2 · 2