{"library":"mysql-dbhelper","type":"library","category":null,"description":"A thin wrapper around node-mysql (the mysql npm package) that provides a set of convenience methods for common database operations such as execute, executeScalar, executeFirstRow, executeNonQuery, insert, update, and exist. Version 0.3.2 is the latest release. The library automatically manages connection closing when methods prefixed with '$' are used, and auto-closes on errors. It is designed for use with CoffeeScript callbacks and does not support Promises or async/await. It was last updated in 2018 and is considered stable but in maintenance mode. Compared to modern libraries like knex or typeorm, it lacks query builders, ORM features, and TypeScript support.","language":"javascript","status":"maintenance","version":"0.3.2","tags":["javascript","sqlhelper","sql","mysql","utility"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install mysql-dbhelper","imports":["const dbHelper = require('mysql-dbhelper')(options);","const conn = dbHelper.createConnection();","conn.$execute(sql, params, callback);","conn.execute(sql, callback); // params omitted if none"]},{"cmd":"yarn add mysql-dbhelper","imports":[]},{"cmd":"pnpm add mysql-dbhelper","imports":[]}],"homepage":"https://github.com/yangsibai/mysql-helper","github":"https://github.com/yangsibai/mysql-helper","docs":null,"changelog":null,"pypi":null,"npm":"mysql-dbhelper","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}