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.13.3, knex 0.15.1, objection 1.1.10, orm 5.0.2 and sequelize 4.38.0.

bookshelf, A lightweight ORM for PostgreSQL, MySQL, and SQLite3. It was authored by Bookshelf 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. It was authored by Sascha Depold on May, 2011.

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

In our review bookshelf got 63,122 points, knex got 410,678 points, objection got 38,578 points, orm got 9,461 points and sequelize got 600,710 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.13.3
NPM

knex
0.15.1
NPM

objection
1.1.10
NPM

orm
5.0.2
NPM

sequelize
4.38.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
keywords orm, mysql, postgresql, sqlite, datamapper, active record sql, query, postgresql, mysql, sqlite3, oracle, mssql orm, knex, sql, query, query builder, postgresql, mysql, sqlite3 orm, odm, database, mysql, postgres, redshift, sqlite, mongodb mysql, sqlite, postgresql, postgres, mssql, orm, nodejs, object relational mapper
author Bookshelf Tim Griesser Sami Koskimäki Diogo Resende Sascha Depold
Related / similar packages
sql-bricks massive sql-bricks sql-bricks sql-bricks
Comparison
licenses MIT MIT MIT MIT MIT
created 5 years ago (Apr, 2013) 5 years ago (May, 2013) 6 years ago (Jun, 2012) 7 years ago (Mar, 2011) 7 years ago (May, 2011)
modified 4 months ago 4 days ago 2 months ago 19 days ago 22 days ago
total versions 76 125 102 89 368
version average every 25 days every 15 days every 22 days every a month every 7 days
maintainers 7 8 2 2 7
dependencies 7 16 3 8 17
Daily Downloads 1,252 9,373 633 113 9,202
Weekly Downloads 22,973 159,687 12,988 1,678 195,306
Monthly Downloads 86,704 630,383 53,852 7,099 953,693
open issues 211 363 33 234 340
open pull requests 4 28 1 20 25
stargazers 5,025 7,346 2,871 2,871 15,105
subscribers 107 200 68 115 419
forks 445 985 192 385 2,545
wiki
Points
Overall points

63,122

Points

410,678

Points

38,578

Points

9,461

Points

600,710

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

store