Simon Willison’s Weblog

19th June 2018 - Link Blog

github/gh-ost: Thoughts on Foreign Keys? The biggest challenge I’ve seen with foreign key constraints at scale (at least with MySQL) is how they conflict with online schema migrations using tools like pt-online-schema-change or GitHub’s gh-ost. This is a good explanation of the issue by Shlomi Noach, one of the gh-ost maintainers.

Posted 19th June 2018 at 4:12 pm

Recent articles

I vibe coded my dream macOS presentation app - 25th February 2026
Writing about Agentic Engineering Patterns - 23rd February 2026
Adding TILs, releases, museums, tools and research to my blog - 20th February 2026

This is a link post by Simon Willison, posted on 19th June 2018.

databases 110 mysql 81 scaling 147 sql 109 shlominoach 2

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe