25th March 2024 - Link Blog
sqlite-schema-diagram.sql (via) A SQLite SQL query that directly returns a GraphViz definition that renders a diagram of the database schema, by Tim Allen.
The SQL is beautifully commented. It works as a big set of UNION ALL statements against queries that join data from pragma_table_list(), pragma_table_info() and pragma_foreign_key_list().
Recent articles
- GPT-5.4 mini and GPT-5.4 nano, which can describe 76,000 photos for $52 - 17th March 2026
- My fireside chat about agentic engineering at the Pragmatic Summit - 14th March 2026
- Perhaps not Boring Technology after all - 9th March 2026