Created: 2024-03-04 | Updated: 2024-09-21

PostgreSQL

New (v0.3.34)

Table of contents

  1. Node Type: postgresql
  2. Rendering:
  3. Code Snippet:
  4. drawio postgresql vertex:
  5. Advanced for Geeks:
    1. Style:
    2. Vertex size:
    3. Full XML dump:
    4. drawio file:

Node Type: postgresql

Rendering:

lambda

Code Snippet:

# given
mcd = MultiCloudDiagrams()

# when
postgresql_arn = 'arn:aws:postgresql:eu-west-1:123456789012'
postgresql_name = 'arn:aws:postgresql:eu-west-1:123456789012/MainDB'
metadata = {
    "records": "224000",
    "engine": "16.2",
    "volume": "2048Mb",
    "cpu": "512",
    "memory": "2048",
    "version": 5.72,
}
mcd.add_vertex(node_id=postgresql_arn, node_name=postgresql_name, node_type='postgresql', metadata=metadata)

drawio postgresql vertex:

<mxCell id="vertex:postgresql:arn:aws:postgresql:eu-west-1:123456789012" parent="1" vertex="1">
    <mxGeometry width="60" height="63" as="geometry"/>
</mxCell>

Advanced for Geeks:

Style:

style="outlineConnect=0;dashed=0;verticalLabelPosition=bottom;verticalAlign=top;align=left;html=1;shape=mxgraph.aws3.postgre_sql_instance;fillColor=#2E73B8;gradientColor=none;"
attributevalue
alignleft
dashed0
fillColor#2E73B8
gradientColornone
html1
outlineConnect0
shapemxgraph.aws3.postgre_sql_instance
verticalAligntop
verticalLabelPositionbottom

Vertex size:

attributevalue
width60
height63

Full XML dump:

<mxfile host="multicloud-diagrams" agent="PIP package multicloud-diagrams. Generate resources in draw.io compatible format for Cloud infrastructure. Copyrights @ Roman Tsypuk 2023. MIT license." type="MultiCloud">
    <diagram id="diagram_1" name="AWS components">
        <mxGraphModel dx="1015" dy="661" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="850" pageHeight="1100" math="0" shadow="1">
            <root>
                <mxCell id="0"/>
                <mxCell id="1" parent="0"/>
                <mxCell id="vertex:postgresql:arn:aws:postgresql:eu-west-1:123456789012" value="&lt;b&gt;Name&lt;/b&gt;: arn:aws:postgresql:eu-west-1:123456789012/MainDB&lt;BR&gt;&lt;b&gt;ARN&lt;/b&gt;: arn:aws:postgresql:eu-west-1:123456789012&lt;BR&gt;-----------&lt;BR&gt;&lt;b&gt;records&lt;/b&gt;: 224000&lt;BR&gt;&lt;b&gt;engine&lt;/b&gt;: 16.2&lt;BR&gt;&lt;b&gt;volume&lt;/b&gt;: 2048Mb&lt;BR&gt;&lt;b&gt;cpu&lt;/b&gt;: 512&lt;BR&gt;&lt;b&gt;memory&lt;/b&gt;: 2048&lt;BR&gt;&lt;b&gt;version&lt;/b&gt;: 5.72" style="outlineConnect=0;dashed=0;verticalLabelPosition=bottom;verticalAlign=top;align=left;html=1;shape=mxgraph.aws3.postgre_sql_instance;fillColor=#2E73B8;gradientColor=none;" parent="1" vertex="1">
                    <mxGeometry width="60" height="63" as="geometry"/>
                </mxCell>
            </root>
        </mxGraphModel>
    </diagram>
</mxfile>

drawio file:

Download generated postgresql.drawio:

Download