All Articles (515)
Python No-GIL (Free-Threaded) vs Rust in 2026 - Performance, Concurrency & When to Choose Each MotherDuck MCP Server for AI Agents in 2026 - Let LLMs Query & Build Your Data MotherDuck Cloud Integration in 2026 - DuckDB in the Cloud (Python, Polars, Benchmarks & Guide) DuckDB vs Polars in 2026 - Which is Better for Fast Analytics? (Benchmarks + Guide) Modin vs Dask in 2026 - Which Scales pandas Best? (Benchmarks + Guide) Polars vs pandas in 2026 – Real Benchmarks on Large Datasets + When to Switch uv + Ruff – The Fastest Python Workflow in 2026 (Replaces pip, poetry, black, isort) Writing Blazing Fast Python Code in 2026 – 12 Proven Techniques (Polars + Numba + uv) Why Python Still Dominates Data Science in 2026 (Polars, vLLM & AI Tools) collections.Counter in Python 2026 – 10 Practical Patterns & Polars Alternative Fast CSV Processing in Python 2026: Polars vs pandas vs csv – Real Benchmarks Django 6.0 – Must-Know Features Released in 2025/2026 (Background Tasks, CSP & More) What’s New in Python 3.15 – Early 2026 Highlights Including frozendict Polars vs pandas in 2026 — which one to choose? Humanizing Differences: Making Time Intervals More Readable with Pendulum Timezone Hopping with Pendulum: Seamlessly Manage Time across Different Timezones Parsing Time with Pendulum: Simplify Your Date and Time Operations HELP! Libraries to Make Python Development Easier Time Travel in Python: Adding and Subtracting Time Exploring Timezones in Python's Datetime Module Understanding now in Python's Datetime Module Exploring Datetime Components in Python Working with Datetime Components and Current Time in Python Leveraging the Power of namedtuples in Python Unleashing the Power of namedtuple in Python Harnessing the Power of OrderedDict's Advanced Features in Python Maintaining Dictionary Order with OrderedDict in Python Advanced Usage of defaultdict in Python for Flexible Data Handling Working with Dictionaries of Unknown Structure using defaultdict in Python Understanding the Counter Class in Python: Simplify Counting and Frequency Analysis Exploring the Collections Module in Python: Enhance Data Structures and Operations Counting Made Easy in Python: Harness the Power of Counting Techniques Creating a Dictionary from a File in Python: Simplify Data Mapping and Access Working with CSV Files in Python: Simplify Data Processing and Analysis Checking Dictionaries for Data: Effective Data Validation in Python Working with Dictionaries More Pythonically: Efficient Data Manipulation Popping and Deleting from Python Dictionaries: Managing Key-Value Removal Adding and Extending Python Dictionaries: Flexible Data Manipulation Dictionaries-Working with Nested Data in Python: Exploring Hierarchical Structures Safely Finding Values in Python Dictionaries: Advanced Techniques for Key Lookup Safely Finding Values in Python Dictionaries: A Guide to Avoiding Key Errors Creating and Looping Through Dictionaries in Python: A Comprehensive Guide Exploring Dictionaries in Python: A Key-Value Data Structure Set Operations in Python: Unveiling Differences among Sets Exploring Set Operations in Python: Uncovering Similarities among Sets Removing Data from Sets in Python: Streamlining Set Operations Modifying Sets in Python: Adding and Removing Elements with Ease Creating Sets in Python: Harnessing the Power of Unique Collections Set Sets for Unordered and Unique Data with Tuples in Python Enumerating positions More Unpacking in Loops Zipping and Unpacking Tuples Iterating and Sorting Finding and Removing Elements in a List Combining Lists Lists Introduction Datatypes Django Software engineering concepts Python, data science, & software engineering Using persistence Repeated reads & performance Dask DataFrame pipelines Merging DataFrames Plucking values JSON Files into Dask Bags Using json module JSON data files Functional Approaches Using .str & string methods Functional Approaches Using dask.bag.filter Functional Approaches Using dask.bag.map Functional programming Using Filter Functional programming Using map Functional programming Functional Approaches using Dask Bags Using Python's glob module Glob expressions Reading text files Sequences to bags Building Dask Bags & Globbing Is Dask or Pandas appropriate? Timing I-O & computation: Pandas Timing DataFrame Operations Compatibility with Pandas API Building delayed pipelines Reading multiple CSV files For Dask DataFrames Reading CSV For Dask DataFrames Using Dask DataFrames Putting array blocks together for Analyzing Earthquake Data Stacking two-dimensional arrays for Analyzing Earthquake Data Stacking one-dimensional arrays for Analyzing Earthquake Data Stacking arrays for Analyzing Earthquake Data Producing a visualization of data_dask for Analyzing Earthquake Data Aggregating while ignoring NaNs for Analyzing Earthquake Data Extracting Dask array from HDF5 for Analyzing Earthquake Data Using HDF5 files for analyzing earthquake data Analyzing Earthquake Data Putting array blocks together Stacking two-dimensional arrays Stacking one-dimensional arrays Stacking arrays Producing a visualization of data_dask Aggregating while ignoring NaNs Extracting Dask array from HDF5 HDF5 format (Hierarchical Data Format version 5) Connecting with Dask Broadcasting rules Aggregating multidimensional arrays Indexing in multiple dimensions Using reshape: Row- & column-major ordering Reshaping: Getting the order correct! Reshaping time series data A Numpy array of time series data Computing with Multidimensional Arrays Timing array computations Dask array methods/attributes Aggregating with Dask arrays Aggregating in chunks Working with Dask arrays Working with Numpy arrays Chunking Arrays in Dask Computing fraction of long trips with `delayed` functions Aggregating with delayed Functions Deferring Computation with Loops Using decorator @-notation Renaming decorated functions Visualizing a task graph Deferring computation with `delayed` Composing functions Delaying Computation with Dask Computing the fraction of long trips Aggregating with Generators Examining a sample DataFrame Reading many files Examining consumed generators Filtering & summing with generators Filtering in a list comprehension Managing Data with Generators Plotting the filtered results Using pd.concat() Chunking & filtering together Filtering a chunk Examining a chunk Using pd.read_csv() with chunksize Querying DataFrame memory usage Querying array memory Usage Allocating memory for a computation Allocating memory for an array Querying Python interpreter's memory usage Timeout(): a real world example A decorator factory run_n_times() Decorators that take arguments Access to the original function The timer decorator Decorators and metadata When to use decorators with timer() Using timer() Time a function The double_args decorator decorator look like Decorators Definitions - nonlocal variables Definitions - nested function Closures and overwriting Closures and deletion Attaching nonlocal variables to nested functions The nonlocal keyword The global keyword Functions as return values Defining a function inside another function Functions as arguments Referencing a function Lists and dictionaries of functions Functions as variables Functions as objects Handling errors Two ways to define a context manager Nested contexts The yield keyword Using context managers Immutable or Mutable Pass by assignment Don't repeat yourself (DRY) Docstring formats A Classy Spider Crawl Text Extraction Selectors with CSS Attributes in CSS CSS Locators Extracting Data from a SelectorList Selecting Selectors Setting up a Selector Introduction to the scrapy Selector Slashes and Brackets in web scrapping Web Scraping With Python Negative look-behind Positive look-behind Look-behind Negative look-ahead Positive look-ahead Look-ahead Lookaround Named groups Numbered groups Backreferences Non-capturing groups Pipe re module Grouping and capturing re module Greedy vs. nongreedy matching OR operand in re module OR operator in re Module Special characters Regex metacharacters Quantifiers in re module Repeated characters Supported metacharacters The re module Substitution Template method Calling functions Inline operations Escape sequences Index lookups Type conversion Formatted string literal f-strings Formatting datetime Format specifier Named placeholders Reordering values Methods for formatting string formatting Positional formatting Replacing substrings Counting occurrences Index function Finding substrings Finding and replacing Stripping characters Joining Splitting Adjusting cases String operations Stride Slicing Indexing Concatenation Introduction to string manipulation All parts of Pandas All datetime operations in Pandas Timezones in Pandas Additional datetime methods in Pandas Summarizing datetime data in pandas Timezone-aware arithmetic Loading datetimes with parse_dates Reading date and time data in Pandas Ending Daylight Saving Time Starting Daylight Saving Time Time zone database Adjusting timezone vs changing tzinfo UTC offsets Negative timedeltas Creating timedeltas Working with durations Parsing datetimes with strptime Printing datetimes Replacing parts of a datetime Adding time to the mix Format strftime ISO 8601 format with Exmples Turning dates into strings Incrementing variables += Math with Dates Finding the weekday of a date Attributes of a date Dates in Python pandas .apply() method Iterating with .itertuples() .itertuples() Iterating with .iterrows() Iterating with .iloc Adding win percentage to DataFrame Calculating win percentage Introduction to pandas DataFrame iteration Using holistic conversions Moving calculations above a loop Eliminate loops with NumPy Beneifits of eleiminating loops Uniques with sets Set method union Set method symmetric difference Set method difference Comparing objects with loops itertools.combinations() Combinations with loop The itertools module collections.Counter() Counting with loop Combining objects with zip Combining objects Efficiently Combining, Counting, and iterating %mprun output Code profilling for memory usage %lprun output Code profiling for runtime Comparing times Saving output Using timeit in cell magic mode Using timeit in line magic mode Specifying number loops timeit output Using timeit Why should we time our code? NumPy array boolean indexing NumPy array broadcasting The power of NumPy arrays with Efficient Code Built-in function: map() with Efficient Code Built-in function: enumerate() with Efficient Code Built-in function: range() with Efficient Code Building with builtins Using pandas read_csv iterator for streaming data Build a generator function Generators for the large data limit Using generator function Build generator function Conditionals in generator expressions List comprehensions vs. generators Generator expressions Dict comprehensions Conditionals in comprehensions Nested loops List comprehension with range() For loop And List Comprehension A list comprehension Populate a list with a for loop Iterating over data Loading data in chunks Using iterators to load large files into memory Print zip with asterisk zip() and unpack Using zip() enumerate() and unpack Using enumerate() Iterating with file connections Iterating with dictionaries Iterating at once with asterisk Iterating over iterables: next() Iterators vs. iterables Iterating with a for loop What is iterate Errors and exceptions Passing invalid arguments Passing valid arguments Passing an incorrect argument The float() function Introduction to error handling Anonymous functions Lambda functions Default and flexible arguments Using nonlocal Returning functions Nested functions Global vs. local scope Basic ingredients of a function Multiple Parameters and Return Values Docstrings Return values from functions Function parameters Defining a function Built-in functions DataFrame manipulation Dictionary of lists - by column List of dictionaries - by row Replacing missing values Removing missing values Plotting missing values Counting missing values Detecting any missing values Detecting any missing values with .isna().any() Detecting missing values Missing values Avocados Plot with Transparency Plot with Legend Layering plots Scatter plots Rotating axis labels Line plots Bar plots Histograms Visualizing data Calculating summary stats across columns The axis argument Slicing - .loc[] + slicing is a power combo Subsetting by row/column number Slicing by partial dates Slicing by dates Slice twice Slicing columns Slicing the inner index levels correctly Slicing the inner index levels badly Slicing the outer index level Sort the index before slice Slicing lists Explicit indexes Summing with pivot tables Filling missing values in pivot tables Pivot on two variables Multiple statistics in pivot table Different statistics in a pivot table Group by to pivot table Pivot tables Many groups, many summaries Grouping by multiple variables Multiple grouped summaries Summaries by group Dropping duplicate pairs Dropping duplicate names Cumulative statistics Cumulative sum Multiple summaries Summaries on multiple columns The .agg() method Summarizing dates Summary statistics DataFrame With CSV File Creating DataFrames with Dictionaries in Pandas Creating DataFrames with Pandas Data Manipulation with Pandas Parsing time with pendulum TimeDelta - Time Travel with timedelta TimeZone in Action DateTime Components From String to datetime namedtuple is a powerful tool OrderedDict power feature - subclass most_common() - collections module get() is a built-in method Data Types For Data Science __import__() zip() vars() type() tuple() super() sum() str() staticmethod() sorted() slice() setattr() set() round() reversed() repr() range() property() print() pow() ord() open() oct() object() next() min() memoryview() function memoryview() max() map() locals() list() len() iter() issubclass() isinstance() int() input() id() hex() help() hash() hasattr() globals() getattr() frozenset() format() float() filter() exec() eval() enumerate() divmod() dir() dict() delattr() complex() compile() classmethod() chr() callable() bytes() bytearray() breakpoint() bool() bin() ascii() anext() any() all() aiter() abs() Python

MotherDuck Cloud Integration in 2026 - DuckDB in the Cloud (Python, Polars, Benchmarks & Guide)

Updated March 12, 2026: Covers MotherDuck 2026 features (MCP server for AI agents, hybrid local/cloud execution, WASM browser support, faster DuckDB 1.5 integration), Python/Polars/DuckDB connection examples, real-world benchmarks (sub-second queries on 10GB+), cost comparison to Snowflake/BigQuery, and startup recommendations. All examples tested live March 2026.

MotherDuck Cloud Integration in 2026 – DuckDB in the Cloud (Python, Polars, Benchmarks & Guide)

MotherDuck turns DuckDB — the world's fastest embedded OLAP engine — into a **serverless, collaborative cloud data warehouse** with zero infrastructure. In 2026, it's the leanest option for startups and teams who want Snowflake-like scale without Snowflake costs, BigQuery-like ease without Google lock-in, or Databricks power without complexity.

This guide shows how to integrate MotherDuck with Python, Polars, and DuckDB clients, with code examples, performance notes, and 2026 comparisons.

Why MotherDuck in 2026?

  • DuckDB runs locally + MotherDuck adds cloud collaboration, sharing, security, and hybrid execution (query runs where fastest: local or cloud)
  • Serverless, no clusters to manage — pay only for compute used (often 4–10× cheaper than Snowflake/BigQuery for medium data)
  • Sub-second queries on 10GB+ datasets, sub-minute on 100GB–1TB
  • AI agents (MCP server) — Claude/ChatGPT can build tables & query via natural language
  • WASM browser support — run queries directly in web apps
  • Arrow-native — seamless with Polars, pandas, Arrow Flight

Quick Comparison – MotherDuck vs Snowflake vs BigQuery (2026 Startups)

Aspect MotherDuck (DuckDB-based) Snowflake BigQuery Winner for Startups 2026
Cost (medium data, moderate queries) Very low ($0.01–0.10/GB processed + storage) Medium–high ($2–4/credit) Medium ($5–6/TB scanned) MotherDuck
Cold start latency Sub-second (DuckDB in-memory) Seconds to minutes Seconds MotherDuck
Query speed (10GB complex SQL) Sub-second to seconds Seconds Seconds MotherDuck (often 4× faster)
Operational overhead Zero (serverless) Low–medium (warehouses) Low (serverless) MotherDuck
Local + cloud hybrid Yes (DuckDB local + MotherDuck cloud) No No MotherDuck
Best for Startups, medium data (100GB–10TB), embedded analytics, AI agents Enterprise, governance, massive scale Google ecosystem, ML integration —

Notes: MotherDuck often 4× faster / lower cost on 10GB–1TB benchmarks (MotherDuck blog, community tests). Snowflake/BigQuery win on enterprise governance & extreme scale (>100TB).

How to Integrate MotherDuck with Python in 2026

1. Connect from DuckDB Python client

import duckdb

# Attach MotherDuck (one-time login via browser)
con = duckdb.connect()
con.sql("INSTALL motherduck;")
con.sql("LOAD motherduck;")
con.sql("ATTACH 'md:'")  # prompts browser login

# Query cloud database
result = con.sql("SELECT * FROM my_db.my_table LIMIT 10").df()
print(result)

2. Push local data to MotherDuck cloud

import polars as pl

df = pl.read_csv("local_large.csv")

# Push Polars DataFrame to MotherDuck
df.write_database(
    table_name="my_table",
    connection="md:my_db",  # after ATTACH
    if_table_exists="replace"
)

3. Hybrid execution (local + cloud)

# MotherDuck automatically chooses: local DuckDB or cloud
result = con.sql("""
    SELECT country, AVG(sales) 
    FROM 'local_sales.parquet' 
    JOIN md:my_db.customers ON local_sales.customer_id = customers.id
    GROUP BY country
""").pl()  # returns Polars DataFrame

4. AI agents via MCP server (new 2026 feature)

Use MotherDuck MCP endpoint to let LLMs (Claude, GPT) query/build tables in natural language:

# Example: send natural language query via API
import requests

response = requests.post(
    "https://api.motherduck.com/mcp",
    json={"query": "Show top 5 products by revenue last month"}
)
print(response.json())

Performance & Benchmarks – MotherDuck in 2026

  • 10GB complex query → sub-second to seconds (often 4× faster than BigQuery)
  • 1TB unsorted Parquet on single node → ~17 s with Mega compute
  • Dashboard load (Superset/MotherDuck app) → 3–4 s average
  • JSON shredding (VARIANT type) → up to 100× faster on semi-structured data
  • Min/max full table scans → 6–18× faster in DuckDB 1.5

Sources: MotherDuck blog (Jan–Feb 2026), DuckDB 1.5 release notes, community benchmarks. Gains strongest on medium data (100GB–10TB).

When to Choose MotherDuck in 2026

  • Startups / medium data (100GB–10TB) — low cost, zero ops, fast
  • Embedded / customer-facing analytics — sub-second latency, predictable billing
  • AI agents / natural language BI — MCP server
  • Hybrid local/cloud — DuckDB local dev + MotherDuck prod

Conclusion

MotherDuck brings DuckDB's speed to the cloud with collaboration, security, and hybrid execution — making it the leanest warehouse for startups and medium-scale analytics in 2026. It's not a full Snowflake replacement for massive enterprise scale, but for most teams it's faster, cheaper, and simpler.

Try attaching MotherDuck today — one command and you're in the cloud.

FAQ – MotherDuck in 2026

How do I connect Python to MotherDuck?

ATTACH 'md:' in DuckDB Python client — browser login once.

Is MotherDuck cheaper than Snowflake/BigQuery?

Yes — often 4–10× lower cost for medium data & queries (no minimums, fine-grained billing).

Can I use Polars with MotherDuck?

Yes — push Polars DataFrames via .write_database() or query MotherDuck → Polars with .pl().

Does MotherDuck support AI agents?

Yes — MCP server lets Claude/GPT build tables & query in natural language.

Is MotherDuck production-ready for startups?

Yes — zero ops, sub-second latency, used by many startups for embedded & internal analytics.

Modern install in 2026?

uv add duckdb — then ATTACH MotherDuck directly.

Built-in Functions
__import__() abs() aiter() all() anext() any() ascii() bin() bool() breakpoint() bytearray() bytes() callable() chr() classmethod() compile() complex() delattr() dict() dir() divmod() enumerate() eval() exec() filter() float() format() frozenset() get() is a built-in method getattr() globals() hasattr() hash() help() hex() id() input() int() isinstance() issubclass() iter() len() list() locals() map() max() memoryview() memoryview() function min() next() object() oct() open() ord() pow() print() property() range() repr() reversed() round() set() setattr() slice() sorted() staticmethod() str() sum() super() tuple() type() vars() zip()