Lupdo Driver For Mysql.
Lupdo-mysql, under the hood, uses stable and performant npm packages:
Base Example
const { createMysqlPdo } = require('lupdo-mysql');
// ES6 or Typescrypt
import { createMysqlPdo } from 'ludpo-mysql';
const pdo = createMysqlPdo(
{
host: 'localhost',
port: 3306,
user: 'user',
password: 'password',
database: 'database'
},
{ min: 2, max: 3 }
);
const run = async () => {
const statement = await pdo.query('SELECT 2');
const res = statement.fetchArray().all();
console.log(res);
await pdo.disconnect();
};
run();
https://github.com/mysqljs/mysql#connection-options
Note The
host
option also accepts a list ofhost:port
the pool will generate the connection using a random host from the list.
By default Ludpo-mysql overrides user connection options with this:
{
rowsAsArray: true,
namedPlaceholders: true,
dateStrings: false,
supportBigNumbers: true,
bigNumberStrings: true,
decimalNumbers: false,
typeCast: typeCast,
timezone: 'Z',
stringifyObjects: true,
multipleStatements: false,
trace: false,
flags: [],
queryFormat: undefined,
debug: ${ATTR_DEBUG}
}
Lupdo-mysql has a custom type parser
boolean
are returned as number 1 or 0.bigint
are returned as number or BigInt when necessary.binary
andblob
are returned as Buffer.zerofill
numbers are returned as string.- all
geometry
are returned as json string, coordinates are identified as x,y. - all others types are always returned as string.
Lupdo-mysql ignore type definition of TypeBinding
parameter.
Lupdo-mysql does not support array of parameters.
Lupdo-mysql support named parameter with syntax :name
, the support is guaranteed only if all placeholder have a binding.\
Lupdo-mysql support numeric parameter with syntax ?
.
Lupdo-mysql default charset
is UTF8MB4_UNICODE_CI
, you can override through config.
Lupdo-mysql force mysql2
timezone to Z
, javascript Date
bindings for timestamp will be converted in String using UTC timezone.
Warning If you want to store an exact timestamp, you must bind a string or a UTC date like
new Date(Date.UTC(2023, 0, 1, 23, 22, 20, 123))
; usingnew Date('2023-01-01 23:22:20.123')
will generate a UTC date based on OS timezone.
You can assign Mysql timezone through lupdo create callback in this way.
const { createMysqlPdo } = require('lupdo-mysql');
// ES6 or Typescrypt
import { createMysqlPdo } from 'ludpo-mysql';
const pdo = createMysqlPdo(
{
host: 'localhost',
port: 3306,
user: 'user',
password: 'password',
database: 'database'
},
{
min: 2,
max: 3,
created: async (uuid, connection) => {
await connection.query("SET time_zone='Europe/Rome';");
}
}
);
Lupdo-mysql support kill query.