November Product Update

2 min read

•

about 1 month ago

As we sled our way into the holiday season, here’s what’s new at Readyset:

💬 Product Updates

Readyset Core

  • Smarter Table Renames: Readyset now detects RENAME TABLE and ALTER TABLE ... RENAME TO operations and automatically re-snapshots the affected tables, maintaining cache consistency even as schemas change.
  • PostgreSQL Array Support: We added support for PostgreSQL-style array constructor syntax, improving compatibility with modern Postgres applications and enabling more expressive queries through native array handling.
  • Dynamic Memory Tuning: You can now adjust eviction memory limits and periods on the fly using ALTER READYSET SET EVICTION, giving teams more flexibility to fine-tune cache eviction behavior in live environments.
  • Visualize the Replay Graph: The new SHOW REPLAY PATHS command provides detailed visibility into how queries are replayed and evicted in the internal dataflow graph, empowering deeper debugging and performance tuning.
  • CREATE TABLE AS SELECT Now Supported: Readyset can now replicate MySQL tables created with CREATE TABLE ... AS SELECT, expanding compatibility with common workflows in MySQL-heavy environments.
  • Query Sampler Now Enabled by Default: We enabled the query sampler with a default 1% sampling rate. This helps automatically detect mismatches between Readyset and upstream databases, before they impact production.
  • More Powerful SQL Expressions in Joins: We’ve expanded support for computed expressions in JOIN ON conditions. Expressions like ON length(col) < 10 are now valid when they reference a single table, giving developers more flexibility in join logic.
  • And more!

Check out the full release here. 

🆕 New on the Blog & YouTube

Readyset Adds New Query Capabilities With the Bucket Function

This month we introduced Bucket, Readyset’s first built-in function not available in upstream databases. Bucket groups time-based data into fixed intervals and lets Readyset maintain those aggregates in memory for instant reads. In an NYC Taxi demo with 134 million rows, a query that took 20.46 seconds in PostgreSQL returned in 5.6 milliseconds through Readyset, nearly 365× faster, while staying fresh under heavy updates. Bucket gives you time-series-style performance without new infrastructure, extending what your relational database can do with zero changes.

How Readyset QueryPilot Scales MySQL in Minutes

At MySQL Conf BR, Bianchi broke down how Readyset delivers always-fresh, always-consistent caching without TTLs or invalidation. His live demo shows Readyset running as a drop-in MySQL proxy, keeping cache freshness within sub-millisecond of writes and lifting a real customer dashboard from single-digit QPS to tens of thousands.

How QueryPilot Supercharges Vibe-Coded Apps

In this short demo, Tanmay points an AI-generated app at QueryPilot and shows queries that once took 30 seconds drop to under a second. He then adds a new AI-generated endpoint with SQL produced entirely by the model and no manual cache keys, and QueryPilot automatically caches and optimizes it as well. It is performance that keeps pace with how you build, even when your backend logic is evolving faster than you can follow it.

🦃 November Event Recap

A Better Way to Handle Black Friday Traffic Than Duct Tape and Prayers

Tanmay and Bianchi hosted a webinar this month on how QueryPilot helps database teams solve their Black Friday problems instead of scaling them. If you’re feeling the pain of holiday traffic this year, you can check out the full webinar here.

🧑‍💻 Request Features

Keen to use Readyset but your database or cloud environment are not supported? Reach out to support@readyset.io and let us know.

🤝 Get Involved

We love hearing from you! If you want to get involved with Readyset, you can:

Authors

R

Readyset