search

simonw / datasette

An open source multi-tool for exploring and publishing data
https://datasette.io
Apache License 2.0
9.39k stars 668 forks source link

/database/-/inspect #531

Open simonw opened 5 years ago

simonw commented 5 years ago

Build /database/-/inspect which shows tables, columns, column types and foreign keys

It won't show table counts. Or maybe it will include them optionally but only for -i databases, in a special area of the JSON reserved for immutable-only inspect details.

Originally posted by @simonw in https://github.com/simonw/datasette/issues/465#issuecomment-506797086

simonw commented 5 years ago

Including foreign keys here will let me build a plugin for visualizing table relationships based on https://observablehq.com/@d3/force-directed-graph