Is there no way to create a connection pool using a database URI?

[cmmartin]

I'm using planetscale which injects a DATABASE_URL env variable. createConnection accepts a connection string, but createPool does not. Is there any way to create a connection pool with a database url?

[rafipiccolo]

What makes you think it doesnt work ?

they both work :

const connectionstring = 'mysql://xxxxxx:[email protected]/xxxx?charset=utf8mb4&connectionLimit=10'
const pool = mysql.createPool(connectionstring);
const connection = mysql.createConnection(connectionstring);

[sidorares]

PoolConfig does accept string argument:

node-mysql2/index.js

Line 22 in 21b13a0

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

node-mysql2/lib/pool_config.js

Line 8 in 21b13a0

options = ConnectionConfig.parseUrl(options);

[cmmartin]

@rafipiccolo @sidorares You're right it does work. But according to the typescript types in the promise package, createConnection can take a string or config, but createPool can only take a config...

https://github.com/sidorares/node-mysql2/blob/master/promise.d.ts#L144-L148

export function createConnection(connectionUri: string): Promise<Connection>;
export function createConnection(
  config: ConnectionOptions
): Promise<Connection>;
export function createPool(config: PoolOptions): Pool;

So you get a typescript error if you pass it a connection string: Type 'string' has no properties in common with type 'PoolOptions'