It’s been a busy month with lots of updates, let’s dive into them: Readyset Shallow Cache This month we introduced Readyset Shallow Cache, a new caching layer designed to expand Readyset’s query coverage. Readyset’s deep caching engine has always delivered sub-millisecond performance for operational queries that require ultra-low latency refresh. But many production databases serve a mix of operational and analytical queries from the same system. Shallow Cache complements Deep Cache by accel
Readyset
2026-03-06 · 3 min read
It’s been a busy month with lots of updates, let’s dive into them:
This month we introduced Readyset Shallow Cache, a new caching layer designed to expand Readyset’s query coverage. Readyset’s deep caching engine has always delivered sub-millisecond performance for operational queries that require ultra-low latency refresh. But many production databases serve a mix of operational and analytical queries from the same system. Shallow Cache complements Deep Cache by accelerating this broader set of query patterns with near 100% query support and zero ramp-up time.
Deep Cache handles mission-critical queries that require real-time freshness, while Shallow Cache optimizes the rest of your workload. You can read more about Readyset Shallow Cache here. If you’re interested in trying Shallow Cache on your workload, send us a note in our Slack community or reach out to hello@readyset.io.
Readyset Core
POLYGON type and improved handling of edge cases like POINT EMPTY, expanding Readyset’s caching support for geospatial queries.SHOW SHALLOW CACHE ENTRIES and SHOW PROXIED SHALLOW QUERIES to inspect cached entries, proxied queries, and associated performance metadata such as last accessed time, refresh time, and execution duration.@>, <@, and ||, improved array equality and type coercion, fixed constant-folding edge cases, and strengthened validation to reject incompatible array inputs earlier in query processing.PRIMARY or UNIQUE key is present, expanding compatibility with modern MySQL schemas.ALTER READYSET CHANGE UPSTREAM TO '...', eliminating the need to redeploy Readyset.Check out the full release here.
/brutal-review and the new 80/20 rule
“Good job” doesn’t make software production-ready. In this post, Michael pulls back the curtain on our internal review system and the 80/20 rule behind it: if LLMs help write the code, even more effort should go into stress-testing it. The focus isn’t on generating more output, it’s on adversarial review, deeper tests, and hardening changes before they ship.
MySQL 9.6: Foreign Key Cascade Operations Finally Hit the Binary Log
For years, MySQL handled foreign key cascades inside InnoDB, leaving them out of the binary log and invisible to replication and CDC pipelines. In this post, Marcelo explains what changed in MySQL 9.6, how it affects binlog correctness, and why it matters for systems like Readyset that consume change events in real time.
Replication Internals: Decoding the MySQL Binary Log - Part 1: Introduction and Data Types
Marcelo kicked off a new deep-dive series on MySQL replication internals, starting with a byte-level walkthrough of the binary log format. In Part 1, he breaks down the core data encodings MySQL uses, from little-endian integers to packed integers and TLV structures, laying the groundwork for manually decoding binlog events. If you’re interested in what goes under the hood of MySQL replication, this series is worth a follow.
Vibe Coding a High-Performance App with Readyset QueryPilot
What happens when you let AI build your application and then point it at QueryPilot? Vini put it to the test. In this post, he vibecodes a CRM with no schema changes, no query rewrites, and no manual optimization. He first runs it against MySQL directly, then puts QueryPilot in the path. QueryPilot automatically identifies and caches the right queries, improving performance for code generated exactly the way modern apps are being built.
Keen to use Readyset but your database or cloud environment is 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.