Reading Sessions* - Pick up a book, start a session, and we’ll track everything so you can focus on reading.Everything Tracker - Easily manage book collections, reading status, star ratings, reading dates, and more for all your books.Book Lists - Find your next great read with our NYT Bestseller lists and hand-curated collections.Quick Add - Build your library by searching through millions of books, scanning any book's barcode, or adding your own.Remember what you read by writing and reviewing notes and quotes. Stay motivated with reading goals, streaks, and reminders. Improve your reading habits with insightful stats and trend reports. Here is an example to get you started: const knex = require('knex')().Bookshelf helps you track your books, build a lasting reading habit, and better remember what you read.Īdd books you’ve read, books you’re reading, and books you want to read. elsewhere, to use the bookshelf client: Module.exports = require('bookshelf')(knex) A common pattern to follow is to initialize the client in a module so you can easily reference it later: // In a file named, e.g. You'll need to store this instance created by the initialize somewhere in the application so you can reference it. As it creates a connection pool for the current database, you should use the bookshelf instance returned throughout your library. This initialization should likely only ever happen once in your application. Setting up the database connectionĬonst bookshelf = require('bookshelf')(knex) The Knex documentation provides a number of examples for different databases. The Bookshelf library is initialized by passing an initialized Knex client instance. You'll need to install a copy of Knex, and either mysql, pg, or sqlite3 from npm. It's a lean object-relational mapper, allowing you to drop down to the raw Knex interface whenever you need a custom query that doesn't quite fit with the stock conventions. It doesn't force you to use any specific validation scheme, and provides flexible, efficient relation/nested-relation loading and first-class transaction support.

With a concise, literate codebase, Bookshelf is simple to read, understand, and extend. Introductionīookshelf aims to provide a simple library for common tasks when querying databases in JavaScript, and forming relations between these objects, taking a lot of ideas from the Data Mapper Pattern. The project is hosted on GitHub, and has a comprehensive test suite. It is designed to work with PostgreSQL, MySQL, and SQLite3. It features both Promise-based and traditional callback interfaces, transaction support, eager/nested-eager relation loading, polymorphic associations, and support for one-to-one, one-to-many, and many-to-many relations. Bookshelf is a JavaScript ORM for Node.js, built on the Knex SQL query builder.

Bookshelf app