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 : https://hubs.la/Q02QnFR40
📓 Resources
Vercel MotherDuck integration : https://vercel.com/marketplace/motherduck
Vercel MotherDuck template : https://vercel.com/templates/next.js/next-js-motherduck-wasm-analytics-quickstart
Read-scaling token docs : https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/read-scaling/
Getting started with DuckDB : https://vercel.com/marketplace/motherduck
About MotherDuck : https://youtu.be/BINA_ytZXMY?si=k5imHtdSigGmv0l3
➡️ Follow Us
LinkedIn: https://linkedin.com/company/motherduck
X/Twitter : https://twitter.com/motherduck
Blog: https://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