Extending your database server's abilities
summary
Argues for moving business logic into the database by packaging operations as functions that reduce client roundtrips and lock contention, showing pgbench results with 2.5x faster on simple workloads and up to 6x faster under contention. Describes PLV8 (V8 JavaScript) running AJV for AJV JSON Schema in PLV8 with ~20k validations in ~0.3s and explains embedding WebAssembly crypto, where a hash microbenchmark reports WASM hash 1M: native 1.4s vs WASM 5s, with warmup and larger inputs narrowing the gap.
AI-written summary · about
chapters (8)
- 0:00Introduction and speaker background
- 3:30Why move logic to the database
- 8:00PostgreSQL extensibility features
- 14:46PLV8 JavaScript engine in PostgreSQL
- 17:20JSON Schema validation with PLV8
- 23:53WebAssembly in PostgreSQL with PLV8
- 29:56Future plans and improvements
- 32:05Q&A session
related talks
20mLeveraging PLV8 in Javascript heavy Web Applications
43mEmbracing the Web with JSON and PLV8
37mCustom data structures in managed Postgres using WASM
26mCompiling Postgres to WASM with PGlite
49m3+ Features Developers Use That Might Never Make It to PostgreSQL
33mSchemaless SQL The Best of Both Worlds
29mPerformance Archaeology - 20 years of improvements
56mLightning Talks