Middleware is Dead!
summary
Claim: an HTTP server runs inside PostgreSQL so clients call stored procedures by POSTing JSON directly. Prototype embeds microhttpd as an extension and is written in C++ as a 400-line C++ prototype started as a background worker, logs, and maps URL to SPI calls. It uses the Postgres JSON type and SPI to pass complex objects and handles auth/session lookups in the database. Limitations include SPI being synchronous (standalone async proxy solves that), no benchmarks yet, and a live-demo restart glitch.
AI-written summary · about
chapters (16)
- 0:00Introduction
- 2:52Music Industry
- 4:28Benefits of Disintermediation
- 5:25Web Application Architecture
- 7:58Data Manipulation
- 9:48The Next Revolution
- 11:02Web Applications
- 12:47Store Procedures
- 18:32Testing JSON
- 26:07HTTP Response Handling
- 26:57JSONRPC
- 28:32Questions
- 30:20Postgres
- 32:30HTTP
- 35:22User Management
- 37:37Request Handling
related talks
54mPure Functional Database Programming‚ without JDBC
26mCompiling Postgres to WASM with PGlite
45mBuilding an Open Source MongoDB-compatible Database on Top of PostgreSQL
43mEmbracing the Web with JSON and PLV8
30mPostgreSQL & NodeJs as Core Feature of Backend for Frontend
50mThe Immortal Postgres Web
31mUsing Databases to pull your applications weight
30mBuilding modern Python web apps with PostgreSQL