{"library":"bookshelf","type":"library","category":null,"description":"Bookshelf is a Node.js ORM built on Knex query builder, supporting PostgreSQL, MySQL, and SQLite3. Version 1.2.0 (latest stable) is actively maintained with a test suite on Travis CI. It provides promise-based and callback interfaces, eager/nested-eager loading, transactions, and polymorphic associations. Unlike full-featured ORMs like Sequelize, Bookshelf is lean, data-mapper oriented, and encourages dropping to raw Knex for custom queries. Release cadence is irregular, with security fixes prioritized. Requires peer dependency knex >=0.15.0 <0.22.0 and a database driver (pg, mysql, sqlite3).","language":"javascript","status":"active","version":"1.2.0","tags":["javascript","orm","mysql","postgresql","sqlite","datamapper","active record"],"last_verified":"Thu Jun 04","install":[{"cmd":"npm install bookshelf","imports":["const bookshelf = require('bookshelf')(knex)","const User = bookshelf.model('User', { tableName: 'users' })","const user = await new User({ id: 1 }).fetch()"]},{"cmd":"yarn add bookshelf","imports":[]},{"cmd":"pnpm add bookshelf","imports":[]}],"homepage":"https://bookshelfjs.org","github":"https://github.com/bookshelf/bookshelf","docs":null,"changelog":null,"pypi":null,"npm":"bookshelf","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}