opensource ERD (entity relation diagram) - pgModeler for PostgreSQL

本文涉及的产品
云原生数据库 PolarDB MySQL 版,Serverless 5000PCU 100GB
简介:

Introduction

pgModeler - PostgreSQL Database Modeler - is an open source data modeling tool designed for PostgreSQL. No more DDL commands written by hand let pgModeler do the job for you! This software reunites the concepts of entity-relationship diagrams and the features that PostgreSQL implements as extensions of SQL standards.

Please, let me know how the pgModeler is working on your system! Help to improve this project, give your feedback about the software or report any bug at Issues page. Additionaly, follow the pgModeler profile on Facebook or Twitter and be up-to-date with new features, fixes and releases.

Licensing

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation version 3.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

See LICENSE for details.

pgmodeler的作者是一位巴西友人, 他的github:

特性 : 

Modeling made easy with pgModeler

Why use pgModeler? Check some reasons below.

Easy to use

Easily create and edit database models with simple and intuitive interface. The software's forms indicates which fields must be filled to provide the correct generation of SQL code.

 

Support to several versions

Model once and export to multiple versions. With its dynamic code generation, pgModeler is capable to export the designed models to different versions of PostgreSQL.

Multiplatform

Built over Qt framework pgModeler can be compiled under Windows, Linux and MacOSX. The build scripts are easily configurable to resolve specifics dependencies on each system.

 

Plugin support

Need some functionality that does not exist yet? Feel free to implement it! Use the plugin development interface and gain access to all pgModeler's classes and functions facilitating the creation of additional features without change a single line on the core code. Check the code documentation here and start to develop your plug-in.

Open source

Get, modify and redistribute the source code without any charge. This project has a public repository that allows forks and full access to source code. Developers can create their own versions from the existing code.

 

Collaborative development

Developer or not you can collaborate! Give your feedback with suggestions for improvements, submit UI translations, report bugs and much more. Simply submit an issue at GitHub and let your mark on pgModeler's development history. The project needs as many as possible contributors to be improved more quickly!


Checkout the main features

... and be sure that pgModeler can be integrated to your development tool set!


Create several kind of objects with an easy interface

pgModeler supports the creation of the most basic object like a simple column as well advanced objects like user-defined languages, functions, operators and many others with easy-to-use forms.

Automatic generation of columns and constraints

With the column propagation mechanism pgModeler automatically creates columns and constraints as the user connects tables using the available relationships.

Export models in three different ways

pgModeler is capable to export the models to SQL script file, PNG image or directly to a PostgreSQL server.

Generate models from existing databases

With the reverse engineering process pgModeler can create reliable models based upon existing databases.

XML based files

As an open source tool pgModeler gives the complete access to its source code as well to the content of any generated file. All created files are XML based which means the user can handle these files in third party softwares.

 

Restore previous work in case of failure

In case of unexpected quit the user don't lose all your work this because pgModeler stores temporary models and will recover them in the next execution.

Model structure validation and automatic fixes

In order to avoid references/rules breaking during design time as well when exporting the model to PostgreSQL, pgModeler validates the models from time to time. This validation process creates a consistent and almost error-free model.

Customizable functionalities

With an extensive set of configurations pgModeler gives to the user the freedom to costumize the most of its behavior with an intuitive settings dialog.

Command line interface to automate export process

Automate the export process without use the GUI module with the command line version of pgModeler.

Additional features

Some other important features are: object search feature for large models, the plugin development interface, support for geospatial data types (implemented by PostGiS 2.x extension), translatable user interface and many others. More details available on Wiki pages.















































































demo : 
opensource ERD (entity relation diagram) - pgModeler for PostgreSQL - 德哥@Digoal - PostgreSQL research

[参考]
相关实践学习
使用PolarDB和ECS搭建门户网站
本场景主要介绍基于PolarDB和ECS实现搭建门户网站。
阿里云数据库产品家族及特性
阿里云智能数据库产品团队一直致力于不断健全产品体系,提升产品性能,打磨产品功能,从而帮助客户实现更加极致的弹性能力、具备更强的扩展能力、并利用云设施进一步降低企业成本。以云原生+分布式为核心技术抓手,打造以自研的在线事务型(OLTP)数据库Polar DB和在线分析型(OLAP)数据库Analytic DB为代表的新一代企业级云原生数据库产品体系, 结合NoSQL数据库、数据库生态工具、云原生智能化数据库管控平台,为阿里巴巴经济体以及各个行业的企业客户和开发者提供从公共云到混合云再到私有云的完整解决方案,提供基于云基础设施进行数据从处理、到存储、再到计算与分析的一体化解决方案。本节课带你了解阿里云数据库产品家族及特性。
相关文章
|
SQL 关系型数据库 数据库
Entity Freamwork 6连接PostgreSql数据库
原文 Entity Freamwork 6连接PostgreSql数据库 开发环境 VS 2015  Update 1   Postgre Sql 9.4 使用过程 1.使用Nuget在项目中添加对EntityFramework6.Npgsql的引用 2.下载并安装NpgsqlDdexProvider程序,下载地址: https://github.com/npgsql/npgsql/releases ,请下载exe文件,他会帮你做很多事情。
1036 0
|
3天前
|
关系型数据库 分布式数据库 数据库
阿里云PolarDB登顶2024中国数据库流行榜:技术实力与开发者影响力
近日,阿里云旗下的自研云原生数据库PolarDB在2024年中国数据库流行度排行榜中夺冠,并刷新了榜单总分纪录,这一成就引起了技术圈的广泛关注。这一成就源于PolarDB在数据库技术上的突破与创新,以及对开发者和用户的实际需求的深入了解体会。那么本文就来分享一下关于数据库流行度排行榜的影响力以及对数据库选型的影响,讨论PolarDB登顶的关键因素,以及PolarDB“三层分离”新版本对开发者使用数据库的影响。
19 3
阿里云PolarDB登顶2024中国数据库流行榜:技术实力与开发者影响力
|
1月前
|
关系型数据库 分布式数据库 数据库
阿里云瑶池数据库训练营权益:PolarDB开发者大会主题资料开放下载!
阿里云瑶池数据库训练营权益:PolarDB开发者大会主题资料开放下载!
|
1天前
|
关系型数据库 MySQL 测试技术
数据库专家带你体验PolarDB MySQL版 Serverless的极致弹性特性!
本次基于阿里云瑶池数据库解决方案体验馆,带你体验PolarDB MySQL Serverless形态下的性能压测环境,基于可选择的标准压测工具进行压测,构造弹性场景进行压测,实时动态展示弹性能力、价格和性价比结果,压测环境可开放定制修改、可重复验证。参与活动即有机会获得鼠标、小米打印机、卫衣等精美礼品。
数据库专家带你体验PolarDB MySQL版 Serverless的极致弹性特性!
|
2天前
|
Cloud Native 关系型数据库 分布式数据库
热烈祝贺阿里云PolarDB登顶2024最新一期中国数据库流行榜
【2月更文挑战第3天】热烈祝贺阿里云PolarDB登顶2024最新一期中国数据库流行榜
|
2天前
|
关系型数据库 MySQL 测试技术
数据库专家带你体验PolarDB MySQL版 Serverless的极致弹性特性
本次基于阿里云瑶池数据库解决方案体验馆,带你体验PolarDB MySQL Serverless形态下的性能压测环境,基于可选择的标准压测工具进行压测,构造弹性场景进行压测,实时动态展示弹性能力、价格和性价比结果,压测环境可开放定制修改、可重复验证。参与活动即有机会获得鼠标、小米打印机、卫衣等精美礼品。
|
7天前
|
关系型数据库 MySQL 分布式数据库
PolarDB for MySQL数据库外网连接解析失败的原因
【2月更文挑战第5天】PolarDB for MySQL数据库外网连接解析失败的原因
52 8
|
9天前
|
Cloud Native 关系型数据库 分布式数据库
推荐你使用数据库排行榜第一的PolarDB
数据库大家都使用的,才是最好的,有足够多的案例和样本。
32798 15
|
9天前
|
SQL 关系型数据库 分布式数据库
|
24天前
|
SQL 存储 关系型数据库
MySQL技能完整学习列表——1、数据库基础概念——1、关系型数据库(Relational Database)
MySQL技能完整学习列表——1、数据库基础概念——1、关系型数据库(Relational Database)
133 0

热门文章

最新文章