Custom Extension DB connection

Wappler General Need Help
1

Hello Wapplers,

I’m developing a custom extension for Wappler which will use a bit advanced SQL queries.
For that I need to create a Pool for pg.

	const db = require('../../../app/modules/connections/db');

    const pool = new Pool({
        user: db.options.connection.user,
        host: db.options.connection.host,
        database: db.options.connection.database,
        password: db.options.connection.password,
        port: db.options.connection.port,
    });

Is it safe to use such construction?
Or there is a smarter way to do the same?

Thank you in advance.

2

I do all my advanced queries in mysql views… they rock!