DEVOURED
Safe Not Safe (Tool)
Safe Not Safe is a local-only, browser-based tool for auditing PostgreSQL migrations for risky DDL operations.
What: The tool uses a WebAssembly port of the PostgreSQL parser to detect unsafe patterns like blocking locks or faulty constraint rollouts without requiring server-side interaction or data uploads.
Takeaway: Test your next SQL migration file at https://safenotsafe.dev before deployment to prevent production downtime.
Decoder
- DDL (Data Definition Language): SQL statements used to define or modify database structures, such as CREATE, ALTER, or DROP.
- Blocking Lock: A database lock that prevents other transactions from accessing or modifying the affected rows or tables, potentially causing application-level latency or outages.
Original article
ALTER TABLE users ADD COLUMN status text DEFAULT 'active';
CREATE INDEX CONCURRENTLY users_created_at_idx ON users (created_at);
ALTER TABLE orders ADD CONSTRAINT orders_user_id_fk FOREIGN KEY (user_id) REFERENCES users(id) NOT VALID;
ALTER TABLE orders VALIDATE CONSTRAINT orders_user_id_fk;
Explore all 67 articles in today's digest
Fresh dev news, AI-digested daily. Never miss a trend at devoured.fyi