From Postgres to a Minimalist Lakehouse: The Next Step with DuckLake - Mehdi Ouazza - MotherDuck

Описание: 🔥 How do you move from Postgres OLTP to a minimalist lakehouse with DuckDB and DuckLake?
🔥 Why design for the 90 percent of queries (≤1 GB scans) to avoid the big data tax?
🔥 How do you get under 1s on 4 GB with DuckDB and under 1 min on 255 GB with MotherDuck?

Mehdi Ouazza, Developer Advocate at MotherDuck.
A minimalist lakehouse: Postgres to DuckDB to DuckLake and MotherDuck on S3, built with a laptop and CLI. Design for the 90 percent (≤1 GB), run under 1s on 4 GB locally and under 1 min on 255 GB in MotherDuck.

🤔 Did you know he stood up an end-to-end lakehouse with just a laptop and S3 in under 20 minutes?

____________________________
🤘🤘🤘FWD designed, built and organized with 🧡 by ‪‪‪‪‪@hymaia‬ (https://www.hymaia.com )
— with ‪‪‪‪‪@blef_‬ & ‪@moderndatanetwork4589‬



🌐🌐🌐 MORE DATA CONTENT on our channels:
➜ LinkedIn :   / 104059598  
➜ Twitter : https://x.com/ForwardDataconf
➜ Instagram :   / forwarddataconf  
➜ TikTok :   / hymaiafr  
💻 Our website : https://www.forward-data-conference.com/


🔥🔥🔥 Our 2025 Sponsors:
Omni, Sifflet, Mirakl, Tangram-os.ai, starlake, synq, clickhouse, Nao, DataBricks


🎬CHAPTERS

00:00:00 Introduction
00:00:17 Why a minimalist lakehouse
00:01:22 From Hadoop pain to OLTP to analytics
00:03:41 Toolkit: laptop plus S3 plus DuckDB
00:10:49 Postgres vs DuckDB: 12s vs under 1s on 4 GB
00:13:56 DuckLake architecture and demo
00:19:10 MotherDuck in the cloud and key takeaways


© 2025 Hymaïa - Cabinet de conseil et Formation Product, Data & IA

TITLES AND HASHTAGS ===

1. From Postgres to a Minimalist Lakehouse with DuckDB & DuckLake Hashtags : #DuckDB #DuckLake #Postgres #Lakehouse #DataEngineering
2. DuckDB on S3: Build Analytics from a Laptop in Minutes Hashtags : #MotherDuck #S3 #AnalyticsEngineering #ModernDataStack #SQL
3. Design for the 90%: Faster Analytics with DuckDB and DuckLake Hashtags : #DuckDB #DuckLake #Performance #DataPlatform #GitHubActions