schemaspy
Postico
| schemaspy | Postico | |
|---|---|---|
| 17 | 9 | |
| 3,014 | 477 | |
| 1.5% | - | |
| 9.4 | 0.0 | |
| 4 days ago | about 2 years ago | |
| HTML | Python | |
| GNU Lesser General Public License v3.0 only | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
schemaspy
- Show HN: Open source database diagram editor
-
SQLite Schema Diagram Generator
You might try https://schemaspy.org/ - it generates a website with ER diagrams that only go one or two relationships out, but they have clickable table names to get to the next diagram
- Document your database simply and easily
-
DE new on the job
I had the same problem when i started my job. I used SchemaSpy to generate an html with all of metadata and ERD diagrams as a reference point. Then i used dbt to connect to the database and used dbt to document the table and column that i have worked on. It takes time to document but it's worth it if you company don't have your database documented yet.
-
Spring, SchemaSpy DB docs, and GitHub Pages
SchemaSpy is a standalone application that connects to the database, scans its tables and schemas, and generated nicely composed HTML documentation. You can check out an example sample by this link but I'm showing you just one screenshot to clarify my point.
-
pgAdmin Generate ERD stuck on load
I like https://schemaspy.org/
- Tips on investigating new databases with minimal documentation?
-
Looking for a database documenting tool to generate docs for analysts
I like the diagrams and reports SchemaSpy generates. If you are using a DBMS that allows setting comments to tables, views, columns (and other objects), those will be included and that makes those reports even more helpful
- What some of your recommended database mappers?
-
Schema to dia/UML/etc/whatever
https://schemaspy.org/ creates nice looking diagrams.
Postico
-
A collection of useful Mac Apps
Postico - Price: $35.99 (one-time purchase) PostgreSQL client for Mac that features a user-friendly interface and powerful features.
-
macOS Dev Setup
If you prefer a GUI (Graphical User Interface), Postico has a simple free version that let's you explore tables and run SQL queries.
-
Most popular PostgreSQL GUIs in 2022: the (almost) scientific list
Postico is macOS PostgreSQL client for reading data, doing basic manual data entry and editing your database structure.
-
Show HN: PostgresML, now with analytics and project management
You might want to use a different elephant logo... the branding implies that it is an official part of the project.
E.g. Postico uses an elephant but not the _same_ elephant - https://eggerapps.at/postico/
-
Recommendation for Software Engineer/Developer and Software architect apps?
TablePlus for multiple databases or Postico just for Postgres
- 波斯蒂科。适用于Mac的现代PostgreSQL客户端 (Postico: A Modern PostgreSQL Client for the Mac)
-
Postico: A Modern PostgreSQL Client for the Mac
There are annoying show-stopper bugs that the developer refuses to fix, like this one for not being able to set options for null/empty values when importing data from csv ( https://github.com/jakob/Postico/issues/406). Or issues importing CSVs exported by Postico itself, that seems like a pretty basic requirement.
-
Hacker News top posts: Mar 25, 2022
Postico: A Modern PostgreSQL Client for the Mac\ (98 comments)
What are some alternatives?
plantuml - Generate diagrams from textual description
postgresml - The GPU-powered AI application database. Get your app to market faster using the simplicity of SQL and the latest NLP, ML + LLM models.
dbml - Database Markup Language (DBML), designed to define and document database structures
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
graphviz
pgadmin4 - 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.
mermaid - Generation of diagrams like flowcharts or sequence diagrams from text in a similar manner as markdown
heroku-postico - Heroku Postgres connection tool for Postico
sketchviz-docker - Graphviz -> Sketchy PNG in one image, for automation
HomeBrew - 🍺 The missing package manager for macOS (or Linux)
TablePlus - TablePlus macOS issue tracker