Querying remote database using Jovo

[Amir_Ansari]

All the material I have found in the docs and forum suggests that Jovo primarily supports the creation and use of local databases placed in the project files. Is there anyway to access a remote database using the the Jovo framework’s MySQL feature?

[jacob]

This documentation link shows how you can connect to remote mysql server

[Docs] MySQL | Jovo Framework

Specifically,

// src/config.js
module.exports = {
    db: {
        MySQL: {
            tableName: 'yourTableName',
            connection: {
                host: process.env.MYSQL_ADDR || 'localhost',
                port:  process.env.MYSQL_PORT || '9000',
                user: process.env.MYSQL_USER || 'user',
                password: process.env.MYSQL_PASSWORD || 'password',
                database: process.env.MYSQL_DATABASE || 'jovoapp',
                },
        },
    },

    // ...

};