Database as API with PostgreSQL and Massive.js
summary
Massive.js presents a Postgres-exclusive data mapper for Node that maps tables, views and functions directly into an API, avoiding maintained models and enabling features like transactions (added in v5), streaming results, a document API over JSON columns, and writable common table expression based deep inserts that persist parent and junction rows in one statement. It powers at least two enterprise apps, supports prototype-based name resolution, and includes deep insert and query options (limit, order, expose) that actually work.
AI-written summary · about
chapters (36)
- 0:00Introduction
- 1:12JavaScript
- 2:13Database exclusivity
- 3:43ANSI Standard
- 5:44PostgreSQL
- 7:25ORM
- 8:01Problems
- 8:47The Villa Savoye
- 11:22Objectrelational impedance mismatch
- 12:18Writing sequel
- 13:33Abstraction
- 15:34Flexibility
- 16:28Classical irony
- 17:29Objectoriented languages
- 18:23Dynamic languages
- 19:27Massivejs
- 20:32Database as API
- 22:22Select Statements
- 25:37Directory Permissions
- 26:40Database Transactions
- 28:18Information Schema
- 29:16Views
- 31:21File System
- 32:14Multiple Sources
- 33:58Models
- 36:18Object graphs
- 36:58Schema
- 37:58List of movements
- 39:40Persistence
- 40:12Insert
- 43:22Primary Key
- 44:31Document API
- 45:19A cautionary tale
- 46:31Choosing a tool
- 47:27Focus on APIs
- 48:17Working with databases
related talks
30mPostgreSQL & NodeJs as Core Feature of Backend for Frontend
54mA conservative Backend on Node.js
01h 12mWorkshop: Postgres for Frontend Developers (Part 1)
01h 14mWorkshop: Postgres for Frontend Developers (Part 2)
01h 03mModern Web APIs with Node.js & TypeScript
40mDeploying node.js at scale
41mRapid and type-safe Node.js development with Prisma
01h 31mBuilding a Node.js API with Prisma in minutes, using Amplication