{"library":"ruoyi-eggjs-sqlite","type":"library","category":null,"description":"An Egg.js plugin for SQLite database operations, built on top of better-sqlite3. Version 1.1.9 supports Egg.js 2.x and 3.x, with multi-instance configuration, optional snake_case-to-camelCase field conversion (since v1.1.6), built-in transaction support with automatic rollback, SQL execution time logging in development, and error messages including the executed SQL. It provides a simple API: select, selects, insert, update, del, run. The plugin uses synchronous better-sqlite3 API wrapped in promises for Egg.js async context. Key differentiators include automatic camelCase conversion (opt-in) and multi-database support via clients config.","language":"javascript","status":"active","version":"1.1.9","tags":["javascript","egg","eggPlugin","egg-plugin","sqlite","sqlite3"],"last_verified":"Sun Jun 07","install":[{"cmd":"npm install ruoyi-eggjs-sqlite","imports":["// In config/plugin.js: exports.sqlite = { enable: true, package: 'ruoyi-eggjs-sqlite' };\n// In controller/service: const { app } = this; app.sqlite.select(...)","const { app } = this; await app.sqlite.select('SELECT 1');","const db1 = app.sqlite.get('db1'); await db1.select('SELECT * FROM users');"]},{"cmd":"yarn add ruoyi-eggjs-sqlite","imports":[]},{"cmd":"pnpm add ruoyi-eggjs-sqlite","imports":[]}],"homepage":"https://github.com/undsky/ruoyi-eggjs-sqlite#readme","github":"https://github.com/undsky/ruoyi-eggjs-sqlite","docs":null,"changelog":null,"pypi":null,"npm":"ruoyi-eggjs-sqlite","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}