This article explains the new support for SQL aggregations in Cloudflare's R2 SQL, which allows users to summarize large datasets effectively. It covers how to use aggregation queries, the importance of pre-aggregates, and introduces the concepts of scatter-gather and shuffling for efficient data processing.

This article explains how to deploy DuckDB as a WebAssembly module within Cloudflare Workers, enabling SQL queries without a traditional database server. It details the limitations of Cloudflare Workers, the use of Emscripten's Asyncify to handle asynchronous calls, and provides setup and coding instructions for creating a SQL query API.

The article provides an in-depth exploration of Cloudflare's R2 storage solution, particularly focusing on its SQL capabilities. It details the architecture, performance improvements, and integration with existing tools, highlighting how R2 aims to simplify data management for users. Additionally, it discusses the benefits of using R2 for developers and companies looking to optimize their cloud storage solutions.