iiinova — where your digital self keeps evolving

Alejandro Wainzinger @xevix.bsky.social · 02/10/2026

Having fun testing Nimble on ollama (open weights jev basically), and works as advertised. Can't wait for an official GUI, but a quick streamlit hack works just fine for now.

000

Alejandro Wainzinger @xevix.bsky.social · 16/09/2026

New version of DuckParq now with Vortex support. 1.5B rows / 22.3GB Vortex file opens instantly. Yes, try not to make files that gigantic, but in case you do 😶‍🌫️. github.com/xevix/duckpa...

010

Alejandro Wainzinger @xevix.bsky.social · 16/09/2026

Maybe saving this for follow-up blog post, but what HBM for memory (if any) was used here?

010

Alejandro Wainzinger @xevix.bsky.social · 13/09/2026

Quick hack to pipe results from nushell to a duckdb table for further querying. gist.github.com/xevix/466e5e...

020

Alejandro Wainzinger @xevix.bsky.social · 13/09/2026

Slowly catching up on the last few years of CLI tools: fzf, zoxide, bat, btop, zellij, nushell, ghostty &c. Wish I'd had these years ago, so fast and useful. LLMs do a lot these days, but simple stuff is faster done alone with powerful and simple tools.

021

Alejandro Wainzinger @xevix.bsky.social · 09/09/2026

Investment is a wacky, crazy world. Money is useful, but there's something satisfying about writing software that people use. Maybe not the 10 millionth calendar app though 😅

010

Alejandro Wainzinger @xevix.bsky.social · 02/09/2026

The Pangeo channel is a great collection of talks around recent GIS development and usage. Been peeking at it for a while and watching more these days. www.youtube.com/@pangeo2060

youtube.com

Pangeo

Pangeo is a community and platform for big data analysis in the geoscience and beyond. You can learn more about Pangeo at https://pangeo.io. This channel hosts content generated by the Pangeo Commun...

020

Alejandro Wainzinger @xevix.bsky.social · 02/09/2026

Zarr dataset (~1B numbers, (24, 37, 721, 1440) float 32) mean() CPU vs GPU. Manual threadpool gets CPU close to GPU but numpy (1 thread) and dask are quite slow. M4 Max 128GB. MLX code requires so few lines, definitely worth it. gist.github.com/xevix/c320ed...

000

Alejandro Wainzinger @xevix.bsky.social · 01/09/2026

Visualization of zarr in common GUIs seems in transition. Panoply supports v2 w/o compression but not v3. QGIS supports v3 but squashes dimensions, seems not to allow slicing dimensions; GeoZarr plugin breaks on sharding_indexed codec loading via STAC (gdal update may fix). Almost there 🤞

201

Alejandro Wainzinger @xevix.bsky.social · 01/09/2026

Love the technical write-up, lot of deep work went into this. Gemini translation for a TL;DR: CTE go brrrr 🚀

020

Alejandro Wainzinger @xevix.bsky.social · 30/08/2026

Also seems like the DuckDB Vortex extension currently doesn't support compact conversion from parquet, must use vx or Vortex API. Using compact has significant impact: 40Mb->20Mb in one case. Still cool to be able to query without another tool.

000

Alejandro Wainzinger @xevix.bsky.social · 30/08/2026

Interestingly even a COUNT(*) that is done entirely from metadata is faster, because Parquet's Thrift metadata deserialization takes variable time, whereas Vortex's FlatBuffer footer is zero-copy, no per-chunk deserialization, constant and takes microseconds.

100

Alejandro Wainzinger @xevix.bsky.social · 30/08/2026

vx is a nice first party tool to look around where the FastLanes bitpacking is happening and how.

110

Alejandro Wainzinger @xevix.bsky.social · 30/08/2026

Quick test of Vortex vs ParquetV2 w/ zstd on taxi data in DuckDB. 48M rows 1 file. As advertised Vortex has faster selective querying and aggs due in part to avoiding decompression (~30% faster here). File also ~7% smaller. Will test Hive once partitioned writes fix released (fixed upstream).

110

Reposted by Alejandro Wainzinger

DuckDB @duckdb.org · 28/08/2026

What’s Next for DuckDB? 🦆 🤔 @hannes.muehleisen.org, co-creator of #DuckDB, was recently interviewed by @krisajenkins.bsky.social of the Developer Voices podcast on every challenge, reward, twist and turn of building a database as popular as DuckDB -- including a big acquisition. Watch or read:

duckdb.org

What Next for DuckDB

DuckDB is an in-process SQL database management system focused on analytical query processing. It is designed to be easy to install and easy to use. DuckDB has no external dependencies. DuckDB has bin...

0123

Alejandro Wainzinger @xevix.bsky.social · 28/08/2026

Neat talks hosted by Motherduck yesterday. I’ve been interested in zarr and using it in SQL w/o xarray for messing with geolibre things, cool to see. Also good to hear Motherduck taking the AWS news well, hopefully bodes well for the future of DuckDB.

131

Alejandro Wainzinger @xevix.bsky.social · 26/08/2026

Cautiously optimistic. Oracle got Sun and did good with Java, so who knows. Then again, AWS and open source. I guess time will tell.

110

Alejandro Wainzinger @xevix.bsky.social · 26/08/2026

DuckDB extension to add Hive data summary clause using the PEG tokenizer. Can't quite use the PEG grammar yet I think, but here's what it could look like when released. Going to be cool to see what people come up with when it's this easy to modify the grammar. github.com/xevix/duckdb...

000

Reposted by Alejandro Wainzinger

DuckDB @duckdb.org · 20/08/2026

Your database deserves a better parser (Don’t worry, #DuckDB v2.0 is giving you one) 🦆 🦆 Read more from @dtenwolde.bsky.social on how DuckDB v2.0 replaces its Postgres-derived SQL parser with a PEG-based parser that is easier to evolve and can be extended at runtime:

duckdb.org

DuckDB v2.0: Your Database Deserves a Better Parser

DuckDB v2.0 replaces its PostgreSQL-derived SQL parser with a PEG-based parser that is easier to evolve and can be extended at runtime.

0183

Reposted by Alejandro Wainzinger

Andy Pavlo @andypavlo.bsky.social · 13/08/2026

Our new version of dbdb.io tracks the commit history of open-source databases. We also track which coding agents are tagged in commits. Copilot has the most overall usage but Claude occurs in the most recent commits.

Histogram of the number of database systems that use an agent in at least one commit since 2022.

4353

Alejandro Wainzinger @xevix.bsky.social · 17/08/2026

Given all the other awesome work going on, going to try to push this forward for 2.1. I still think it's an awesome idea, but needs significant input/help and then rework. DuckLake is awesome, but significant amount of Hive datasets out there would benefit from this. github.com/duckdb/duckd...

github.com

Prune hive partition directories during glob by xevix · Pull Request #24385 · duckdb/duckdb

Supersedes #18518. Addresses part of #7620 for local filesystem. Many details have been greatly simplified compared to earlier attempts thanks to additions like the Pagination API. Thank you again ...

000

Alejandro Wainzinger @xevix.bsky.social · 17/08/2026

Massive wins in this upcoming release. PEG parser is going to enable all kinds of syntax extensions, async I/O is a huge performance win.

171

Reposted by Alejandro Wainzinger

Alejandro Wainzinger @xevix.bsky.social · 06/08/2026

Open sourced in case anyone finds it useful. Binary releases available. It's pretty barebones but should get the job done. github.com/xevix/duckparq

github.com

GitHub - xevix/duckparq: Parquet Viewer powered by DuckDB

Parquet Viewer powered by DuckDB. Contribute to xevix/duckparq development by creating an account on GitHub.

001

Alejandro Wainzinger @xevix.bsky.social · 02/08/2026

I wanted a parquet viewer like Tad but it hasn't been updated in a while. Not bad for a few hours vibecode in Opus 5. Swift, powered by DuckDB via C API. Supports modifying underlying SQL, seeing schema.

100

Reposted by Alejandro Wainzinger

DuckDB @duckdb.org · 31/07/2026

` Asynchronous I/O in #DuckDB: Work, Thread, Work ` It doesn't matter how fast query operators are in a database system if we can't pull in the data quickly. For most of DuckDB's history, this problem was largely avoided by pruning data early. As usual, things changed: duckdb.org/2026/07/31/a...

0224

Alejandro Wainzinger @xevix.bsky.social · 30/06/2026

Great to see temporal table support improved in Postgres. Still no built-in temporal querying e.g. AS OF, but at least no extensions needed now. SCD is hard, any tools that help are welcome. www.postgresql.org/docs/19/ddl-...

postgresql.org

5.7. Temporal Tables

5.7. Temporal Tables # 5.7.1. Application Time 5.7.2. System Time Temporal tables allow users to track different dimensions of history. Application …

000

Reposted by Alejandro Wainzinger

DuckDB @duckdb.org · 12/05/2026

Today we are revealing the Next Big Thing for DuckDB: Quack, a protocol that turns DuckDB into a client-server database. True to DuckDB's philosophy, Quack is simple and fast. Setting it up takes seconds, and it works for both bulk operations and small write transactions. 🔗 duckdb.org/quack

710012

Reposted by Alejandro Wainzinger

DuckDB @duckdb.org · 14/04/2026

Yesterday, we released DuckLake v1.0 and also published a podcast where Pedro Holanda and Mark Raasveldt talk about the DuckLake, going into quite some technical details. Listen to the episode at ducklake.select/media/duckla...

ducklake.select

DuckLake v1.0 – Developer Discussion

DuckLake is a SQL-as-a-lakehouse format that leverages your favorite SQL database (SQLite, PostgreSQL or DuckDB) to provide ACID transactions, schema evolution, and time travel for your data lake, wit...

0152

Reposted by Alejandro Wainzinger

DuckDB @duckdb.org · 20/03/2026

We're excited to announce duckdb-skills, a DuckDB plugin for Claude Code! We think the embedded nature of DuckDB makes it a perfect companion for Claude in your local workflows. Check out the repository at github.com/duckdb/duckd...

github.com

GitHub - duckdb/duckdb-skills

Contribute to duckdb/duckdb-skills development by creating an account on GitHub.

15414

Alejandro Wainzinger @xevix.bsky.social · 16/03/2026

DuckDB just casually in the nVidia keynote. AI doesn't make databases irrelevant, it makes them more relevant than ever.

072

Reposted by Alejandro Wainzinger

DuckDB @duckdb.org · 09/03/2026

We released DuckDB v1.5! This release comes with a “friendly CLI” client, a new (opt-in) PEG parser, support for VARIANT types and many lakehouse features. It also ships a new network stack, a reworked geospatial extension, Azure writes and an ODBC scanner. Read more at duckdb.org/2026/03/09/a...

06116

Alejandro Wainzinger @xevix.bsky.social · 08/02/2026

Good non-technical summary of some of the various chips out there. www.youtube.com/watch?v=RBmO...

youtube.com

How Nvidia GPUs Compare To Google’s And Amazon’s AI Chips

YouTube video by CNBC

000

Alejandro Wainzinger @xevix.bsky.social · 07/02/2026

Yeah, that or the opposite where it's biased toward a tool because of training data. I think you can suggest a tool in the global CLAUDEmd file but would be more seamless from cowork plugin.

000

Alejandro Wainzinger @xevix.bsky.social · 07/02/2026

Claude cowork w/ Opus 4.6 is definitely smart, but got stuck on a data task, I stopped it, pointed it to DuckDB, done instantly. LLMs still have much to learn 🤔

100

Alejandro Wainzinger @xevix.bsky.social · 07/02/2026

Great overview of chip manufacturing with EUV. We really do have supercomputers in our pockets, on our desk and on our wrists. www.youtube.com/watch?v=B248...

youtube.com

The $200M Machine that Prints Microchips: The EUV Photolithography System

YouTube video by Branch Education

000

Reposted by Alejandro Wainzinger

DuckDB @duckdb.org · 02/02/2026

🎞️ The slide decks and talk recordings of last Friday's developer meeting are out! duckdb.org/events/2026/...

0226

Alejandro Wainzinger @xevix.bsky.social · 23/01/2026

Great talks at South Bay Systems hosted at databricks on xNVMe, fast SSD query processing, and using NPUs for DB work. Much work using DuckDB extensions. Need for async I/O as bottleneck a common topic, mainly at larger scale. luma.com/8a54z94d?tk=...

010

Alejandro Wainzinger @xevix.bsky.social · 31/12/2025

GPU-powered analytical query engines going mainstream? Needs nVidia GPU and limited to memory for now, but neat use of Substrait+Arrow for interop. DuckDB still easier to run anywhere, but this is useful for acceleration if needed. developer.nvidia.com/blog/nvidia-...

developer.nvidia.com

NVIDIA CUDA-X Powers the New Sirius GPU Engine for DuckDB, Setting ClickBench Records | NVIDIA Technical Blog

Sirius, an open-source GPU native SQL engine, achieved a new performance record on Clickbench—a widely used analytics benchmark. Developed by University of Wisconsin-Madison with support from NVIDIA…

020

Reposted by Alejandro Wainzinger

DuckDB @duckdb.org · 31/10/2025

The PyData Amsterdam 2025 keynote “Minus Three Tier: Data Architecture Turned Upside Down” by @hannes.muehleisen.org is out now. www.youtube.com/watch?v=DxwD...

youtube.com

KEYNOTE: Hannes Mühleisen - Data Architecture Turned Upside Down | PyData Amsterdam 2025

YouTube video by PyData

1254

Reposted by Alejandro Wainzinger

Andy Pavlo @andypavlo.bsky.social · 03/11/2025

New database leaderboard from Yellowbrick ranks the quality of DBMS optimizer estimates and plans. They only evaluate TPC-H for now and report results for Postgres + DuckDB + MSSQL: sql-arena.com/components/p... Repo: github.com/sql-arena/db... LinkedIn Group: www.linkedin.com/groups/15775...

SQL Arena Planner Ranking (November 2025)

1143

Reposted by Alejandro Wainzinger

CMU Database Group @db.cs.cmu.edu · 20/10/2025

Today's Future Data Systems Seminar Speaker: Ian Cook (@ian.columnar.tech) will present @columnar.tech's work on Apache Arrow's database connectivity API (ADBC). ADBC is available in modern DBMSs. Zoom talk open to public at 4:30pm ET. YouTube video available after: db.cs.cmu.edu/events/futur...

db.cs.cmu.edu

[Future Data] Where We're Going, We Don't Need Rows: Columnar Data Connectivity with ADBC - Carnegie Mellon Database Group

ADBC (Arrow Database Connectivity) is Apache Arrow’s answer to ODBC and JDBC:... Read More +

0158