interface RouteDatabaseConfig {
    dbname: string;
    engine: RouteDatabaseConfigEngine;
    host: string;
    password: string;
    port: number;
    query: string;
    username: string;
}

Properties

dbname: string

Database name.

Database engine the route will connect to. If not specified, the default database will be 'PostgreSQL'.

host: string

Database host.

password: string

Database password.

port: number

Database port.

query: string

SQL query to be executed ($TOPIC and $PAYLOAD variables are available, see documentation).

username: string

Database username. Make sure this account can execute the provided query.