Compare

Comparing bookshelf vs. knex vs. objection vs. orm vs. sequelize

How are they different?

Here we compare between bookshelf, knex, objection, orm and sequelize. In this comparison we will focus on the latest versions of those packages. The current versions are bookshelf 0.10.2, knex 0.12.6, objection 0.6.2, orm 3.2.3 and sequelize 3.29.0.

bookshelf, A lightweight ORM for PostgreSQL, MySQL, and SQLite3. It was authored by Tim Griesser on Apr, 2013.
knex, A batteries-included SQL query & schema builder for Postgres, MySQL and SQLite3 and the Browser. It was authored by Tim Griesser on May, 2013.
objection, An SQL-friendly ORM for Node.js. It was authored by Sami Koskimäki on Jun, 2012.
orm, NodeJS Object-relational mapping. It was authored by Diogo Resende on Mar, 2011.
sequelize, Multi dialect ORM for Node.JS/io.js. It was authored by Sascha Depold on May, 2011.

When comparing those packages you notice that sequelize is the more popular package today (8,544 Stars on Github).
knex has a bigger community of maintainers.
objection has less dependencies, less open issues and less open pull requests.
orm has been out there for longer (since 4 years ago), it also sequelize has more versions, more frequent updates, more daily downloads, more weekly downloads, more monthly downloads, more stars on Github, more followers on Github and more forks.

In our review bookshelf got 39,820 points, knex got 124,221 points, objection got 7,651 points, orm got 6,939 points and sequelize got 142,187 points. The points are a summary of how big the community is and how well the package is maintained.

Lets dive deeper and have a look at some more details on those packages.

Going into more detail

 

bookshelf
0.10.2
NPM

knex
0.12.6
NPM

objection
0.6.2
NPM

orm
3.2.3
NPM

sequelize
3.29.0
NPM

description A lightweight ORM for PostgreSQL, MySQL, and SQLite3 A batteries-included SQL query & schema builder for Postgres, MySQL and SQLite3 and the Browser An SQL-friendly ORM for Node.js NodeJS Object-relational mapping Multi dialect ORM for Node.JS/io.js
keywords orm, mysql, postgresql, sqlite, datamapper, active record sql, query, postgresql, mysql, mariadb, sqlite3, oracle, mssql orm, knex, sql, query, postgresql, mysql, sqlite3 orm, odm, database, mysql, postgres, redshift, sqlite, mongodb mysql, sqlite, postgresql, postgres, mssql, orm, nodejs, object relational mapper
author Tim Griesser Tim Griesser Sami Koskimäki Diogo Resende Sascha Depold
Related / similar packages
asynquence, bluebird, co, active_record asynquence, bluebird, co, connect waterline, sql-bricks waterline, sql-bricks waterline, sql-bricks
Comparison
licenses MIT MIT MIT MIT MIT
created 4 years ago (Apr, 2013) 4 years ago (May, 2013) 5 years ago (Jun, 2012) 6 years ago (Mar, 2011) 6 years ago (May, 2011)
modified 17 days ago 10 days ago 18 days ago 11 days ago 10 days ago
total versions 67 112 45 82 184
version average every 20 days every 12 days every a month every a month every 11 days
maintainers 4 8 2 2 4
dependencies 7 17 4 7 16
Daily Downloads 1,291 3,359 154 144 3,376
Weekly Downloads 15,098 52,013 2,264 949 55,944
Monthly Downloads 51,250 179,066 8,048 4,212 199,404
open issues 428 449 36 212 782
open pull requests 30 30 8 19 30
stargazers 3,833 3,912 918 2,237 8,544
subscribers 101 134 36 103 288
forks 331 596 39 336 1,673
wiki
Points
Overall points

39,820

Points

124,221

Points

7,651

Points

6,939

Points

142,187

Points
CLI Shortcuts
install npm i -S bookshelf npm i -S knex npm i -S objection npm i -S orm npm i -S sequelize
remove npm r -S bookshelf npm r -S knex npm r -S objection npm r -S orm npm r -S sequelize

Share this with other developers