{"library":"jm-ez-mysql","type":"library","category":null,"description":"jm-ez-mysql is a simple MySQL wrapper for Node.js that provides a promise-based API for common database operations (select, insert, update, delete) with built-in query builder, prepared statement support, and raw query execution. Current stable version is 4.0.0. It wraps the popular `mysql` npm package, offering a higher-level abstraction with methods like `findAll`, `insert`, and `update`, plus a query builder for dynamic conditions. Compared to alternatives like `mysql2/promise`, it provides a more concise API inspired by ORM-like patterns, but lacks connection pooling and prepared statement placeholder support. Release cadence is irregular; version 4.0.0 introduced breaking changes (moved from callback/promise mix to full promise). Differentiators: simple API, built-in query logging (`lQ`), and query builder with `where`/`orWhere`.","language":"javascript","status":"active","version":"4.0.0","tags":["javascript","mysql","nodejs","wrapper","helper","node","utility","database"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install jm-ez-mysql","imports":["const My = require('jm-ez-mysql')","My.init({ host: 'localhost', user: 'root', password: '...', database: 'test' })","My.findAll('table', ['col1', 'col2'], 'condition', [params])","My.query('SELECT * FROM users WHERE id = ?', [userId])","const q = My.initQuery(); q.where('id', 1); q.execute('table')"]},{"cmd":"yarn add jm-ez-mysql","imports":[]},{"cmd":"pnpm add jm-ez-mysql","imports":[]}],"homepage":"https://github.com/jay2503/jm-ez-mysql#readme","github":"https://github.com/jay2503/jm-ez-mysql","docs":null,"changelog":null,"pypi":null,"npm":"jm-ez-mysql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}