Compare

Comparing bookshelf vs. objection vs. orm vs. sequelize vs. sql-bricks

How are they different?

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

bookshelf, A lightweight ORM for PostgreSQL, MySQL, and SQLite3. It was authored by Tim Griesser on Apr, 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.
sql-bricks, Transparent, Schemaless SQL Generation. It was authored by Peter Rust on Oct, 2013.

When comparing those packages you notice that sequelize is the more popular package today (8,544 Stars on Github).
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.
sql-bricks has less dependencies, less open issues and less open pull requests.

In our review bookshelf got 39,820 points, objection got 7,651 points, orm got 6,939 points, sequelize got 142,187 points and sql-bricks got 2,457 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

objection
0.6.2
NPM

orm
3.2.3
NPM

sequelize
3.29.0
NPM

sql-bricks
2.0.1
NPM

description A lightweight ORM for PostgreSQL, MySQL, and SQLite3 An SQL-friendly ORM for Node.js NodeJS Object-relational mapping Multi dialect ORM for Node.JS/io.js Transparent, Schemaless SQL Generation
keywords orm, mysql, postgresql, sqlite, datamapper, active record 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 sql, generation, generate, query, pg, postgres, sqlite, builder, select, insert, update, delete
author Tim Griesser Sami Koskimäki Diogo Resende Sascha Depold Peter Rust
Related / similar packages
asynquence, bluebird, co, knex, active_record waterline waterline waterline knex
Comparison
licenses MIT MIT MIT MIT MIT
created 4 years ago (Apr, 2013) 5 years ago (Jun, 2012) 6 years ago (Mar, 2011) 6 years ago (May, 2011) 3 years ago (Oct, 2013)
modified 17 days ago 18 days ago 11 days ago 10 days ago 3 months ago
total versions 67 45 82 184 51
version average every 20 days every a month every a month every 11 days every 23 days
maintainers 4 2 2 4 1
dependencies 7 4 7 16 1
Daily Downloads 1,291 154 144 3,376 12
Weekly Downloads 15,098 2,264 949 55,944 497
Monthly Downloads 51,250 8,048 4,212 199,404 1,527
open issues 428 36 212 782 9
open pull requests 30 8 19 30 0
stargazers 3,833 918 2,237 8,544 59
subscribers 101 36 103 288 17
forks 331 39 336 1,673 8
wiki
Points
Overall points

39,820

Points

7,651

Points

6,939

Points

142,187

Points

2,457

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

Share this with other developers