Is it possible to create a pool from a connection string?

[rcoundon]

For example, to create a single connection using a connection string we do:

mysql.createConnection(connectionString);

I can't seem to find a way to do the same to create a pool, is it possible?

[rcoundon]

Ah - is this the uri property passed to the createPool function?

[sidorares]

hm, I'd really like .createPool to match .createConnection in a way that it treats single string parameter as a connection uri

I'll keep this issue open as a place for discussion why this is a good or bad idea

[sidorares]

actually I believe this is already behaviour for .createPool

node-mysql2/index.js

Line 22 in dbb344e

return new Pool({ config: new PoolConfig(config) });

node-mysql2/lib/pool_config.js

Line 8 in dbb344e

options = ConnectionConfig.parseUrl(options);

What have you tried @rcoundon , what result you see and what you expected to see?

[rcoundon]

Thanks for getting back to me. What I ended up doing that works is to specify the URL as the uri property of the poolConfig.
i.e.

const pool = mysql.createPool({
    uri: connectionString,
  })

When trying to pass a string to the createPool method TypeScript complains so it's probably a case that the types aren't quite right.
I'll submit a PR to add a string as a possible option to the createPool method.

[rcoundon]

It looks like the types here haven't been touched in a long while and could be improved - e.g. there are lots of implicit any errors in the tests.

If you like, I'll work on improving them and bringing it all up-to-date but will commit this PR for this issue and pick up later as I have a bit of time pressure right now