<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/sources/motherduck/best-of/2024" -->

---
title: Best MotherDuck posts of 2024 | daily.dev
description: The most upvoted MotherDuck posts of 2024, curated by the daily.dev community.
canonical: https://daily.dev/sources/motherduck/best-of/2024
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:url: https://daily.dev/sources/motherduck/best-of/2024
og:type: website
og:site_name: daily.dev
og:title: Best MotherDuck posts of 2024 | daily.dev
og:description: The most upvoted MotherDuck posts of 2024, curated by the daily.dev community.
og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph
---

# Best of MotherDuck — 2024

1. 1  
[](/posts/why-you-should-learn-sql-in-2024-viq3bryyc "Why you should learn SQL in 2024")  
[![motherduck's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/f084d6835eef4c2b83f889f9a4e85ed6)](/sources/[source]/best-of/[year])  
4m read time • Jan 31, 2024  
### Why you should learn SQL in 2024  
SQL is a valuable and marketable skill that every organization needs. It is essential for manipulating and analyzing data stored in databases. SQL is a portable skill that can be used across different databases and data tools. Learning SQL is made easier with DuckDB and MotherDuck.

+3  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/42b67140b260ea7aad7c9b367f2d91be?_a=AQAEufR)  
62  
1
2. 2  
[](/posts/what-happens-when-you-put-a-database-in-your-browser--iatjnmkhh "What Happens When You Put a Database in Your Browser?")  
[![motherduck's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/f084d6835eef4c2b83f889f9a4e85ed6)](/sources/[source]/best-of/[year])  
3m read time • Jun 19, 2024  
### What Happens When You Put a Database in Your Browser?  
WebAssembly has revolutionized browser capabilities, enabling high-performance applications like DuckDB directly in the browser. DuckDB Wasm is particularly useful for in-browser analytics, ad-hoc queries, and educational tools. A practical example includes a Firefox extension for displaying Parquet file schemas in GCP Cloud Storage. MotherDuck leverages DuckDB Wasm for responsive querying and offers an SDK for developers to create data-driven applications.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/e7164077724989c7869608b528ab56bb?_a=AQAEuiZ)  
36  
3
3. 3  
[](/posts/getting-started-with-modern-gis-using-duckdb-6alspzlpw "Getting started with modern GIS using DuckDB")  
[![motherduck's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/f084d6835eef4c2b83f889f9a4e85ed6)](/sources/[source]/best-of/[year])  
10m read time • Sep 19, 2024  
### Getting started with modern GIS using DuckDB  
DuckDB and MotherDuck simplify geospatial analysis by supporting various spatial formats and offering easy integration with Python libraries for visualization. The post guides you through building a heatmap of EV charging spots in France using DuckDB with a Python visualization tool called Lonboard. It also discusses leveraging cloud computing with MotherDuck for sharing and exporting geospatial data.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/a920144a6d3e46a9c00e093e0f5ac1ec?_a=AQAEuiZ)  
21
4. 4  
[](/posts/the-data-warehouse-powered-by-duckdb-sql-bzdpsjcg1 "The Data Warehouse powered by DuckDB SQL")  
[![motherduck's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/f084d6835eef4c2b83f889f9a4e85ed6)](/sources/[source]/best-of/[year])  
4m read time • Nov 02, 2024  
### The Data Warehouse powered by DuckDB SQL  
MotherDuck combines the power of DuckDB SQL with cloud services to offer a flexible and powerful data warehousing solution. It includes robust capabilities for data ingestion, transformation, and analysis, leveraging SQL and additional native Python APIs for complex tasks. Its built-in AI features enhance usability for business users, data scientists, and developers. MotherDuck supports a wide range of file formats and storage solutions, and offers advanced analytical functions, including Machine Learning algorithms, to solve complex business problems efficiently.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/9f2172e10e796e55c75fa3d413108f75?_a=AQAEuj9)  
19
5. 5  
[](/posts/introducing-the-prompt-function-use-the-power-of-llms-with-sql--q9k0hgbxv "Introducing the prompt() Function: Use the Power of LLMs with SQL!")  
[![motherduck's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/f084d6835eef4c2b83f889f9a4e85ed6)](/sources/[source]/best-of/[year])  
6m read time • Oct 19, 2024  
### Introducing the prompt() Function: Use the Power of LLMs with SQL!  
The new prompt() function allows the integration of small language models (SLMs) like OpenAI's gpt-4o-mini into SQL, enabling text summarization and structured data extraction directly within SQL queries. This function is currently in Preview on MotherDuck and supports various use cases such as bulk text summarization and unstructured to structured data conversion. Users can start exploring the function via the Free Trial or Standard Plan, with certain usage quotas in place.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/da7c5e5fba1d81077fea43e02cf545da?_a=AQAEuiZ)  
19
6. 6  
[](/posts/performant-dbt-pipelines-with-motherduck-3zxfr5dam "Performant dbt pipelines with MotherDuck")  
[![motherduck's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/f084d6835eef4c2b83f889f9a4e85ed6)](/sources/[source]/best-of/[year])  
6m read time • Oct 09, 2024  
### Performant dbt pipelines with MotherDuck  
This post recaps learnings from the dbt+MotherDuck workshop and delves into building performant data pipelines using DuckDB and MotherDuck. Key steps include utilizing the read\_blob() function, leveraging pre\_hooks and variables in DuckDB, implementing incremental models with read\_csv(), and handling data de-duplication using unnest() and arg\_max(). These techniques aim to optimize data workflows and enhance data transformation and analysis efficiency.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/4ee6e3ddbe066a2e61c7c9eeccb36f18?_a=AQAEuiZ)  
16  
1
7. 7  
[](/posts/5-hidden-gems-in-duckdb-1-1-wjxgkc6s8 "5 Hidden gems in DuckDB 1.1")  
[![motherduck's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/f084d6835eef4c2b83f889f9a4e85ed6)](/sources/[source]/best-of/[year])  
5m read time • Sep 30, 2024  
### 5 Hidden gems in DuckDB 1.1  
DuckDB 1.1 introduces several new features including custom HTTP headers for API calls, the VARINT data type for optimized memory usage, Pyodide support for running DuckDB in the browser, improvements in query execution speed with ORDER BY and LIMIT clauses, and enhanced debugging capabilities through an HTML EXPLAIN output.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/1a9b316db61d7d20638852cc0f8f0ec7?_a=AQAEuiZ)  
14  
1
8. 8  
[](/posts/developing-a-rag-knowledge-base-with-duckdb-ljw996yp0 "Developing a RAG Knowledge Base with DuckDB")  
[![motherduck's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/f084d6835eef4c2b83f889f9a4e85ed6)](/sources/[source]/best-of/[year])  
5m read time • May 06, 2024  
### Developing a RAG Knowledge Base with DuckDB  
Learn how to build an AI-powered knowledge base using DuckDB, and use it to answer end users' questions by running embedding and language models.

+2  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/7cef6c973541bc3ee2cab6f94cc31c7f?_a=AQAEuiZ)  
14
9. 9  
[](/posts/duckdb-python-end-to-end-data-engineering-project-ziegkocnt "DuckDB & Python : end-to-end data engineering project")  
[![motherduck's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/f084d6835eef4c2b83f889f9a4e85ed6)](/sources/[source]/best-of/[year])  
10m read time • Feb 09, 2024  
### DuckDB & Python : end-to-end data engineering project  
This post discusses an end-to-end data engineering project using DuckDB and Python. It explores the architecture, ingestion pipeline, and sinking data using DuckDB. The post also provides instructions on how to fetch data from PyPi using Python and DuckDB.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/fe492745d3d1d9d68defb83b03764047?_a=AQAEufR)  
14
10. 10  
[](/posts/duckdb-dbt-end-to-end-data-engineering-project-9vuyzsopi "DuckDB & dbt | End-To-End Data Engineering Project")  
[![motherduck's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/f084d6835eef4c2b83f889f9a4e85ed6)](/sources/[source]/best-of/[year])  
8m read time • Mar 22, 2024  
### DuckDB & dbt | End-To-End Data Engineering Project  
This post explores how to improve the development experience in data engineering projects by using DuckDB and dbt. It covers topics such as streamlining architecture, accelerating pipelines, and writing unit tests. It also provides best practices for AWS S3 authentication and managing incremental pipelines.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/b70d079b8efac35134f8582a7b321db6?_a=AQAEufR)  
13
11. 11  
[](/posts/build-a-dashboard-to-monitor-your-python-package-usage-with-duckdb-motherduck-gfu3szln8 "Build a dashboard to monitor your python package usage with DuckDB & MotherDuck")  
[![motherduck's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/f084d6835eef4c2b83f889f9a4e85ed6)](/sources/[source]/best-of/[year])  
9m read time • Jul 15, 2024  
### Build a dashboard to monitor your python package usage with DuckDB & MotherDuck  
Building an analytical dashboard for Python package usage involves processing PyPI download data with DuckDB and storing it in MotherDuck. The data is then visualized using the Evidence BI tool, a framework that utilizes Markdown and SQL for creating dashboards. Key steps include setting up the data share in MotherDuck, defining source queries, and creating charts. The tutorial provides an architecture recap from previous parts, demonstrating ingestion, data transformation, and linking to a preconfigured MotherDuck share.

+3  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/c6c4a25e9660756fcaa49f93197b5bec?_a=AQAEuiZ)  
12

[See all MotherDuck archives](/sources/motherduck/best-of)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/sources/motherduck/best-of/2024#page","url":"https://daily.dev/sources/motherduck/best-of/2024","name":"Best MotherDuck Posts of 2024","description":"The most upvoted MotherDuck posts of 2024, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/sources/motherduck/best-of/2024#items","numberOfItems":11,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/why-you-should-learn-sql-in-2024-viq3bryyc","name":"Why you should learn SQL in 2024"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/what-happens-when-you-put-a-database-in-your-browser--iatjnmkhh","name":"What Happens When You Put a Database in Your Browser?"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/getting-started-with-modern-gis-using-duckdb-6alspzlpw","name":"Getting started with modern GIS using DuckDB"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/the-data-warehouse-powered-by-duckdb-sql-bzdpsjcg1","name":"The Data Warehouse powered by DuckDB SQL"},{"@type":"ListItem","position":5,"url":"https://daily.dev/posts/introducing-the-prompt-function-use-the-power-of-llms-with-sql--q9k0hgbxv","name":"Introducing the prompt() Function: Use the Power of LLMs with SQL!"},{"@type":"ListItem","position":6,"url":"https://daily.dev/posts/performant-dbt-pipelines-with-motherduck-3zxfr5dam","name":"Performant dbt pipelines with MotherDuck"},{"@type":"ListItem","position":7,"url":"https://daily.dev/posts/5-hidden-gems-in-duckdb-1-1-wjxgkc6s8","name":"5 Hidden gems in DuckDB 1.1"},{"@type":"ListItem","position":8,"url":"https://daily.dev/posts/developing-a-rag-knowledge-base-with-duckdb-ljw996yp0","name":"Developing a RAG Knowledge Base with DuckDB"},{"@type":"ListItem","position":9,"url":"https://daily.dev/posts/duckdb-python-end-to-end-data-engineering-project-ziegkocnt","name":"DuckDB \u0026 Python : end-to-end data engineering project"},{"@type":"ListItem","position":10,"url":"https://daily.dev/posts/duckdb-dbt-end-to-end-data-engineering-project-9vuyzsopi","name":"DuckDB \u0026 dbt | End-To-End Data Engineering Project"},{"@type":"ListItem","position":11,"url":"https://daily.dev/posts/build-a-dashboard-to-monitor-your-python-package-usage-with-duckdb-motherduck-gfu3szln8","name":"Build a dashboard to monitor your python package usage with DuckDB \u0026 MotherDuck"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Sources","item":"https://daily.dev/sources"},{"@type":"ListItem","position":3,"name":"MotherDuck","item":"https://daily.dev/sources/motherduck"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/sources/motherduck/best-of"},{"@type":"ListItem","position":5,"name":"2024"}]}]}
```

