# Open Source Articles

> Our open source contributions to DuckDB, DataFusion, and dbt. Practical guides on reading codebases, writing tests, and getting patches merged.

Filter by Topic:

[All Posts (45)](/blog.md) [Engineering (31)](/blog/tag/engineering.md) [Architecture (21)](/blog/tag/architecture.md) [Performance (14)](/blog/tag/performance.md) [Product (13)](/blog/tag/product.md) [Altertable Agent (12)](/blog/tag/ai-agents.md) [Open Source (10)](/blog/tag/open-source.md) [Data Stack (9)](/blog/tag/data-stack.md) [Analytics (7)](/blog/tag/analytics.md) [AI (4)](/blog/tag/ai.md) [Culture (3)](/blog/tag/culture.md) [Generative UI (2)](/blog/tag/generative-ui.md) [Agents (2)](/blog/tag/agents.md) [Semantic Layer (2)](/blog/tag/semantic-layer.md) [Cousteau (1)](/blog/tag/cousteau.md) [MCP Apps (1)](/blog/tag/mcp-apps.md) [Agentic UI (1)](/blog/tag/agentic-ui.md) [Model Context Protocol (1)](/blog/tag/model-context-protocol.md) [Pricing (1)](/blog/tag/pricing.md)



Our open source contributions to DuckDB, DataFusion, and dbt. Practical guides on reading codebases, writing tests, and getting patches merged.

[![A Semantic Layer in DuckDB](/assets/blog/2026-11-02-semantic-layer-in-duckdb.jpg)](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[NOVEMBER 2ND, 2026](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[Sylvain Utard](/blog/2026-11-02-semantic-layer-in-duckdb.md)

## [A Semantic Layer in DuckDB](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[Engineering, Open Source, Semantic Layer, Analytics](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[A semantic layer inside DuckDB: define metrics once in SQL, and every query, from an analyst or an AI agent, gets the joins and aggregations right.](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[READ ARTICLE](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[![Local Decisions in DuckDB](/assets/blog/2026-10-29-local-decisions-in-duckdb.jpg)](/blog/2026-10-29-local-decisions-in-duckdb.md)

[OCTOBER 29TH, 2026](/blog/2026-10-29-local-decisions-in-duckdb.md)

[Sylvain Utard](/blog/2026-10-29-local-decisions-in-duckdb.md)

## [Local Decisions in DuckDB](/blog/2026-10-29-local-decisions-in-duckdb.md)

[Engineering, Open Source, AI, Analytics](/blog/2026-10-29-local-decisions-in-duckdb.md)

[Jev sparked a wave of decision models. We tried a compact open model inside DuckDB, routing support messages with SQL and checking its confident mistakes.](/blog/2026-10-29-local-decisions-in-duckdb.md)

[READ ARTICLE](/blog/2026-10-29-local-decisions-in-duckdb.md)

[![The Best Time to Go Deep](/assets/blog/2026-10-27-the-best-time-to-go-deep.jpg)](/blog/2026-10-27-the-best-time-to-go-deep.md)

[OCTOBER 27TH, 2026](/blog/2026-10-27-the-best-time-to-go-deep.md)

[Sylvain Utard](/blog/2026-10-27-the-best-time-to-go-deep.md)

## [The Best Time to Go Deep](/blog/2026-10-27-the-best-time-to-go-deep.md)

[Engineering, Performance, Open Source, Altertable Agent](/blog/2026-10-27-the-best-time-to-go-deep.md)

[Agents made systems iterations cheap: in three days we ported a concurrent B-tree to C++ for DuckDB. Expertise still decided what to chase.](/blog/2026-10-27-the-best-time-to-go-deep.md)

[READ ARTICLE](/blog/2026-10-27-the-best-time-to-go-deep.md)

[![Forecasting the AI Hype](/assets/blog/2026-10-26-forecasting-the-ai-hype.jpg)](/blog/2026-10-26-forecasting-the-ai-hype.md)

[OCTOBER 26TH, 2026](/blog/2026-10-26-forecasting-the-ai-hype.md)

[Sylvain Utard](/blog/2026-10-26-forecasting-the-ai-hype.md)

## [Forecasting the AI Hype](/blog/2026-10-26-forecasting-the-ai-hype.md)

[Engineering, Open Source, AI, Analytics](/blog/2026-10-26-forecasting-the-ai-hype.md)

[We classified a million Hacker News submissions with Jev and forecast daily AI chatter with Timestral in DuckDB, comparing all four model sizes.](/blog/2026-10-26-forecasting-the-ai-hype.md)

[READ ARTICLE](/blog/2026-10-26-forecasting-the-ai-hype.md)

[![Event Paths in DuckDB](/assets/blog/2026-09-17-journeys-in-duckdb.jpg)](/blog/2026-09-17-journeys-in-duckdb.md)

[SEPTEMBER 17TH, 2026](/blog/2026-09-17-journeys-in-duckdb.md)

[Sylvain Utard](/blog/2026-09-17-journeys-in-duckdb.md)

## [Event Paths in DuckDB](/blog/2026-09-17-journeys-in-duckdb.md)

[Performance, Engineering, Open Source, Analytics](/blog/2026-09-17-journeys-in-duckdb.md)

[Discover observed paths through event data with JOURNEYS, a native DuckDB operator for start-to-end routes including incomplete journeys.](/blog/2026-09-17-journeys-in-duckdb.md)

[READ ARTICLE](/blog/2026-09-17-journeys-in-duckdb.md)

[![Session Windows in DuckDB](/assets/blog/2026-09-01-session-windows-in-duckdb.jpg)](/blog/2026-09-01-session-windows-in-duckdb.md)

[SEPTEMBER 1ST, 2026](/blog/2026-09-01-session-windows-in-duckdb.md)

[Sylvain Utard](/blog/2026-09-01-session-windows-in-duckdb.md)

## [Session Windows in DuckDB](/blog/2026-09-01-session-windows-in-duckdb.md)

[Performance, Engineering, Open Source](/blog/2026-09-01-session-windows-in-duckdb.md)

[Session windows group events by inactivity gaps. DuckDB's SESSIONIZE clause runs 3.4× faster than equivalent window functions on 10 million rows.](/blog/2026-09-01-session-windows-in-duckdb.md)

[READ ARTICLE](/blog/2026-09-01-session-windows-in-duckdb.md)

[![MATCH\_RECOGNIZE That Scales](/assets/blog/2026-08-07-match-recognize-that-scales.jpg)](/blog/2026-08-07-match-recognize-that-scales.md)

[AUGUST 7TH, 2026](/blog/2026-08-07-match-recognize-that-scales.md)

[Sylvain Utard](/blog/2026-08-07-match-recognize-that-scales.md)

## [MATCH\_RECOGNIZE That Scales](/blog/2026-08-07-match-recognize-that-scales.md)

[Performance, Engineering, Open Source](/blog/2026-08-07-match-recognize-that-scales.md)

[Why funnels belong in MATCH\_RECOGNIZE, how active-run automata get expensive, and how our DuckDB extension stays fast against Trino.](/blog/2026-08-07-match-recognize-that-scales.md)

[READ ARTICLE](/blog/2026-08-07-match-recognize-that-scales.md)

[![Pruning Top-N Queries](/assets/blog/2026-02-03-pruning-top-n-queries.jpg)](/blog/2026-02-03-pruning-top-n-queries.md)

[FEBRUARY 3RD, 2026](/blog/2026-02-03-pruning-top-n-queries.md)

[Sylvain Utard](/blog/2026-02-03-pruning-top-n-queries.md)

## [Pruning Top-N Queries](/blog/2026-02-03-pruning-top-n-queries.md)

[Open Source, Performance, Architecture](/blog/2026-02-03-pruning-top-n-queries.md)

[A deep dive into DuckLake PR #668 and how Top-N dynamic filter pruning turns ORDER BY + LIMIT from full scans into metadata-driven execution.](/blog/2026-02-03-pruning-top-n-queries.md)

[READ ARTICLE](/blog/2026-02-03-pruning-top-n-queries.md)

[![From STDIO to OAuth](/assets/blog/2025-10-21-from-stdio-to-oauth.jpg)](/blog/2025-10-21-from-stdio-to-oauth.md)

[OCTOBER 21ST, 2025](/blog/2025-10-21-from-stdio-to-oauth.md)

[Sylvain Utard](/blog/2025-10-21-from-stdio-to-oauth.md)

## [From STDIO to OAuth](/blog/2025-10-21-from-stdio-to-oauth.md)

[Engineering, Open Source](/blog/2025-10-21-from-stdio-to-oauth.md)

[How MCP evolved from local stdio to OAuth 2.0 for cloud-scale AI, using Dynamic Client Registration for secure agent access.](/blog/2025-10-21-from-stdio-to-oauth.md)

[READ ARTICLE](/blog/2025-10-21-from-stdio-to-oauth.md)

[![Upstreaming with AI](/assets/blog/2025-09-23-upstreaming-with-ai.jpg)](/blog/2025-09-23-upstreaming-with-ai.md)

[SEPTEMBER 23RD, 2025](/blog/2025-09-23-upstreaming-with-ai.md)

[Sylvain Utard](/blog/2025-09-23-upstreaming-with-ai.md)

## [Upstreaming with AI](/blog/2025-09-23-upstreaming-with-ai.md)

[Open Source, Engineering, Altertable Agent](/blog/2025-09-23-upstreaming-with-ai.md)

[How we contributed 17 upstream PRs in 90 days—where AI accelerated our workflow, what we learned, and practical tips for open source success with AI assistance.](/blog/2025-09-23-upstreaming-with-ai.md)

[READ ARTICLE](/blog/2025-09-23-upstreaming-with-ai.md)

## Interested in learning more about Altertable?

[Start free](/sign-up)

[Web version](https://altertable.ai/blog/tag/open-source)
