MotherDuck
MotherDuck
  • 69
  • 290 403
Why web developers should care about analytical databases
You often start your web application with an OLTP database like Postgres, but should you crunch your analytics there? In this video, @mehdio explains what OLAP databases are, when to use them, and how to leverage the native integration of MotherDuck directly in a Vercel dashboard-type application.
☁️🦆 Start using DuckDB in the Cloud for FREE with MotherDuck : hubs.la/Q02QnFR40
📓 Resources
Vercel MotherDuck integration : vercel.com/marketplace/motherduck
Vercel MotherDuck template : vercel.com/templates/next.js/next-js-motherduck-wasm-analytics-quickstart
Read-scaling token docs : motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/read-scaling/
Getting started with DuckDB : vercel.com/marketplace/motherduck
About MotherDuck : th-cam.com/video/BINA_ytZXMY/w-d-xo.htmlsi=k5imHtdSigGmv0l3
➡️ Follow Us
LinkedIn: linkedin.com/company/motherduck
X/Twitter : motherduck
Blog: motherduck.com/blog/
00:00 Intro
00:58 What are analytical DBs (OLAP)
01:51 When to use them
03:34 How to move data from OLTP to OLAP
05:45 Using an OLAP (MotherDuck) directly in Vercel
08:22 Outro
#webdevelopment #analytics #vercel #duckdb
มุมมอง: 1 649

วีดีโอ

What if you put an LLM inside SQL ?
มุมมอง 869หลายเดือนก่อน
Join us for another engaging session with Mehdi and Till as we explore the AI features built into Motherduck and the open-source initiatives we've been working on. No fluff-just a showcase of what's live in production, how we're simplifying SQL workflows, and a discussion about our future plans. ☁️🦆 Start using DuckDB in the Cloud for FREE with MotherDuck : hubs.la/Q02QnFR40 00:00 About Till - ...
Think Inside the Box: Constraints Drive Data Warehousing Innovation
มุมมอง 976หลายเดือนก่อน
As a Head of Data or a one-person data team, keeping the lights on for the business while running all things data-related as efficiently as possible is no small feat. This talk will focus on tactics and strategies to manage within and around constraints, including monetary costs, time and resources, and data volumes. 📓 Resources Big Data is Dead: motherduck.com/blog/big-data-... Small Data Mani...
Can DuckDB revolutionize the data lake experience?
มุมมอง 3.9Kหลายเดือนก่อน
In this video @mehdio explores DuckDB as a catalog for Data Lake and Lakehouse pattern. He'll define what we mean by "data catalog", gives clear examples on how they work and dive into a pragmatic use case with DuckDB & MotherDuck. Enjoy! ☁️🦆 Start using DuckDB in the Cloud for FREE with MotherDuck : hubs.la/Q02QnFR40 📓 Resources Github Gist for the ducky_catalog.ddb : gist.github.com/mehd-io/f...
Is BI Too Big for Small Data?
มุมมอง 1.3Kหลายเดือนก่อน
This is a talk about how we thought we had Big Data, and we built everything planning for Big Data, but then it turns out we didn't have Big Data, and while that's nice and fun and seems more chill, it's actually ruining everything, and I am here asking you to please help us figure out what we are supposed to do now. 📓 Resources Big Data is Dead: motherduck.com/blog/big-data-... Small Data Mani...
Big Data is Dead: Long Live Hot Data 🔥
มุมมอง 1.7Kหลายเดือนก่อน
Over the last decade, Big Data was everywhere. Let's set the record straight on what is and isn't Big Data. We have been consumed by a conversation about data volumes when we should focus more on the immediate task at hand: Simplifying our work. Some of us may have Big Data, but our quest to derive insights from it is measured in small slices of work that fit on your laptop or in your hand. Eas...
pg_duckdb: Postgres analytics just got faster with DuckDB
มุมมอง 7K2 หลายเดือนก่อน
Postgres analytics 10x faster with just an extension?! 🤯 In August, we announced pg_duckdb, a PostgreSQL extension that integrates DuckDB's analytics engine directly into Postgres. It's open-source and represents a joint partnership between Hydra and MotherDuck. Two months later, we are happy to announce its first release and highlight many features, including the ability to read and write over...
Duckfooding at MotherDuck
มุมมอง 1.8K2 หลายเดือนก่อน
In this talk at our MotherDuck NYC meetup, Nicholas Ursa talked about the paradigm shift from distributed computing and the Big data era to MotherDuck. He then explains how we do dogfood internally, building our internal data warehouse using MotherDuck ☁️🦆 Start using DuckDB in the Cloud for FREE with MotherDuck : hubs.la/Q02QnFR40 Check out our next events at motherduck.com/events/ ➡️ Follow U...
The Journey of DuckDB Spatial Extension
มุมมอง 1K3 หลายเดือนก่อน
In this Quack&Code, we have Max Gabrielsson from @duckdb one of the main contributors to the DuckDB spatial extension. We talked about how this extension came to life, what's cooking for next, plus a hands-on demo. PS: we are aware that we had some small sound issues in the first part of the talk, apologies for this! :) ☁️🦆 Start using DuckDB in the Cloud for FREE with MotherDuck : hubs.la/Q02Q...
Is DuckDB the Secret to Unlocking Your GIS Potential?
มุมมอง 3.5K3 หลายเดือนก่อน
In this video, @mehdio walks you through the absolute basics of working with geospatial data and introduces the DuckDB spatial extension. By the end of the video, you will create your own heatmap using DuckDB, Python, and MotherDuck for sharing and cloud scalability. ☁️🦆 Start using DuckDB in the Cloud for FREE with MotherDuck : hubs.la/Q02QnFR40 📓 Resources Collab code : colab.research.google....
DuckDB & dataviz | End-To-End Data Engineering Project (3/3)
มุมมอง 4.3K5 หลายเดือนก่อน
DuckDB & dataviz | End-To-End Data Engineering Project (3/3)
MotherDuck GA Produck Tour
มุมมอง 1.1K6 หลายเดือนก่อน
MotherDuck GA Produck Tour
Why and How we integrated DuckDB & MotherDuck with GoodData
มุมมอง 1.7K6 หลายเดือนก่อน
Why and How we integrated DuckDB & MotherDuck with GoodData
Ibis: One Library To Query Any Backend
มุมมอง 2.6K7 หลายเดือนก่อน
Ibis: One Library To Query Any Backend
Why CSVs Still Matter: The Indispensable File Format
มุมมอง 8107 หลายเดือนก่อน
Why CSVs Still Matter: The Indispensable File Format
Building Data Apps with MotherDuck
มุมมอง 1.9K8 หลายเดือนก่อน
Building Data Apps with MotherDuck
Local Dev, Cloud Prod with Dagster and MotherDuck
มุมมอง 1.5K8 หลายเดือนก่อน
Local Dev, Cloud Prod with Dagster and MotherDuck
DuckDB & dbt | End-To-End Data Engineering Project (2/3)
มุมมอง 11K9 หลายเดือนก่อน
DuckDB & dbt | End-To-End Data Engineering Project (2/3)
DuckDB and recommenders : a lightning fast synergy ft. Khalil Muhammad
มุมมอง 2.8K10 หลายเดือนก่อน
DuckDB and recommenders : a lightning fast synergy ft. Khalil Muhammad
Why should you care about DuckDB? ft. Mihai Bojin
มุมมอง 12K10 หลายเดือนก่อน
Why should you care about DuckDB? ft. Mihai Bojin
DuckDB & Python | End-To-End Data Engineering Project (1/3)
มุมมอง 21K10 หลายเดือนก่อน
DuckDB & Python | End-To-End Data Engineering Project (1/3)
Exploring Monte Carlo Simulations With DuckDB ft. James McNeill
มุมมอง 3.9K11 หลายเดือนก่อน
Exploring Monte Carlo Simulations With DuckDB ft. James McNeill
Friendly SQL with DuckDB
มุมมอง 3K11 หลายเดือนก่อน
Friendly SQL with DuckDB
The future of BI: Exploring the impact of BI-as-code tools with DuckDB
มุมมอง 7Kปีที่แล้ว
The future of BI: Exploring the impact of BI-as-code tools with DuckDB
DuckDB Experiments: Peeking into the Future of Analytics ft. Christophe Blefari
มุมมอง 4.7Kปีที่แล้ว
DuckDB Experiments: Peeking into the Future of Analytics ft. Christophe Blefari
Speed-Querying StackOverflow data with DuckDB ft. Michael Hunger
มุมมอง 3.2Kปีที่แล้ว
Speed-Querying StackOverflow data with DuckDB ft. Michael Hunger
Making PySpark code faster with DuckDB
มุมมอง 4.2Kปีที่แล้ว
Making PySpark code faster with DuckDB
Why did we raise now ? CEO Backstage Call 📞
มุมมอง 742ปีที่แล้ว
Why did we raise now ? CEO Backstage Call 📞
MotherDuck in 100 seconds (by a duck 🦆)
มุมมอง 7Kปีที่แล้ว
MotherDuck in 100 seconds (by a duck 🦆)
Unleashing the Power of DuckDB for Interactive SQL Notebooks
มุมมอง 4.7Kปีที่แล้ว
Unleashing the Power of DuckDB for Interactive SQL Notebooks