Become a member
Sign in
Shaw Vrana
Shaw Vrana

Shaw Vrana

54 Following
1 Followers
·
  • Profile
  • Claps
  • Highlights

Highlighted by Shaw Vrana

See more

From PostgreSQL at Scale: Database Schema Changes Without Downtime by James Coleman

While most of the attributes involved in creating a table do not involve other database objects, including a foreign key in your initial table definition will cause Postgres to acquire a SHARE ROW EXCLUSIVE lock against the referenced table blocking any concurrent DDL or row modifications. While this lock should be short-lived, it nonetheless requires the same caution as any other operation acquiring such a lock. We prefer to split these into two separate operations: create the table and then add the foreign key.

From The Famous Rear Stairs of Balboa Terrace (or How Discretionary Review Is Broken) by Jane Natoli

… It’s a constant dance, doing just enough to please the neighbors and fit that ineffable character. When will we have enough character to house all the people of San Francisco?

From Streets Ahead by Grow The Richmond

Then start imaging what it could be. Think about Clement when the Farmer’s Market is going and imagine it being like that all the time, full of people and vendors and vivacity instead of parked cars. Imagine a truly protected bike lane from Arguello to the Pacific Ocean, not just paint. Picture a c…

Claps from Shaw Vrana

See more

PostgreSQL at Scale: Database Schema Changes Without Downtime

James Coleman

Nextcloud on AWS

Nicola Moretto

Beginning Python Programming — Part 15

Bob Roebling