Developer Guide: Databases
This service allows you to read and write from a database.
Supported databases from MySQL 5.1+, PostgreSQL 8.4+. and Sql Server 2008+
Installing the Application Service
This service allows you to connect to your own database to modify and read rows from the flow
|Database||Read and write to database.|
|Auto Binding||Each table will have a Type and each type will be a binding with the table in database.|
There is a limit of 1000 returned rows for each query.
When installing the Service, you should use the following settings:
This service doesn’t have a production url yet, but you can check how it works using the staging url:
|Username||String||✔||Username for your database.|
|Password||Password||✔||Password for your database.|
|Host||String||✔||Host of your database.|
|Port||Numeric||✔||Port of your database.|
|Database Type||String||✔||Type of database (supported: postgresql, mysql and sqlserver)|
|Database Name||String||✔||Name of your database.|
|Database schema||String||✔||Database schema.|
We can not provide a description of the types because it will depends of your database metadata.
When is installed this service generates a Type for each table in your database, these types can be saved, loaded or deleted.
Each table will became a type and each supported row a field in the type.
Currently supported types
Supported for all databases (supported by JDBC)
Specific for SQL Server
Specific for PostgreSql
This service doesn’t support any action.
You can access the source code and developer details about implementation on GitHub.