migrations – Page 7 – Türker Yıldırım

Versioning by adding a field and never removing one

NoteMay 24, 20232 min read

Four years of an API with no version number in the path, because the rule was that nothing incompatible ships. The discipline is cheaper than versioning and it…

The foreign key we added six years late

NoteMay 17, 20232 min read

A column named customer_id with no constraint, and 312 rows pointing at customers that had been deleted. Deciding what to do with the orphans is the work —…

A migration with a batch size and a sleep

NoteMay 2, 20232 min read

Updating four million rows in one statement holds a transaction open long enough for the replica to fall twenty minutes behind. The sleep is not politeness, it is…

A CHECK constraint that documents a JSON shape

NoteApril 23, 20232 min read

A JSON column accepts anything, which is the feature and is also how a column ends up with four different shapes in it. The constraint is enforced on…

TypeScript 5, and the decorators we had been faking

Deep diveApril 21, 20239 min read

5.0 in March, decorators that are the standard proposal rather than the old flag, and a build nobody could explain.

Deprecating a field with a header and a date

NoteMarch 21, 20231 min read

Removing a field from an API response needs a period where consumers can see it is going, and a way to know whether anybody still reads it. The…

A read replica, and the six queries that could not use it

Deep diveMarch 16, 202314 min read

A primary at 80% CPU and reports running during the working day. Setting up the replica takes an afternoon; the consistency model takes a month.

PHPUnit 10, and the listeners that no longer exist

Deep diveFebruary 20, 202314 min read

10.0 in February, a configuration file that has accreted since 2014, and a custom TestListener that the new version has no place for.

Extracting a module without extracting a service

Deep diveFebruary 3, 202314 min read

A billing module everybody agrees should be separate, a team of four, and 88 classes that reference it. The boundary, drawn in code rather than in conversation.

The dynamic property that had been a typo since 2016

Deep diveDecember 13, 202214 min read

8.2 on 8 December deprecates dynamic properties, and the deprecation is the feature. $order->totl has been silently creating a property for six years.