🚀 New Blosc blog post: one selective query, 24.3M taxi trips, five tools.

⚡ Cold cache: CTable/.b2z beats DuckDB by ~1.9x (and pandas by 9.4x)
🎯 Block-level indexes prune ~90% of the data — never read, never decompressed
🤝 Warm cache: dead heat with DuckDB
💾 All for just a 2% storage premium over Parquet
🐍 Results are NumPy arrays, no conversion tax

Fully reproducible benchmark inside:
https://blosc.org/posts/ctable-b2z-queries/

#Python #DuckDB #Parquet #OpenSource

#duckdb ist eines der elegantesten Stücke Software-Design der letzten Jahre. In-Process, kein zusätzlicher Server, sehr performant. Die Analyse läuft dort, wo dein Code läuft: #python #go #java #Node #rust oder direkt im #cli.

Das Elegante daran ist die Vektorisierung. Wer große Datenmengen lokal analysieren will, sollte sich DuckDB unbedingt mal anschauen.

https://duckdb.org/

#db #dev

DuckDB Storage Engine for MariaDB. When the Sea Lion Learns to Quack.

https://mariadb.org/duckdb-storage-engine-for-mariadb-when-the-sea-lion-learns-to-quack/

#mariadb #duckdb

Oh my! #DuckDB materialized views as generated #markdown tables for #obsidian. And as a plugin!? This is brilliant! 😍

I actually was doing something similar... but... outputting as a query I had to remember to output to DuckDB. 😅

https://motherduck.com/blog/obsidian-vault-duckdb-ai-agents/

I dislike Obsidian but I know alot of folks here like and use it. This is some neat #DuckDB functionality for it (and the "AI" detractors can skip the "agentic" stuff altogether — at least I think so on first glance read.)

https://motherduck.com/blog/obsidian-vault-duckdb-ai-agents/

Did something change in #DuckDB v1.5.3 in how the import filename works? If you did a `.cd` to the folder with the files and imported files using `READ_CSV ... filename=true` normally you got just the basename - now it seems to be like `.\FILE_DATA_20260602.csv`

🤔

#Database

Gosh I love the creativity of the #DuckDB ecosystem folks.

This DuckDB OpenTelemetry Extension seems pretty spiffy.

https://smithclay.github.io/duckdb-otlp/

if i can do almost all of that without looking at the cheat-sheet, have i become a Data Analyst already ?

#linux #python #sql #perl #sqlite #duckdb