Why web developers should care about analytical databases
2024/12/11You often start your web application with an OLTP database like Postgres, but should you crunch your analytics there? In this video, Mehdi explains what OLAP databases are, when to use them, and more.
Related Videos
33:49
2024-11-08
A duck in the hand is worth two in the cloud
What if I told you that you could complete a JSON parse and extract task on your laptop before a distributed compute cluster even finishes booting up?
YouTube
BI & Visualization
AI, ML and LLMs
SQL
Python
Talk
14:18
2024-10-25
pg_duckdb: Postgres analytics just got faster with DuckDB
Postgres analytics 10x faster?! 🤯 pg_duckdb is here! This open-source extension adds DuckDB's analytics to Postgres, supporting Parquet, CSV, Iceberg reads, and direct MotherDuck queries—all within Postgres!
YouTube
Ingestion
SQL
Ecosystem
1:03:13
2024-06-13
Fixing SQL Spaghetti : Effective Refactoring Techniques
Lindsay Murphy and Mehdi tackle a big challenge for data professionals: dealing with old SQL scripts. How can we make messy SQL code easier to read and maintain? We'll discuss pragmatics things you can do, and we'll tackle an example.
YouTube
Quack & Code
SQL