Custom logging

[InanisOmnia]

I think a great addition to this package would be the ability to map the logs to an external function

For example I used to use bettersqlite3 and this allowed you to pass a function when you setup the connection that will get called with the value of the logs. Options could include levels of logging such as errors, information or even as deep as debug which would log every single sql query run.

I dearly miss this feature when using mariadb.

Very rough example usage

const myLogger = {
    debug(msg) {
        console.log(`${new Date().toLocaleString()} ${msg}
    },
    error(msg) {
        console.log(`ERROR: ${new Date().toLocaleString()} ${msg}
    },
}

const conn = await mariadb.createConnection({
    host: "192.168.1.1",
    user: "user",
    password: "password",
    logger: {
        verbose: myLogger.debug // the raw sql of all sql queries
        error: myLogger.error // all errors
    }
});

[rusher]

That would be a great addition, created https://jira.mariadb.org/browse/CONJS-167 for that.

[rusher]

released in 3.0 version. (currently in beta for now)