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
2 days, 9 hours ago |
simonwillison.net
Quoting Alex Jason, via Adam Savage
2 days, 20 hours ago |
simonwillison.net
Blogmarks that use markdown
3 days, 6 hours ago |
simonwillison.net
No, Most Books Don't Sell Only a Dozen Copies
3 days, 7 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
Software Engineering Manager, Generative AI - Characters
@ Meta | Bellevue, WA | Menlo Park, CA | Seattle, WA | New York City | San Francisco, CA
Senior Operations Research Analyst / Predictive Modeler
@ LinQuest | Colorado Springs, Colorado, United States