There are three, maybe four databases worth bothering with: Postgres if you need a server, SQLite if you don’t, DuckDB if you need OLAP, maybe Clickhouse if you need server OLAP (I remain unconvinced) and Excel.
"Nobody got fired for choosing PostgreSQL"
November 2, 2026 at 12:44 PM
There are three, maybe four databases worth bothering with: Postgres if you need a server, SQLite if you don’t, DuckDB if you need OLAP, maybe Clickhouse if you need server OLAP (I remain unconvinced) and Excel.
How I query DuckDB in the Terminal.
asciinema.org/a/663546
asciinema.org/a/663546
Using DuckDB in the Terminal (vim-dadbod)
My favorite SQL IDE, vim-dadbod, and vim-dadbod-ui, now supports DuckDB as a database (besides many other Big Query, ClickHouse, Impala, jq, MongoDB, MySQL, Oracle, query, PostgreSQL, Presto, Redis...
asciinema.org
November 1, 2026 at 8:40 AM
How I query DuckDB in the Terminal.
asciinema.org/a/663546
asciinema.org/a/663546
Quack, quack! 🦆🤖
You can now install #DuckDB in Claude Code from the Claude Marketplace
Let us know what you think: duckdb.org/install/?env...
You can now install #DuckDB in Claude Code from the Claude Marketplace
Let us know what you think: duckdb.org/install/?env...
November 3, 2026 at 12:54 AM
Quack, quack! 🦆🤖
You can now install #DuckDB in Claude Code from the Claude Marketplace
Let us know what you think: duckdb.org/install/?env...
You can now install #DuckDB in Claude Code from the Claude Marketplace
Let us know what you think: duckdb.org/install/?env...
> SUM(distance)
> PDB vs DuckDB
> 156x
gottem
> PDB vs DuckDB
> 156x
gottem
November 1, 2026 at 3:26 PM
> SUM(distance)
> PDB vs DuckDB
> 156x
gottem
> PDB vs DuckDB
> 156x
gottem
Reading Karpathy's HackerTube, and then seeing a bunch of other apps on top of Hacker News like HackerBooks and Wikihacks got me thinking.
We can just run HackerTube, HackerBooks & Wikihack directly in your terminal with DuckDB and Hugging Face.
We can just run HackerTube, HackerBooks & Wikihack directly in your terminal with DuckDB and Hugging Face.
Querying HackerNews with DuckDB directly (HackerTube, HackerBooks & Wikihack)
Reading Karpathy's HackerTube, and then seeing a bunch of other apps on top of Hacker News like HackerBooks and Wikihacks:
www.ssp.sh
November 2, 2026 at 11:21 AM
Reading Karpathy's HackerTube, and then seeing a bunch of other apps on top of Hacker News like HackerBooks and Wikihacks got me thinking.
We can just run HackerTube, HackerBooks & Wikihack directly in your terminal with DuckDB and Hugging Face.
We can just run HackerTube, HackerBooks & Wikihack directly in your terminal with DuckDB and Hugging Face.
clickhouse also has a client mode and can just point at duckdb stuff which is kinda why I'm often full clickhouse but...
November 2, 2026 at 1:16 PM
clickhouse also has a client mode and can just point at duckdb stuff which is kinda why I'm often full clickhouse but...
Matt Martin's career started the way many data engineers do: wrangling spreadsheets. 🤠
After 20 years of working with different data infrastructures, Matt discovered #DuckDB, and everything changed.
Read the full story below – From Spreadsheets to DuckLake: One Data Engineer’s Road to DuckDB.
After 20 years of working with different data infrastructures, Matt discovered #DuckDB, and everything changed.
Read the full story below – From Spreadsheets to DuckLake: One Data Engineer’s Road to DuckDB.
From Spreadsheets to DuckLake: A Data Engineer's Road to DuckDB
After nearly two decades working with increasingly sophisticated data infrastructure, data engineer Matt Martin discovered DuckDB could handle many of the analytical tasks he cared about without the o...
duckdb.org
October 30, 2026 at 3:59 AM
Matt Martin's career started the way many data engineers do: wrangling spreadsheets. 🤠
After 20 years of working with different data infrastructures, Matt discovered #DuckDB, and everything changed.
Read the full story below – From Spreadsheets to DuckLake: One Data Engineer’s Road to DuckDB.
After 20 years of working with different data infrastructures, Matt discovered #DuckDB, and everything changed.
Read the full story below – From Spreadsheets to DuckLake: One Data Engineer’s Road to DuckDB.
I wrote a blog post about self-signing and -hosting @duckdb.org v2.0.0 extensions on S3-compatible object storage:
tobilg.com/posts/duckdb...
tobilg.com/posts/duckdb...
Host Signed DuckDB Extensions on S3-Compatible Storage - tobilg.com
DuckDB 2.0 can trust your own signing key. Sign an extension with OpenSSL, host it in an S3-compatible bucket and install it without -unsigned.
tobilg.com
October 30, 2026 at 4:05 PM
I wrote a blog post about self-signing and -hosting @duckdb.org v2.0.0 extensions on S3-compatible object storage:
tobilg.com/posts/duckdb...
tobilg.com/posts/duckdb...
Faster DuckDB Queries with Vortex
What ClickHouse was for many cloud data warehouses, DuckDB is for local analytics: an extendable execution engine. Numbers are fast I assume it was not done on massive datasets. Haven't checked how numbers are against object storage.
spiraldb.com/blog/duckdb-...
What ClickHouse was for many cloud data warehouses, DuckDB is for local analytics: an extendable execution engine. Numbers are fast I assume it was not done on massive datasets. Haven't checked how numbers are against object storage.
spiraldb.com/blog/duckdb-...
Faster DuckDB Queries with Vortex
With the release of DuckDB 2.0, we look at how the Vortex core extension speeds up queries by computing over compressed data, and how to read and write Vortex files from DuckDB.
spiraldb.com
November 2, 2026 at 1:56 PM
Faster DuckDB Queries with Vortex
What ClickHouse was for many cloud data warehouses, DuckDB is for local analytics: an extendable execution engine. Numbers are fast I assume it was not done on massive datasets. Haven't checked how numbers are against object storage.
spiraldb.com/blog/duckdb-...
What ClickHouse was for many cloud data warehouses, DuckDB is for local analytics: an extendable execution engine. Numbers are fast I assume it was not done on massive datasets. Haven't checked how numbers are against object storage.
spiraldb.com/blog/duckdb-...
My "differential" DuckDB extension now also allows merging of branches and snapshots with v1.1.
It allows git-style branching, merging, snapshots, time-travel etc. with regular databases, locally or on S3-compatible storage.
Blog post: tobilg.com/posts/duckdb...
It allows git-style branching, merging, snapshots, time-travel etc. with regular databases, locally or on S3-compatible storage.
Blog post: tobilg.com/posts/duckdb...
Merges for DuckDB Branches and Snapshots - tobilg.com
differential 1.1 brings three-way merges to DuckDB: merge branches and snapshots, fast-forward, resolve typed conflicts with a table, merge schemas, use S3.
tobilg.com
October 30, 2026 at 5:28 PM
My "differential" DuckDB extension now also allows merging of branches and snapshots with v1.1.
It allows git-style branching, merging, snapshots, time-travel etc. with regular databases, locally or on S3-compatible storage.
Blog post: tobilg.com/posts/duckdb...
It allows git-style branching, merging, snapshots, time-travel etc. with regular databases, locally or on S3-compatible storage.
Blog post: tobilg.com/posts/duckdb...
1.3 million records per day of CTA data. Let’s fucking go!
FYI, I recommend querying this with duckdb. duckdb.org
FYI, I recommend querying this with duckdb. duckdb.org
October 31, 2026 at 9:31 PM
1.3 million records per day of CTA data. Let’s fucking go!
FYI, I recommend querying this with duckdb. duckdb.org
FYI, I recommend querying this with duckdb. duckdb.org
Moving our warehouse off DuckDB | Discussion
Why we're moving our warehouse off DuckDB
We moved our data warehouse off DuckDB and DuckLake onto our own flavor of Trino and a new open table format, HogLake. Here's what broke at scale and why.
posthog.com
November 2, 2026 at 4:40 PM
Moving our warehouse off DuckDB | Discussion
Just depends on the system. But I like Postgres, SQLite, Redis, ClickHouse, DuckDB, MySQL, and sometimes even proprietary options.
November 2, 2026 at 9:37 PM
Just depends on the system. But I like Postgres, SQLite, Redis, ClickHouse, DuckDB, MySQL, and sometimes even proprietary options.
Moving our warehouse off DuckDB
#HackerNews
<a href="https://posthog.com/blog/moving-off-duckdb" class="hover:underline text-blue-600 dark:text-sky-400 no-card-link" target="_blank" rel="noopener" data-link="bsky">https://posthog.com/blog/moving-off-duckdb
#HackerNews
<a href="https://posthog.com/blog/moving-off-duckdb" class="hover:underline text-blue-600 dark:text-sky-400 no-card-link" target="_blank" rel="noopener" data-link="bsky">https://posthog.com/blog/moving-off-duckdb
November 2, 2026 at 4:53 PM
Moving our warehouse off DuckDB
#HackerNews
<a href="https://posthog.com/blog/moving-off-duckdb" class="hover:underline text-blue-600 dark:text-sky-400 no-card-link" target="_blank" rel="noopener" data-link="bsky">https://posthog.com/blog/moving-off-duckdb
#HackerNews
<a href="https://posthog.com/blog/moving-off-duckdb" class="hover:underline text-blue-600 dark:text-sky-400 no-card-link" target="_blank" rel="noopener" data-link="bsky">https://posthog.com/blog/moving-off-duckdb
Powered by DuckDB, you say? We're in! 🦆 🦆
October 31, 2026 at 5:56 PM
Powered by DuckDB, you say? We're in! 🦆 🦆
I mean come on lol web.archive.org/web/20260518...
OLAP Comparison
Head-to-head vs DuckDB and PostgreSQL on real datasets.
web.archive.org
November 1, 2026 at 3:25 PM
I mean come on lol web.archive.org/web/20260518...
Moving our warehouse off DuckDB
https://posthog.com/blog/moving-off-duckdb
https://posthog.com/blog/moving-off-duckdb
November 2, 2026 at 5:17 PM
Moving our warehouse off DuckDB
https://posthog.com/blog/moving-off-duckdb
https://posthog.com/blog/moving-off-duckdb
November 2, 2026 at 4:40 PM
Podcast: Databases for Humans & Agents with Hannes Mühleisen 🎧
In this episode of the @datarenegades.bsky.social podcast, DuckDB co-creator @hannes.muehleisen.org speaks with @clkao.bsky.social about building databases that people actually want to use, including #DuckDB! 🦆 🦆
Listen to the episode:
In this episode of the @datarenegades.bsky.social podcast, DuckDB co-creator @hannes.muehleisen.org speaks with @clkao.bsky.social about building databases that people actually want to use, including #DuckDB! 🦆 🦆
Listen to the episode:
Data Renegades | Ep. #14, Databases for Humans and Agents with Hannes Mühleisen | Heavybit
CL Kao sits down with DuckDB co-creator Hannes Mühleisen on going rogue at CWI, the lost decade of small data, joining AWS, and building databases for agents.
www.heavybit.com
October 30, 2026 at 4:56 PM
Podcast: Databases for Humans & Agents with Hannes Mühleisen 🎧
In this episode of the @datarenegades.bsky.social podcast, DuckDB co-creator @hannes.muehleisen.org speaks with @clkao.bsky.social about building databases that people actually want to use, including #DuckDB! 🦆 🦆
Listen to the episode:
In this episode of the @datarenegades.bsky.social podcast, DuckDB co-creator @hannes.muehleisen.org speaks with @clkao.bsky.social about building databases that people actually want to use, including #DuckDB! 🦆 🦆
Listen to the episode:
Someone sent you a .duckdb file and you don't have DuckDB? Drop it on Nitilo: DuckDB itself runs in your browser tab and opens it as tables, keys kept, lists and structs as JSON, SQL right there. Nothing is uploaded.
youtu.be/9S6Qt7GFas8
youtu.be/9S6Qt7GFas8
Open a DuckDB database in your browser, no DuckDB needed | Nitilo
YouTube video by Nitilo
youtu.be
November 3, 2026 at 5:06 AM
Someone sent you a .duckdb file and you don't have DuckDB? Drop it on Nitilo: DuckDB itself runs in your browser tab and opens it as tables, keys kept, lists and structs as JSON, SQL right there. Nothing is uploaded.
youtu.be/9S6Qt7GFas8
youtu.be/9S6Qt7GFas8
And polars is great! In most things we've converted to Python, we use polars (64-bit), and then I use DuckDB for more interactive or ad hoc exploration of the data.
November 2, 2026 at 4:53 PM
And polars is great! In most things we've converted to Python, we use polars (64-bit), and then I use DuckDB for more interactive or ad hoc exploration of the data.
Did some performance testing on 7 days of data, the duckdb native tables are fucking mental
October 31, 2026 at 10:01 PM
Did some performance testing on 7 days of data, the duckdb native tables are fucking mental