Jordan Tigani

[Future Data] DuckLake: Learning from Cloud Data Warehouses to Build a Robust "Lakehouse" - Carnegie Mellon Database Group When building scalable data systems, it is easy to focus on the... Read More +

Today's Future Data Systems Seminar Speaker: Jordan Tigani (@jrdntgn.bsky.social) will present how @motherduck.com supports modern workloads with DuckLake. Zoom talk open to public at 4:30pm ET. YouTube video available after: db.cs.cmu.edu/events/futur...

You're on the last flight out, gets delayed for two hours and then cancelled. You notice there is a place called "Artichoke Joe's Casino" in walking distance of the airport. Stay up all night playing Pai Gow or risk it on an airport hotel?

Small Data 2025 – The San Francisco Event on Small, Local-First Data Save the date for Small Data 2025, the event where simplicity meets impact. Join industry leaders in exploring the joys of small, local-first data and the future of efficient computing.

Come join us for THE conference of the year!
🎫🦆 Early bird tix are live!
🎤 First round of speakers just dropped!
Join the builders doing more with less →
$295 until Aug 4: smalldatasf.com

🦆 NEW: Mega and Giga ducklings are here!

For when your data is too big, your queries too complex, and "fast enough" isn't fast enough.

Learn More: motherduck.com/blog/announc...

A DuckLake reader for PySpark in ~30 lines of code. Despite looking simple, still partitions work across Spark nodes. Zero external dependencies, just the DuckDB JDBC driver. Try that with your favorite lakehouse technology :-)

pyspark-ducklake-2.py GitHub Gist: instantly share code, notes, and snippets.

Want to read #ducklake from APACHE SPARK? Check this out: gist.github.com/hannes/395ac... #butdoesitscale #yesitdoes

YouTube video by MotherDuck How DuckLake Simplifies Lakehouse Architecture ft. Jordan Tigani & Hannes Mühleisen

If you missed the livestream with @jrdntgn.bsky.social and @hannes.muehleisen.org, now it's your time to catch up!
A technical discussion about the evolution of open table formats and lakehouse architecture.

youtu.be/-PYLFx3FRfQ

DuckDB flips lakehouse model with bring-your-own compute : Open source in-process OLAP system launches rival to Iceberg and Delta Lake table format, and more

DuckDB announced DuckLake and here is why I think I ended up writing such a long piece about it. God bless @theregister.com for giving me the legroom. Thanks to @andypavlo.bsky.social @jrdntgn.bsky.social @hannes.muehleisen.org @hyounpark.bsky.social www.theregister.com/2025/05/28/d...

Yesterday DuckDB Labs announced DuckLake, a new Open data and catalog format. Here is a bit about why it is so awesome, how it solves some key problems with existing technologies, and why we're excited to host it in the cloud at MotherDuck.

Today we're launching DuckLake, an integrated data lake and catalog format powered by SQL. DuckLake unlocks next-generation data warehousing where compute is local, consistency central, and storage scales till infinity. ⁠ducklake is an open standard and we implemented it in the "ducklake" extension.

Instant SQL is HERE
#INSTANTSQL

This legendary panel of technical founders includes Yury Izrailevsky (co-founder of ClickHouse), Kishore Gopalakrishna (founder of StarTree, creator of Apache Pinot), @jrdntgn.bsky.social (co-founder of MotherDuck), and @captaintobs.bsky.social (founder of Tobiko, creators of SQLMesh and SQLGlot).

Simplifying IoT Analytics with MotherDuck - MotherDuck Blog Exploring the sweet spot between simplicity and capability in data systems, one IoT hackathon at a time. | Reading time: 7 min read

Faraz Hameed, winner of the hackathon we co-hosted with Airbyte, shares the story behind his winning project — an IoT use case powered by a modern data stack.

motherduck.com/blog/simplif...

YouTube video by MotherDuck Just quack, and we’ll code | Quack To SQL AI model

Prompting is so 2024.

We’re pushing the boundaries of simplicity with
@duckdb.org

Meet Quack to SQL — our new AI model that turns quack into powerful SQL 👇
www.youtube.com/watch?v=XJWP...

Stop syncing everything Discover Graft, an open-source transactional storage engine built to solve the challenges of syncing data at the edge. Inspired by lessons from SQLSync, Graft enables lazy, partial, and strongly consi...

What if your app could combine the simplicity of physical replication with the efficiency of logical replication? Meet Graft: lazy, partial, strongly consistent edge replication.
#OpenSource #EdgeComputing #Replication
sqlsync.dev/posts/stop-s...

Introducing the DuckDB Local UI, the easiest way to explore local data files with DuckDB. Built in close partnership with @duckdb.org for the community.

duckdb -ui

Learn more:
duckdb.org/2025/03/12/d...

So thrilled the DuckDB UI is out to the world!

Read the post, but wanted to also share a couple small design details we thought about in thread

DuckDB got a local UI. Thanks to our friends at MotherDuck, you can now interact with your DuckDB database through an interactive notebook, running on localhost. Read the announcement blog post at duckdb.org/2025/03/12/d...

A duck on every desk and in every home

We are happy to announce DuckDB v1.2.0 “Histrionicus”!

The new release has several usability, security and performance improvements. It has new features for the CSV and Parquet formats, as well new (opt-in) options for DuckDB's own format.

Read more at duckdb.org/2025/02/05/a...

Congratulations @hannes.muehleisen.org ! Well deserved.

Separating Storage and Compute in DuckDB - MotherDuck Blog Why separate storage and compute in DuckDB, how we do it in MotherDuck to enable sharing and future work. | Reading time: 15 min read

Separating Storage <- and -> Compute in DuckDB by @jrdntgn.bsky.social including how we do this separation in the MotherDuck data warehouse for performance and sharing.

motherduck.com/blog/separat...

Introducing Read Scaling - MotherDuck Blog Read Scaling is now in preview! Read Scaling improves DuckDB SQL query performance by scaling out to multiple DuckDB instances, known as Read Scaling replicas. It is useful to speed up BI dashboards ...

I'm super excited about this launch... it solves one of the scalability gaps we had in MotherDuck, which was "what happens when I put up a dashboard that gets hammered?" motherduck.com/blog/read-sc...

I'm sure it is a legit run but I'd be careful drawing conclusions. The DuckDB results they narrowly beat
are from 2023. if someone updates the results the comparison would look quite different. It is a great accomplishment but it shows why it is dangerous to say you're the fastest in a blog post

🚢 just shipped in the MotherDuck UI: Table Summary

Click a table/view in your catalogs to see column distributions, top values, & null %s. Plus an easy way to peek at actual rows when you need that security blanket.

An easy way to build intuition about your tables w/o having to write SQL!

Foursquare Open Source Places: A new foundational dataset for the geospatial community I did not expect this! > [...] we are announcing today the general availability of a foundational open data set, Foursquare Open Source Places ("FSQ OS Places"). This base layer …

Foursquare just open sourced their 100 million place point of interest dataset! Some notes on poking around with it using DuckDB (it's Parquet files on S3) simonwillison.net/2024/Nov/20/...

Quacking at the Edge: DuckDB on Raspberry Pi - MotherDuck Blog Using MotherDuck’s Dual Query execution on a Raspberry Pi to play a quack sound when users sign up for our service. | Reading time: 12 min read

Someone suggested we should have a "quack" sound play in the office when a new paying customer signed up for MotherDuck. I thought, that would be fun to do... I can learn how to use a Raspberry Pi and use MotherDuck in hybrid mode at the same time. motherduck.com/blog/duckdb-...