# Relational database (WIP)

Here, you can create one or multiple database connections to already existing PostgreSQL databases.

See [Internal PostgreSQL](https://docs.heisenware.com/~/changes/Q625pQNc0nXqVGPtyjAY/building-apps/data-and-file-storage/internal-postgresql) for a list of available functions after the connection has been established and a deeper explanation of relational databases.

## Connecting to the database

With the `create` function, you can create an instance for each new database you want to connect to. To do so, insert a name in the first field and fill the following information in the second field:

<table><thead><tr><th width="150">Parameter</th><th width="119">Type</th><th>Description</th></tr></thead><tbody><tr><td>dialect</td><td>String</td><td>The dialect of the database you are connecting to. One of mysql, postgres, sqlite, db2, mariadb and mssql.</td></tr><tr><td>database</td><td>String</td><td>The name of the database.</td></tr><tr><td>username</td><td>String</td><td>The username which is used to authenticate against the database.</td></tr><tr><td>host</td><td>String</td><td>The host of the database.</td></tr><tr><td>port</td><td>String</td><td>(optional) The port of the database. If not defined, the standard port is tried.</td></tr><tr><td>ssl</td><td>String</td><td>(default: <code>true</code>) A flag that defines if the connection should encrypted with ssl or not.</td></tr></tbody></table>

Fill the third field with the password for accessing the database.

After creating a connection to a database, you can use all the functions listed in [internal PostgreSQL](https://docs.heisenware.com/~/changes/Q625pQNc0nXqVGPtyjAY/building-apps/data-and-file-storage/internal-postgresql).

## Deleting a database connection

Simply drag the `delete` function onto the board and insert the name of the instance, whose connection you want to delete.