Skip to content

Instantly share code, notes, and snippets.

@b3h3rkz
b3h3rkz / faucets.md
Last active June 25, 2024 10:55
Bitcoin Testnet Faucets
@bryanrite
bryanrite / safe.md
Last active February 19, 2024 09:45
Safe Postgres Operations on High Volume Tables

Originally taken from: Braintree Article and expanded on by me.

Safe

  • Add a new column
  • Drop a column
  • Rename a column
  • Add an index concurrently (Example), Note: it will still take a long time to run the migration, but it won't write-lock the table.
  • Drop a constraint (for example, non-nullable)
  • Add a default value to an existing column