3 ms·
I've been doing something similar to this using an Observable notebook - this one joins the sqlite_master table against the pragma_foreign_key_list() SQLite fun
by simonw 6y ago
I've been doing something similar to this using an Observable notebook - this one joins the sqlite_master table against the pragma_foreign_key_list() SQLite function and uses the returned data to show a DOT diagram:
https://observablehq.com/@simonw/datasette-table-diagram https://observablehq.com/@simonw/datasette-table-diagram
It defaults to showing the tables from my GitHub example database but you can paste in the URL to another Datasette to see that one visualized instead - try https://latest.datasette.io/fixtures https://latest.datasette.io/fixtures for example