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

Datasette Apps: Host custom HTML applications inside Datasette - 18th June 2026
GLM-5.2 is probably the most powerful text-only open weights LLM - 17th June 2026
Publishing WASM wheels to PyPI for use with Pyodide - 13th June 2026

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

databases 112 mysql 81 scaling 148 sql 113 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