search

dwyl / learn-postgresql

🐘 Learn how to use PostgreSQL and Structured Query Language (SQL) to store and query your relational data. 🔍
212 stars 23 forks source link

Generate schema diagram from SQL schema #8

Open nelsonic opened 8 years ago

nelsonic commented 8 years ago

Our objective is to generate the diagram from schema definition not to manually draw it. this avoids us having to manually update the diagram each time a new field is added to a table (which becomes tedious quickly!).

Knowing how the data is stored is also essential for developers at every every stage of development to be sure that data is being stored in a way that makes retrieving it easy.

Starting point for research: http://stackoverflow.com/questions/3223770/tools-to-generate-database-tables-diagram-with-postgresql Possible tool to use:

relates to: #3

continue: https://sourceforge.net/projects/schemaspy/files/schemaspy/SchemaSpy%205.0.0/

nelsonic commented 5 years ago

Taking a look at https://www.dbdesigner.net to design the schema ... ⏳

nelsonic commented 5 years ago

Free plan is more than enough for the purpose of this tutorial "10 Tables Per Model". ✅ image

nelsonic commented 5 years ago

https://www.dbdesigner.net/pricing image

nelsonic commented 5 years ago

image

This sample schema relates to: https://github.com/dwyl/learn-postgresql/issues/51 😉

nelsonic commented 5 years ago

This looks promising: https://github.com/Alexis-benoist/eralchemy