Posted by admin

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 - object-relational 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: no-code REST API for your DB tables 18:06 - pgtap: unit-testing for PostgreSQL 18:42 - pg_graphql: no-code 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/vivus-ignis/the-art-of-the-terminal/tree/master/postgresql-is-not-a-database