JS Inside PostgreSQL
summary
Overview of running JavaScript inside PostgreSQL: what capabilities JavaScript executed within the database provides. Covers the integration of JS with PostgreSQL and the functionalities available when executing JS code in the database environment.
AI-written summary · about
chapters (29)
- 0:00Welcome
- 1:04Slides and PostgreSQL intro
- 2:08PostgreSQL as data OS
- 3:55JSON data types
- 5:41JSON and binary JSON
- 6:48Replacing MongoDB with pgcrypto
- 8:16Performance and indexing
- 10:23Query plans and optimization
- 11:50JSON search with jsquery
- 13:13PostgreSQL extensions and JavaScript
- 15:18PLV8 features
- 17:44JavaScript in projects
- 19:51PLV8 test framework
- 21:36Testing PLV8 code
- 23:27PLV8 modules and dependencies
- 24:54Updating PLV8 functions
- 27:27PostgreSQL+JS service example
- 29:00Backend without external server
- 31:47Wrapping PostgreSQL in REST
- 32:51Security and RLS
- 33:36Service demo
- 35:30Q&A
- 37:39PLV8 internals and optimizations
- 41:11V8 alternatives and Java integration
- 43:17PLV8 memory and performance
- 45:25PLV8 errors and issues
- 46:30PLV8 future and optimization
- 47:19Business vs data logic
- 48:22PostgreSQL as monolith
related talks
30mPostgreSQL & NodeJs as Core Feature of Backend for Frontend
20mLeveraging PLV8 in Javascript heavy Web Applications
49m3+ Features Developers Use That Might Never Make It to PostgreSQL
46mUse PostgreSQL to Step Up Your Game
52mPostgreSQL and Java: Best Practices
48mTricky SQL: Special Features of PostgreSQL's SQL Dialect
01h 12mWorkshop: Postgres for Frontend Developers (Part 1)
29mPostgres Demystified