all AI news
sqlite-schema-diagram.sql
March 25, 2024, 5:12 a.m. |
Simon Willison's Weblog simonwillison.net
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().
Via Hacker News
allen big data database definition hacker join queries query returns schema set sql sqlite sql query union via
More from simonwillison.net / Simon Willison's Weblog
Food Delivery Leak Unmasks Russian Security Agents
1 day, 17 hours ago |
simonwillison.net
Quoting Alex Jason, via Adam Savage
2 days, 5 hours ago |
simonwillison.net
Blogmarks that use markdown
2 days, 15 hours ago |
simonwillison.net
No, Most Books Don't Sell Only a Dozen Copies
2 days, 15 hours ago |
simonwillison.net
Snowflake Arctic Cookbook
2 days, 16 hours ago |
simonwillison.net
Jobs in AI, ML, Big Data
Data Architect
@ University of Texas at Austin | Austin, TX
Data ETL Engineer
@ University of Texas at Austin | Austin, TX
Lead GNSS Data Scientist
@ Lurra Systems | Melbourne
Senior Machine Learning Engineer (MLOps)
@ Promaton | Remote, Europe
Intern Large Language Models Planning (f/m/x)
@ BMW Group | Munich, DE
Data Engineer Analytics
@ Meta | Menlo Park, CA | Remote, US