Workshop: Postgres for Frontend Developers (Part 1)
summary
Introduction to PostgreSQL for frontend developers: explains what DBMS and relational databases are, how to install and run Postgres, and basic tools to work with data. Shows how to use Postgres from Node.js (covers relevant npm packages and ORMs), database concepts (schemas, tables, indexes, referential integrity, stored procedures, JSON), and best practices for using SQL from an application. Builds a small Postgres-backed app with an external Node.js API and points to resources for further learning.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 3:14Career and PostgreSQL
- 6:25What is a database
- 14:56PostgreSQL features
- 23:11PostgreSQL job market
- 27:07Unstructured data handling
- 37:33Storing JSON in PostgreSQL
- 58:04JSON usage examples
- 1:05:37JSON common mistakes
- 1:10:45Summary
related talks
30mPostgreSQL & NodeJs as Core Feature of Backend for Frontend
41mApplication Development Challenges with Postgres
45mBuilding Scalable APIs: PostgreSQL Meets GraphQL
51mBuilding a Realtime "Backend in a Box" with PostgreSQL and Vue
20mCrossing The Streams: Adding PostgreSQL to Your SQL Server Skillset
50mJS Inside PostgreSQL
21mDiscovering Postgres...
25mBig Bad World of Postgres Dev Environments