Sign up to save your podcasts
Or
Share Wait... PostgreSQL can do WHAT?
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
Wait... PostgreSQL can do WHAT?
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
Imported from https://www.youtube.com/watch?v=VEWXmdjzIpQ&feature=youtu.be
View all episodes
By 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
Imported from https://www.youtube.com/watch?v=VEWXmdjzIpQ&feature=youtu.be