Is it even a database anymore?.. I'll show you how PostgreSQL ALONE can replace ALL your backend stack components.

0:00 is it even a database anymore?
1:15 the quickest history of PostgreSQL
2:34 objectrelational database
4:38 table inheritance
6:03 pg_trunk: a package manager for PostgreSQL extensions
7:31 stored procedure that uses python's pandas
7:55 your database is not a DUMB store
8:38 PostgreSQL's FEATURE OF FEATURES
9:04 pg_cron & hstore: replacing redis cache
10:53 NOTIFY/LISTEN: replacing redis pub/sub
11:51 pgmq: replacing message queue like SQS
13:10 JSONB: replacing MongoDB
13:29 NoSQL vendors mimic SQL
14:26 Apache AGE & TimescaleDB: replacing graph and time series databases
15:09 FTS: replacing ElasticSearch
16:20 pgml: LLM and chatbots running in PostgreSQL
16:39 Postgrest: nocode REST API for your DB tables
18:06 pgtap: unittesting for PostgreSQL
18:42 pg_graphql: nocode GraphQL API for your DB tables
19:06 Omnigres: PostgreSQL as a platform
19:25 "boring technology" and "radical simplicity" with PostgreSQL
20:03 trying to play pg_doom (Doom in PostgreSQL)

Code & links from the episode: https://github.com/vivusignis/thear...