Release Notes

Readyset is currently released as a docker container and Linux distro binary packages. For installation with docker, see the Install with Docker documentation. Available Linux distribution binary packages for x86_64/amd64 include deb package for Ubuntu 22.04, Debian 12 and later, and rpm packages for Amazon Linux 2023 and RedHat 9. See package installation instructions.

What's New

• 54b5063: Use the intended collation for string-accumulating aggregation functions.
• f6bb7ca: Add support for the PostgreSQL string concatenation function string_agg().
• cc626a6: Ignore NULL values in accumulating aggregation functions such as group_concat().
• 0d21ebc: Add base support for the PostgreSQL accumulating aggregation function array_agg().
• 3bcc180: Support the DISTINCT keyword in accumulating aggregation operations.
• a68bb75: Handle ORDER BY clauses in accumulating aggregation functions.
• 75c8e97: Handle accumulation functions correctly in post-lookup aggregation operations.
• 9e21dfd: Add support for Bucket(timestamptz, interval), a Readyset-specific SQL function that assigns timestamps to fixed-interval buckets. Intervals use the format [positive integer] [unit] (where unit = seconds, minutes, hours, days, months, or years). This function is primarily intended for use in GROUP BY and aggregate queries to enable time series–style grouping, for example:
  SELECT Bucket(ts, '5 seconds') AS s5, SUM(data) FROM t GROUP BY s5;
• 3c90745: Add pre-snapshot verification checks to detect potential configuration issues earlier. The --verify flag can be used to run only the verification checks and then exit, while --verify-skip can be used to skip verification checks and continue normal startup.
• 1eddd77: Ensure EXPLAIN LAST STATEMENT reports the cache name when the query target is Readyset, whenever possible.
• 24f4d3e: Accept the ISO-8601 string timestamp separator in PostgreSQL (for both simple and extended query protocols).
• b86c373: Set the correct upstream database version during the new connection handshake for both MySQL and PostgreSQL.
• d2cf26a: Fix a potential deadlock occurring during index creation.
• c2d76ef: Properly escape backslashes in strings that are elements within an array.