{"library":"sy-node-mysql","type":"library","category":null,"description":"A lightweight MySQL query builder for Node.js (v2.0.10, last updated 2019). Wraps mysql2 with a simple API for SELECT, INSERT, UPDATE, and DELETE operations with support for read/write splitting, connection pooling, optional big number handling, and timezone configuration. Key differentiator: built-in read-only pool support and automatic NULL handling for undefined fields. Requires Node >=6.0. Release cadence: sporadic, no recent updates.","language":"javascript","status":"maintenance","version":"2.0.10","tags":["javascript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install sy-node-mysql","imports":["const Mysql = require('sy-node-mysql');\nconst db = new Mysql(config);","const rows = await db.select(table, options, dbName, readonly);","const pool = db.get(dbName);\nawait pool.query(sql, params);"]},{"cmd":"yarn add sy-node-mysql","imports":[]},{"cmd":"pnpm add sy-node-mysql","imports":[]}],"homepage":"https://github.com/FredyXue/sy-node-mysql#readme","github":"https://github.com/FredyXue/sy-node-mysql","docs":null,"changelog":null,"pypi":null,"npm":"sy-node-mysql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}