{"library":"nodedb-helper","type":"library","category":null,"description":"A lightweight MySQL query builder and connection manager for Node.js, current version 1.4.1. It optimizes MySQL connections for re-use and supports multiple databases in a single application. Reads environment variables to switch between development and production databases. Provides chainable methods like .select(), .insert(), .update(), .delete(). No ORM overhead; designed for simple SQL operations with parameterized queries. Limited documentation and community adoption. Not recommended for new projects due to lack of maintenance (last release 4+ years ago). Consider using mysql2 with promise wrapper or knex.js instead.","language":"javascript","status":"maintenance","version":"1.4.1","tags":["javascript","mysql","database","helper","node-database"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install nodedb-helper","imports":["const db = require('nodedb-helper')({ user: 'my_db', product: 'my_other_db' });","const db = require('nodedb-helper')({ user: 'my_db' }); const result = await db.user().select({ table: 'users', where: 'id=?', params: [1] });","await db.user().select({ table: 'users', where: 'id=?', params: [1], order: 'name ASC', limit: 10 });","await db.user().query('SELECT * FROM users WHERE id = ?', [1]);"]},{"cmd":"yarn add nodedb-helper","imports":[]},{"cmd":"pnpm add nodedb-helper","imports":[]}],"homepage":"https://github.com/harshkanjariya/nodedb-helper#readme","github":"https://github.com/harshkanjariya/nodedb-helper","docs":null,"changelog":null,"pypi":null,"npm":"nodedb-helper","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}