Bookshelf.js vs Objection.js

Overview

Bookshelf.js

Stacks6

Followers21

Votes3

Objection.js

Stacks39

Followers67

Votes0

GitHub Stars7.3K

Forks641

Objection.js vs Bookshelf.js: What are the differences?

What is Objection.js? It is an ORM for Node.js. It aims to stay out of your way and make it as easy as possible to use the full power of SQL and the underlying database engine while still making the common stuff easy and enjoyable.

What is Bookshelf.js? Aims to provide a simple library for common tasks when querying databases in JavaScript. It stems from the Knex.js, which is a flexible query builder that works with PostgreSQL, MySQL and SQLite3. Bookshelf.js builds on top of this by providing functionality for creating data models, forming relations between these models, and other common tasks needed when querying a database.

Objection.js and Bookshelf.js can be categorized as "Object Relational Mapper (ORM)" tools.

Some of the features offered by Objection.js are:

A declarative way of defining models and relationships between them
Simple and fun way to fetch, insert, update and delete objects using the full power of SQL
Powerful mechanisms for eager loading, inserting and upserting object graphs

On the other hand, Bookshelf.js provides the following key features:

Table creation
Manipulation
Promise-based and traditional callback interfaces

Objection.js is an open source tool with 4.33K GitHub stars and 349 GitHub forks. Here's a link to Objection.js's open source repository on GitHub.

🔥 Trending in Databases on StackShare

pgvector Databases

Open-source vector similarity search for Postgres

Try it View Docs Alternatives

Try

189

7

Detailed Comparison

Bookshelf.js	Objection.js
It stems from the Knex.js, which is a flexible query builder that works with PostgreSQL, MySQL and SQLite3. Bookshelf.js builds on top of this by providing functionality for creating data models, forming relations between these models, and other common tasks needed when querying a database.	It aims to stay out of your way and make it as easy as possible to use the full power of SQL and the underlying database engine while still making the common stuff easy and enjoyable.
Table creation; Manipulation; Promise-based and traditional callback interfaces; Transaction	A declarative way of defining models and relationships between them; Simple and fun way to fetch, insert, update and delete objects using the full power of SQL; Powerful mechanisms for eager loading, inserting and upserting object graphs; A way to store complex documents as single rows Completely Promise based API; Easy to use transactions; Optional JSON schema validation
Statistics
GitHub Stars -	GitHub Stars 7.3K
GitHub Forks -	GitHub Forks 641
Stacks 6	Stacks 39
Followers 21	Followers 67
Votes 3	Votes 0
Pros & Cons
Pros 3 Uses both promises and callback methods	No community feedback yet
Integrations
JavaScript MySQL Node.js Knex.js MongoDB SQLite	MySQL Node.js PostgreSQL SQLite

What are some alternatives to Bookshelf.js, Objection.js?

Sequelize

Sequelize is a promise-based ORM for Node.js and io.js. It supports the dialects PostgreSQL, MySQL, MariaDB, SQLite and MSSQL and features solid transaction support, relations, read replication and more.

Prisma

Prisma is an open-source database toolkit. It replaces traditional ORMs and makes database access easy with an auto-generated query builder for TypeScript & Node.js.

Hibernate

Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper.

Doctrine 2

Doctrine 2 sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL.

MikroORM

TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.

Entity Framework

It is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write.

peewee

A small, expressive orm, written in python (2.6+, 3.2+), with built-in support for sqlite, mysql and postgresql and special extensions like hstore.

MyBatis

It is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings. It eliminates almost all of the JDBC code and manual setting of parameters and retrieval of results. It can use simple XML or Annotations for configuration and map primitives, Map interfaces and Java POJOs (Plain Old Java Objects) to database records.

Entity Framework Core

It is a lightweight, extensible, open source and cross-platform version of the popular Entity Framework data access technology. It can serve as an object-relational mapper (O/RM), enabling .NET developers to work with a database using .NET objects, and eliminating the need for most of the data-access code they usually need to write.