Migrate mysql connector to mysql2

[geclos]

We currently use node's mysql package which is old and does not support some critical features from new mysql versions. We need to migrate to mysql2 asap.

[cdaraujo1]

@geclos if this could be useful somehow, I have changed two items:

the package-lock.json in my latitude project directory from mysql to mysql2

[...]
"node_modules/@latitude-data/mysql-connector": {
      [...]
      "dependencies": {
        "@latitude-data/base-connector": "^1.1.0",
        "@latitude-data/query_result": "^0.2.0",
        "mysql2": "^3.9.2"
      }
    }
      [...]

and the my-latitude/node_modules/@latitude-data/mysql-connector/dist/index.js

import { createPool } from 'mysql2';

and it worked perfectly.

[geclos]

Yup that's essentially what we need to do here, we just haven't had the bandwith yet. I'll try to squeeze it next week. PRs are also welcome if you feel adventurous.

[github-actions[bot]]

This issue is stale because it has been open for 30 days with no activity.