Leveraging PLV8 in Javascript heavy Web Applications
summary
Demonstrates running browser JavaScript inside Postgres via PLV8 runs Google V8 in the database to reuse client code for server-side persistence and validation. Shows a concrete HR salary app that applies the same JS regression and boundary checks in the browser and on the server, then executes those functions in a SELECT over 40 million rows to update results. Explains storing shared modules in a db table, using native JSON support with functional indexes and validations so logic and data remain consistent.
AI-written summary · about
chapters (10)
- 0:00PLV8 in web apps
- 1:51PLV8 for HR salary modeling
- 3:25Client vs server calculations
- 5:14Sharing JS logic
- 7:00PLV8 functions and PostgreSQL
- 8:23Dashboards with JSON support
- 10:13PLV8 benefits
- 13:58PLV8 security
- 15:08PLV8 vs MongoDB
- 19:57Closing remarks
related talks
33mExtending your database server's abilities
33mSchemaless SQL The Best of Both Worlds
49m3+ Features Developers Use That Might Never Make It to PostgreSQL
37mCustom data structures in managed Postgres using WASM
50mJS Inside PostgreSQL
30mPostgreSQL & NodeJs as Core Feature of Backend for Frontend
51mBuilding a Realtime "Backend in a Box" with PostgreSQL and Vue
26mCompiling Postgres to WASM with PGlite