![]() The more useful aspect is when you've already got a central table and you're trying to understand the closest relationships to that table: maybe directly related or one away. At the whole database view, the best you can hope for is finding certain "information clusters", places where many references cluster, that can get you to the major ideas implemented by the application this is helpful sometimes when coming to an application you haven't encountered before. Depending on the database vendor and the how the database was developed, if certain documentation was built into the database schema, some diagramming tools can pull this into the right places and so surface that documentation in way that can be more fluidly examined (think PostgreSQL's COMMENT ON functionality).Īs others have pointed out, I usually don't use them to try to get the big picture: you're right in it is a morass of over-lapping lines and tiny boxes. My experience is that they are helpful, though they can sometimes be a little overrated. The databases I deal with will typically be highly normalized with table counts from around 300 on the low end and just over 1000 on the higher end. pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.Over the course of my career I've been pretty database centric in the work that I do. Database Markup Language (DBML), designed to define and document database structures Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Get your app to market faster using the simplicity of SQL and the latest NLP, ML + LLM models. The GPU-powered AI application database. Generate diagrams from textual description When comparing Postico and schemaspy you can also consider the following projects: ![]() Postico: A Modern PostgreSQL Client for the Mac.It does that "pick a relation and show me relationships a couple degrees of separation" thing. It inspects an existing database and creates documentation based on what it finds. Its not a database design GUI or anything like that. The open source diagramming tool I use is called SchemaSpy ( ). Of course manually just telling the tool to diagram only a particular subject area of the database at a time reduces the sense of noise in these diagrams and typically you're only really trying to understand the data structure of such a subset of the database at any one time anyway. There are database diagramming tools that will allow you to pick a relation and then limit the diagram to those one away, two away sets of relationships. Over the course of my career I've been pretty database centric in the work that I do.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |