massive-js

Massive.js is a data mapper for Node.js and PostgreSQL that embraces the full power of PostgreSQL rather than abstracting it away behind a generic SQL interface. Unlike traditional ORMs that model the database in application code, Massive introspects the database at startup and builds a JavaScript API that mirrors the actual database structure — tables become objects with find, insert, update, and destroy methods, views are queryable, and stored functions are callable as JavaScript methods. This database-first approach means the database schema is the source of truth, and Massive adapts to it automatically. The library provides a powerful criteria query system for filtering, full-text search support leveraging PostgreSQL's built-in capabilities, document table support for JSONB columns that function like schemaless document stores within PostgreSQL, and streaming for large result sets. Massive handles bulk operations efficiently and supports CTEs (Common Table Expressions), window functions, and other advanced PostgreSQL features through its criteria system and raw SQL fallback. Massive is ideal for PostgreSQL-centric applications where developers want to leverage PostgreSQL's unique features without an abstraction layer.