ERDTool alpha version for trial

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

ERDTool alpha version for trial

Akshay Joshi
Hi All

pgAdmin team has pleased to announce that we have implemented the new feature ERDTool (Alpha). It is not released yet as it is in the alpha phase, so we are providing the installers for trial purposes.

We highly appreciate it if a larger audience test this new ERDTool and provide their feedback(positive/negative)   

How to use:

1) You can start a new ERD project from Tools -> New ERD Project. This will open a blank canvas. Use the add button to create tables. Use - "1M" for one to many links. Explore other options as well.

image.png.      image.png


2) Alternatively, you can also generate the ER diagram for an existing database. This will pull all the tables, link them, and arrange them. You can also auto arrange it from the toolbar button.

image.png.   image.png 


3) You can save the project. The extension used here by the tool is .pgerd. You can load this project anytime later.

image.png


4) Once you're happy, you can click on the "Generate SQL" to get the DDL. This will open a new query tool with DDL.
Screenshot 2020-12-10 at 2.29.17 PM.png.    image.png

--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Principal Software Architect
EDB Postgres
Mobile: +91 976-788-8246

Reply | Threaded
Open this post in threaded view
|

Re: ERDTool alpha version for trial

JackRG1
I have one question: is there any risk that this tool, when used with an existing database, can affect the database at all (assuming you don’t execute any of the DDL generated by it)? In other words, is it safe to use with existing databases without risking any damage or changes to the performance of the database?

On Dec 16, 2020, at 3:29 AM, Akshay Joshi <[hidden email]> wrote:

Hi All

pgAdmin team has pleased to announce that we have implemented the new feature ERDTool (Alpha). It is not released yet as it is in the alpha phase, so we are providing the installers for trial purposes.

We highly appreciate it if a larger audience test this new ERDTool and provide their feedback(positive/negative)   

How to use:

1) You can start a new ERD project from Tools -> New ERD Project. This will open a blank canvas. Use the add button to create tables. Use - "1M" for one to many links. Explore other options as well.

<image.png>.      <image.png>


2) Alternatively, you can also generate the ER diagram for an existing database. This will pull all the tables, link them, and arrange them. You can also auto arrange it from the toolbar button.

<image.png>.   <image.png> 


3) You can save the project. The extension used here by the tool is .pgerd. You can load this project anytime later.

<image.png>


4) Once you're happy, you can click on the "Generate SQL" to get the DDL. This will open a new query tool with DDL.
<Screenshot 2020-12-10 at 2.29.17 PM.png>.    <image.png>

--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Principal Software Architect
EDB Postgres
Mobile: +91 976-788-8246


Reply | Threaded
Open this post in threaded view
|

Re: ERDTool alpha version for trial

Aditya Toshniwal
Hi Jack,

On Thu, Dec 17, 2020 at 1:56 AM Jack Royal-Gordon <[hidden email]> wrote:
I have one question: is there any risk that this tool, when used with an existing database, can affect the database at all (assuming you don’t execute any of the DDL generated by it)? In other words, is it safe to use with existing databases without risking any damage or changes to the performance of the database?
The tool does not affect or execute any DDL on the existing DB. It generates a diagram for you. You can then use the SQL button to generate the CREATE DDL for the diagram, but it will not execute automatically.

On Dec 16, 2020, at 3:29 AM, Akshay Joshi <[hidden email]> wrote:

Hi All

pgAdmin team has pleased to announce that we have implemented the new feature ERDTool (Alpha). It is not released yet as it is in the alpha phase, so we are providing the installers for trial purposes.

We highly appreciate it if a larger audience test this new ERDTool and provide their feedback(positive/negative)   

How to use:

1) You can start a new ERD project from Tools -> New ERD Project. This will open a blank canvas. Use the add button to create tables. Use - "1M" for one to many links. Explore other options as well.

<image.png>.      <image.png>


2) Alternatively, you can also generate the ER diagram for an existing database. This will pull all the tables, link them, and arrange them. You can also auto arrange it from the toolbar button.

<image.png>.   <image.png> 


3) You can save the project. The extension used here by the tool is .pgerd. You can load this project anytime later.

<image.png>


4) Once you're happy, you can click on the "Generate SQL" to get the DDL. This will open a new query tool with DDL.
<Screenshot 2020-12-10 at 2.29.17 PM.png>.    <image.png>

--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Principal Software Architect
EDB Postgres
Mobile: +91 976-788-8246




--
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"