As traffic spikes approach for the holiday season, we’ve rolled out new improvements to help you keep database performance fast and predictable. Here’s what’s new: 💬 Product Updates Readyset Core * Smarter Time-Series Aggregations: We introduced Bucket(timestamptz, interval), a Readyset-specific SQL function that groups timestamps into fixed intervals. It’s ideal for time-series queries like metrics rollups or activity heatmaps. This makes it easier to analyze trends over time without rest
Readyset
2025-11-04 · 2 min read
As traffic spikes approach for the holiday season, we’ve rolled out new improvements to help you keep database performance fast and predictable. Here’s what’s new:
Readyset Core
Bucket(timestamptz, interval), a Readyset-specific SQL function that groups timestamps into fixed intervals. It’s ideal for time-series queries like metrics rollups or activity heatmaps. This makes it easier to analyze trends over time without restructuring your queries or data.string_agg() function, enabling users to efficiently concatenate string values in grouped queries. This is particularly useful for generating comma-separated lists or compact summaries within SQL.group_concat() and array_agg()) now ignore NULL values and support the DISTINCT keyword, ensuring correctness and flexibility when summarizing grouped results.ORDER BY clauses inside aggregation functions are now correctly handled, allowing developers to control the order of concatenated or accumulated values. This is crucial for use cases like ordered logs, ranked lists, or other sequence-sensitive use cases.--verify to validate your setup proactively or skip checks with --verify-skip for advanced workflows.Check out the full release here.
Does Your Black Friday Database Scaling Strategy Involve Duct Tape and Prayers?
If your scaling plan relies on last-minute patches or extra hardware, this one’s for you. We explain why traditional strategies fall short during traffic spikes and how Readyset helps you survive Black Friday without the stress.
How Readyset Handles Window Functions Under the Hood
Window functions are powerful but tricky to support in a high-performance cache. This deep dive explains how we built support for ROW_NUMBER, RANK, and more while preserving Readyset’s speed and correctness.
We were thrilled to be part of this year’s MySQL Brazil Conference, where Marcelo co-organized the event and Tanmay and Bianchi presented the opening keynote Beyond Read Replicas: Introducing Readyset QueryPilot for MySQL Scaling.
Huge thanks to the organizers, speakers, and everyone who joined our session!
Big sale coming up? Don’t let your database be the reason customers can’t check out.
With Black Friday around the corner, join Tanmay and Bianchi to see how QueryPilot keeps performance predictable and databases stable without replicas, rewrites, or sleepless nights.
Register here for the webinar next Thursday 11/6.
Keen to use Readyset but your database or cloud environment are not supported? Reach out to support@readyset.io and let us know.
We love hearing from you! If you want to get involved with Readyset, you can:
Related articles
Continue reading more about uncategorized.
Readyset has always been about making database scaling effortless. Today, we’re extending that mission from the server to the developer’s terminal with rdst, a production-native, AI-powered CLI that helps teams write better queries, diagnose performance issues, and close the loop on caching, all before bad queries ever reach production. The Database Scaling Problem Is a Query Problem Every engineering team eventually hits the same wall: the database can’t keep up. Latency spikes. CPU climbs.
Why Query Rewriting Matters for Dataflow Most databases work the same way: a query arrives, the engine builds an execution plan, scans tables, joins rows, filters, aggregates, and returns the result. Every time the query runs, the work repeats from scratch. This pull-based model has served relational databases for decades, but it carries an inherent cost: read latency is proportional to the complexity of the query and the size of the data it touches. Readyset takes a fundamentally different ap
Vassili Zarouba
Most LLM-generated SQL doesn't fail. It runs and returns results, and that's exactly what makes it dangerous. The errors don't surface until they're already in your data. AI-assisted development has made it easier than ever to generate SQL quickly. The problem is that quick and correct are not the same thing, and with databases, the gap between the two has consequences that compound quietly over time. SQL that runs is not the same as SQL that works. LLMs are good at producing SQL that looks ri
Modern applications demand instant performance, even under unpredictable load. Readyset helps you eliminate slow queries, stabilize latency, and scale confidently.
Revolutionize your database performance with Readyset
Serve requests at sub-millisecond latencies with the modern database scaling and query caching system for MySQL and PostgreSQL.
Join our newsletter
Stay updated with the latest news, insights, and developments from Readyset — straight to your inbox.