Database as API with PostgreSQL and Massive.js

Explore the intersection of Node.js and PostgreSQL in this 49-minute conference talk. Dive into the world of data access in dynamic languages on single-threaded platforms, questioning traditional object-oriented architectures in the context of JavaScript's functional toolkit. Examine the theoretical and practical aspects of Massive.js, a PostgreSQL-exclusive data mapper for Node, and learn how to leverage PostgreSQL's full potential in Node applications. Discover innovative approaches to data management that move beyond conventional object-oriented and object-relational methods, offering insights into more efficient and flexible database integration strategies for modern web development.

Introduction
Overview
JavaScript
Database exclusivity
ANSI Standard
PostgreSQL
ORM
Problems
The Villa Savoye
Objectrelational impedance mismatch
Writing sequel
Abstraction
Flexibility
Classical irony
Objectoriented languages
Dynamic languages
Massivejs
Database as API
Select Statements
Directory Permissions
Database Transactions
Information Schema
Views
File System
Multiple Sources
Models
Object graphs
Schema
List of movements
Persistence
Insert
Primary Key
Document API
A cautionary tale
Choosing a tool
Focus on APIs
Working with databases