SQL

April 16, 2026

Deploy Postgres and MySQL databases with PlanetScale + Workers

Learn how to deploy PlanetScale Postgres and MySQL databases via Cloudflare and connect Cloudflare Workers.

December 18, 2025

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

Cloudflares R2 SQL, a distributed query engine, now supports aggregations. Explore how we built distributed GROUP BY execution, using scatter-gather and shuffling strategies to run analytics directly over your R2 Data Catalog.

September 25, 2025

R2 SQL: a deep dive into our new distributed query engine

R2 SQL provides a built-in, serverless way to run ad-hoc analytic queries against your R2 Data Catalog. This post dives deep under the Iceberg into how we built this distributed engine.

April 10, 2025

Sequential consistency without borders: how D1 implements global read replication

D1, Cloudflares managed SQL database, announces read replication beta. Here's a deep dive of the read replication implementation and how your queries can remain consistent across all regions.

April 8, 2025

Pools across the sea: how Hyperdrive speeds up access to databases and why were making it free

Hyperdrive, Cloudflare's global connection pooler, relies on some key innovations to make your database connections work. Let's dive deeper, in celebration of its availability for Free Plan customers.

January 27, 2025

Over 700 million events/second: How we make sense of too much data

Here we explain how we made our data pipeline scale to 700 million events per second while becoming more resilient than ever before. We share some math behind the approach and some of the designs.

October 25, 2024

Elephants in tunnels: how Hyperdrive connects to databases inside your VPC networks

Hyperdrive (Cloudflares globally distributed SQL connection pooler and cache) recently added support for directing database traffic from Workers across Cloudflare Tunnels.

June 28, 2024

Supporting Postgres Named Prepared Statements in Hyperdrive

Hyperdrive (Cloudflares globally distributed SQL connection pooler and cache) recently added support for Postgres protocol-level named prepared statements across pooled connections. We dive deep on what it took to add this feature

November 13, 2017

Thwarting the Tactics of the Equifax Attackers

We are now 3 months on from one of the biggest, most significant data breaches in history, but has it redefined people's awareness on security?

May 17, 2016

The Sleepy User Agent

From time to time a customer writes in and asks about certain requests that have been blocked by the CloudFlare WAF. Recently, a customer couldnt understand why it appeared that some simple GET requests for their homepage were listed as blocked in WAF analytics.

April 9, 2015

Scaling out PostgreSQL for CloudFlare Analytics using CitusDB

When I joined CloudFlare about 18 months ago, we had just started to build out our new Data Platform. At that point, the log processing and analytics pipeline built in the early days of the company had reached its limits.

October 16, 2014

Drupal 7 SA-CORE-2014-005 SQL Injection Protection

Yesterday the Drupal Security Team released a critical security patch for Drupal 7 that fixes a very serious SQL injection vulnerability.

July 8, 2013

Integrating Kyoto Tycoon With PostgreSQL

CloudFlare has Points of Presence (PoPs) in 23 datacenters around the world and plans to expand to many more soon. It also has a single portal, CloudFlare.com, where website owners interact with the system.

April 22, 2011

Ian Pye Presents SortaSQL @ the CloudFlare Loft

Last night CloudFlare hosted a Hybrid DB meetup where Ian Pye, our lead Analytics Engineer, presented on the data infrastructure at CloudFlare. He discussed how CloudFlare looked at several NoSQL and SQL solutions and ended up with a hybrid model, SortaSQL.