← Tuesday, October 6, 2026DatabasesCase study

A Java table function moved analytics data from MongoDB into DuckDB

duckdb.org by Guest Author, Geertjan Wielenga, Alex Kasko 11 min read Editor score 7/10

After MongoDB-backed analytics and exports slowed, the team moved a year of data into DuckDB and shipped a table function written in Java. The account compares ingestion approaches for engineers weighing analytical workloads alongside operational databases.

What: A team moved a year of vulnerability records from MongoDB into DuckDB on the same server for analytics.
How: After exploring import options, the team chose a table function written in pure Java; an initial MongoDB extension import took 55 seconds on the sample dataset.
Why it matters: The target was analytical queries in one second or less and Excel exports of 50,000 records in under ten seconds.

The Java table function moves data from MongoDB into DuckDB for analytics. Sketched from the article's own text.

Read on duckdb.org →

Discussion

Discussion is not switched on yet. Use Note above to keep your own thoughts on this story.

Headline, summary, brief and diagram are written by a model from the source's own text; the link, byline and numbers come from the source. Read the original before relying on a claim.