node-mysql2
node-mysql2 copied to clipboard
sidorares
:zap: fast mysqljs/mysql compatible mysql driver for node.js
``` const mysql = require("mysql2/promise"); var mpool = mysql.createPool({ connectionLimit: 10, host: process.env.MYSQL_IP, user: process.env.MYSQL_USER, password: process.env.MYSQL_PASSWORD, database: process.env.MYSQL_DB, }); async function getSomething() { const [rows, fields] = await mpool.execute(...
When the typeCast option is used, queries tend to run up to 10x slower under load. A perf profile shows that most of the additional time is spent in column_defintion.js...
There are few issues with `typeCast` currently, and most of them better solved by moving it to a different level where it sits in the driver, I think it applies...
database table ID either **number** or **string**
Hello, I have a problem while connect to out MySQL database when i **DO NOT** set the 'database' attribute. when I set the 'debug' mode to true, I saw that...
I have a query that returns more than 300 thousand records in a table. My code is [Dump.ts](https://github.com/juliandavidmr/DumpMySQL/blob/master/src/dump.ts#L176). After executing this query, the process memory collapses, I tried to fix...
We are getting the following error on Node 12.8. ``` {"timestamp":"2020-10-05T16:00:58.348Z","error":{"code":"ERR_PACKAGE_PATH_NOT_EXPORTED"},"level":"error","message":"uncaughtException: Package subpath './lib/constants/types' is not defined by \"exports\" in /home/ec2-user/ucep-api/node_modules/mysql2/package.json\nError [ERR_PACKAGE_PATH_NOT_EXPORTED]: Package subpath './lib/constants/types' is not defined by \"exports\"...
I've recently posted a bug in the base library for `mysql`, but I'm not sure if this library shares the same problem: https://github.com/mysqljs/mysql/issues/2391 When using `mysql2` as our library, column...
# Problem Keep getting `ER_PARSE_ERROR` when running queries against a MySQL 5.6 database because the Node `mysql` driver fails to expand the value placeholders, so a query written like this...
