I use the Community Edition of MySQL Workbench for creating pretty pictures of my schema - but I'd rather create the DDL that actually runs on my database by hand.
For managing the DDL scripts, I have good experience with Liquibase and Power Architect can also create the Liquibase XML directly from the ER diagram.
发布评论
评论（5）
我使用 社区版 /" rel="nofollow">MySQL Workbench 用于创建我的架构的漂亮图片 - 但我宁愿手动创建实际在我的数据库上运行的 DDL。
I use the Community Edition of MySQL Workbench for creating pretty pictures of my schema - but I'd rather create the DDL that actually runs on my database by hand.
您还可以尝试
用于创建 ER 图。
为了管理 DDL 脚本，我对 Liquibase 有很好的经验，Power Architect 还可以直接从 ER 图创建 Liquibase XML。
You can also try
for creating ER diagrams.
For managing the DDL scripts, I have good experience with Liquibase and Power Architect can also create the Liquibase XML directly from the ER diagram.
我主要使用纸张或直接在 psql 提示符中绘制架构。
许多 UML 工具都具有 DDL 生成功能（请参阅 argouml），但根据我的经验，直接编写模式会更快。然后您可以立即进行测试。
I mostly use paper or sketch the schema directly in psql prompt.
Many UML tools have DDL-generation (see argouml), but in my experience it's faster to write the schema directly. Then you can test it right away.
遗憾的是，只能在 Windows 中使用，EMS SQL Manager 非常好
http://www.sqlmanager.net/products /postgresql/经理
Use only in windows unfortunately, EMS SQL Manager is very good
http://www.sqlmanager.net/products/postgresql/manager
pgModeler 根据 GPL 授权，多平台。
二进制安装程序花费 4 美元，我认为这是值得的。
pgModeler licensed under GPL, multiplatform.
Binary installer costs 4$, I think it's worth it.