Workshop: Postgres for Frontend Developers (Part 2)
summary
Introduction to relational databases and PostgreSQL: what an RDBMS is and why use one. Shows how to install and run Postgres, basic tools, database concepts (schemas, tables, indexes, foreign keys, stored procedures, JSON) and how to access Postgres from Node.js using NPM packages and ORMs. Builds a small Postgres-backed Node.js application and gives guidance for further learning.
AI-written summary · about
chapters (35)
- 0:00JSON in PostgreSQL
- 1:30JSON typing and polymorphism
- 3:38Structured data in JSON
- 5:03Query plans in JSON
- 7:11Aggregating with JSON functions
- 8:34Complex aggregates for web
- 11:07Recursive queries for JSON trees
- 14:33Tree path aggregation
- 16:38Optimizing big data queries
- 19:10Merging data in one query
- 20:54Building JSON trees from tables
- 22:42Recursive tree queries
- 24:55Custom tree aggregates
- 28:35JSON histograms
- 31:35Future of JSON in PostgreSQL
- 33:43PL/v8 for JSON and DBs
- 37:24Installing PL/v8
- 39:14PL/v8 security limits
- 41:48PL/v8 features and benefits
- 43:16PL/v8 basics
- 44:46SQL injection in PL/v8
- 45:51PL/v8 transactions and perf
- 47:17PL/v8 vs other languages
- 50:12PL/v8 big numbers and memory
- 51:59PL/v8 parameters and dates
- 53:26PL/v8 function access
- 54:07PL/v8 init and context
- 55:14PL/v8 procedures and functions
- 57:05PL/v8 aggregate functions
- 58:33When to use PL/v8
- 1:00:01PostgreSQL with Node.js
- 1:03:14Connection pooling
- 1:05:23Three-tier apps with JSON
- 1:07:12PostgreSQL and web services
- 1:08:14PostgreSQL and JSON resources
related talks
30mPostgreSQL & NodeJs as Core Feature of Backend for Frontend
41mApplication Development Challenges with Postgres
45mBuilding Scalable APIs: PostgreSQL Meets GraphQL
29mPostgres Demystified
40mFundamentals of relational databases
50mJS Inside PostgreSQL
20mCrossing The Streams: Adding PostgreSQL to Your SQL Server Skillset
54mA conservative Backend on Node.js