A small query tool for Postgres that embraces json and makes life simpler
Homepage Repository npm Download
npm install massive@6.11.0
Massive is a data mapper for Node.js that goes all in on PostgreSQL, and embraces the power and flexibility of SQL itself and of the relational metaphor. With minimal abstractions for the interfaces and tools you already use, its goal is to do just enough to make working with your data and your database as easy and intuitive as possible, then get out of your way.
Massive is not an object-relational mapper (ORM)! It doesn't use models, it doesn't track state, and it doesn't box you into working and thinking in terms of individual entities. Massive connects to your database and introspects its schemas to build an API for the data model you already have: your tables, views, functions, and easily-modified SQL scripts.
Here are some of the highlights:
order
to true upserts with onConflictUpdate
.join()
on any table or view to use Massive's query and even persistence methods over multiple relations at once.db.withTransaction()
to execute a callback with full Massive API support in a transaction scope, getting a promise which fulfills if it commits or rejects if it rolls back.npm i massive --save
Documentation and API docs are at MassiveJS.org.
If you need a callback-based API, install Massive.js v2: npm install massive@2
Documentation for Massive.js 2.x is at readthedocs.