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

Intro

This service allows you to connect to your own database to modify and read rows from the flow

Features

Name Description
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.

Configuration

When installing the Service, you should use the following settings:

Connection Uri

This service doesn’t have a production url yet, but you can check how it works using the staging url:

https://services-staging.manywho.com/api/sql/1

Configuration Values

Name Type Required Description
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.

Types

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)
  • TINYINT
  • SMALLINT
  • INTEGER
  • BIGINT
  • FLOAT
  • REAL
  • DOUBLE
  • NUMERIC
  • DECIMAL
  • CHAR
  • VARCHAR
  • LONGVARCHAR
  • DATE
  • TIMESTAMP
  • BLOB
  • CLOB
  • BOOLEAN
  • NCHAR
  • NVARCHAR
  • LONGNVARCHAR
Specific for SQL Server
  • DATETIMEOFFSET
Specific for PostgreSql
  • UUID
  • TIMESTAMP

Actions

This service doesn’t support any action.

Code

You can access the source code and developer details about implementation on GitHub.

GitHub

https://github.com/manywho/service-sql.git