{"library":"mysql-model-orm","type":"library","category":null,"description":"mysql-model-orm is a lightweight Node.js ORM for MySQL that wraps common CRUD operations with a chainable API. Current stable version: 2.1.4. It uses connection pooling, returns Promises, and requires Node >= 7.6. Key differentiators: minimal configuration, simple chaining (table().where().select()), automatic SQL injection protection via the mysql driver's escape methods, and support for complex queries like JOINs, aggregates, transactions, and raw SQL.","language":"javascript","status":"active","version":"2.1.4","tags":["javascript","mysql-model-orm","mysql","orm","model","node"],"last_verified":"Thu Jun 04","install":[{"cmd":"npm install mysql-model-orm","imports":["const mysqlModelOrm = require('mysql-model-orm');\nconst Model = new mysqlModelOrm({...});","const Model = require('mysql-model-orm');\nconst db = new Model({ host: 'localhost', ... });","const result = await db.table('users').where({id: 1}).findOne();"]},{"cmd":"yarn add mysql-model-orm","imports":[]},{"cmd":"pnpm add mysql-model-orm","imports":[]}],"homepage":"https://github.com/1119879311/npm_module/tree/master/mysql-model-orm","github":"https://github.com/1119879311/npm_module/tree/master/mysql-model-orm","docs":null,"changelog":null,"pypi":null,"npm":"mysql-model-orm","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}