Announcing support for GROUP BY, SUM, and other aggregation queries in R2 SQL

When you’re dealing with large amounts of data, it’s helpful to get a quick overview — which is exactly what aggregations provide in SQL. Aggregations, known as “GROUP BY queries”, provide a bird’s eye view, so you can quickly gain insights from vast volumes of data.

That’s why we are excited to announce support for aggregations in R2 SQL, Cloudflare's serverless, distributed, analytics query engine, which is capable of running SQL queries over data stored in R2 Data Catalog. Aggregations will allow users of R2 SQL to spot important trends and changes in the data, generate reports and find anomalies in logs.

This release builds on the already supported filter queries, which are foundational for analytical workloads, and allow users to find needles in haystacks of Apache Parquet files.

In this post, we’ll unpack the utility and quirks of aggregations, and then dive into how we extended R2 SQL to support running such queries over vast amounts of data stored in R2 Data Catalog.

The importance of aggregations in analytics

Aggregations, or “GROUP BY queries”, generate a short summary of the underlying data.

A common use case for aggregations is generating reports. Consider a table called “sales”, which contains Continue reading

D2DO290: AI’s Impact on Developer Productivity Vs. Development Productivity

Ned Bellavance and Kyler Middleton are joined by Rachel Stephens, Research Director at RedMonk, to discuss the state of DevOps and the impact of AI. They explore the distinction between developer productivity and development productivity, underlined by a DORA report finding that while AI dramatically boosts individual developer productivity, it often fails to improve overall... Read more »

Nvidia Is The Only AI Model Maker That Can Afford To Give It Away

An alien flying in from space aboard a comet would look down on Earth and see that there is this highly influential and famous software company called Nvidia that just so happens to have a massively complex and ridiculously profitable hardware business running a collection of proprietary and open source software that about three quarters of its approximately 40,000 employees create. …

Nvidia Is The Only AI Model Maker That Can Afford To Give It Away was written by Timothy Prickett Morgan at The Next Platform.

Worth Reading 121725


Tensor processing units (TPUs) are specially designed AI accelerators. They are a type of application-specific integrated circuit (ASIC), or chips designed for specific tasks. For TPUs, that task is running and optimizing AI and machine learning (ML) workflows, including training and inference.


Civil unrest can often cloud measurement data. Some measurement systems, including ours, make relatively sweeping assumptions about the stability of both end user and network service behaviours, and assume that the changes that occur from day-to-day are minor.


Identifying active IPv6 addresses is challenging. Various methods emerged to master the measurement challenge in this huge address space, including hitlists, new probing techniques, and AI-generated target lists. In this paper, we apply active Subnet-Router anycast (SRA) probing, a commonly unused method to explore the IPv6 address space.


Several months ago, I arrived at the office at 8:45 a.m., sat at my desk, and was about to start my day. The only problem was that I, for the life of me, could not remember my password. This is a bit laughable because for the past year, I had typed that exact password almost daily, sometimes from muscle memory.


Vaibhav Kakkar once tested a therapy chatbot to help with Continue reading

NAN109: Simplify Your Network Operations with Extreme (Sponsored)

Today Eric Chou dives deep into network automation and operational simplicity with guest Hardik Ajmera, VP of Product Management at Extreme Networks. In this sponsored episode, they talk about the ‘network fabric’, Extreme Platform ONE, and, of course, what’s next with AI in the world of enterprise networking. Hardik also shares how customers in complex... Read more »

Negara dengan Bandara Terbanyak di Dunia: Rahasia di Balik Angka Amerika Serikat

Siapa yang menjadi raja di langit? Bicara soal transportasi udara, satu nama langsung muncul. Ya, Amerika Serikat adalah negara dengan airport terbanyak di dunia. Jumlahnya sangat fantastis dan jauh meninggalkan negara lain. Fenomena ini bukan sekadar angka. Ia mencerminkan geografi, ekonomi, dan budaya yang unik. Mari kita bedah lebih dalam.

Amerika Serikat: Raja Langit dengan Jumlah Bandara Menakjubkan

Amerika Serikat memimpin daftar global dengan jumlah total bandara yang mencengangkan. Menurut data dari FAA atau Federal Aviation Administration, ada lebih dari 19.000 bandara. Angka ini termasuk berbagai jenis fasilitas. Tentu saja, tidak semua bandara sebesar JFK atau LAX. Sebagian besar adalah fasilitas kecil. Namun, semuanya berkontribusi pada infrastruktur penerbangan yang masif.

FAA membagi bandara menjadi dua kategori utama. Pertama adalah bandara umum. Kedua adalah bandara swasta. Bandara umum tersedia untuk penggunaan publik. Sementara itu, bandara swasta hanya untuk pemiliknya. Kombinasi kedualah yang menciptakan angka yang sangat besar. Selain itu, budaya penerbangan umum di AS sangat kuat. Banyak individu dan perusahaan memiliki pesawat pribadi. Akibatnya, kebutuhan akan landai pacu pribadi pun melonjak.

Mengapa Jumlah Bandara di Continue reading

Ingress NGINX Controller Is Dead — Should You Move to Gateway API?

Now What? Understanding the Impact of the Ingress NGINX Deprecation

Ingress NGINX Controller, the trusty staple of countless platform engineering toolkits, is about to be put out to pasture. This news was announced by the Kubernetes community recently, and very quickly circulated throughout the cloud-native space. It’s big news for any platform team that currently uses the NGINX Controller because, as of March 26, 2026, there will be no more bug fixes, no more critical vulnerability patches and no more enhancements when Kubernetes continues to release new versions.

If you’re feeling ambushed, you’re not alone. For many teams, this isn’t just an inconvenient roadmap update, its unexpected news that now puts long-term traffic management decisions front and center. You know you need to migrate yesterday but the best path forward can be a confusing labyrinth of platforms and unfamiliar tools. Questions you might ask yourself:

❓Do you find a quick drop-in Ingress replacement?

❓Does moving to Gateway API make sense and can you commit enough resources to do a full migration?

❓If you decide on Gateway API then what is the best option for a smooth transition?

With Ingress NGINX on the way out, platform teams are standing at a Continue reading

PP091: News Roundup–Securing MCP, Hunting Backdoors, and Getting the Creeps From AI Kids’ Toys

Our final news roundup for 2025 is a holiday sampler of tasty, chewy (and a few yucky) confections. We look at a years-long exploit campaign that used browser extensions to steal credentials, inject malicious content, and track behavior; tracks ongoing exploits using the React2Shell vulnerability; and debates whether a surveillance camera maker’s pledge to follow... Read more »

How Sustainable Is This Crazy Server Spending?

We can all talk until we are blue in the face about how weird it is for so much money to be spent on servers during the GenAI boom, but after reviewing the latest market report from IDC – which is one again but sporadically giving out some stats to the public – we thought that to feel the full impact of this change, we should draw you a picture of the past 26 years of server revenues by quarter so you can take it all in. …

How Sustainable Is This Crazy Server Spending? was written by Timothy Prickett Morgan at The Next Platform.

What Do You Do When You Want GPFS On The Cloud?

While there are a lot of different file system and object storage options available for HPC and AI customers, many AI organizations and a lot of traditional HPC simulation and modeling centers choose either the open source Lustre parallel file system or the modern variants of IBM’s General Parallel File System (GPFS), known previously as Spectrum Scale and now known as IBM Storage Scale, as the storage underpinning of their applications. …

What Do You Do When You Want GPFS On The Cloud? was written by Timothy Prickett Morgan at The Next Platform.

1 … 18 19 20 21 22 … 3,852