22 ms·
I use graphviz to get a quick postgresql schema overview (good for small to medium databases) https://github.com/enter-haken/schema https://github.com/enter-ha
by enter-haken 5y ago
I use graphviz to get a quick postgresql schema overview (good for small to medium databases)
https://github.com/enter-haken/schema https://github.com/enter-haken/schema
- kh1 5y agoThat looks really cool. Would you possibly share the script?
- enter-haken 5y agoIt's part of the repo. https://github.com/enter-haken/schema/blob/master/schema.sh https://github.com/enter-haken/schema/blob/master/schema.sh It's a mixture of sed, awk and sql.
- kh1 5y agoOh I did take a quick look at the repo but didn't notice it was in the SQL. Thank you!
- magicpointer 5y agoIn a similar vein there is Schemaspy[1]. It generates a static documentation website for your DB, which also uses GraphViz to build ER diagrams. [1] https://github.com/schemaspy/schemaspy https://github.com/schemaspy/schemaspy
- ccakes 5y agoAutogenerated database documentation is often pretty hit and miss but tbls[1] does a pretty good job in that space. Especially when you comment on your tables, fields, views, functions etc (which is a good habit anyway!) the output is quite useful [1] https://github.com/k1LoW/tbls https://github.com/k1LoW/tbls