Release Notes

Version 4.9 - November 28, 2024

Version 4.8 - October 06, 2024

  • Prepared statements are now supported by our Python and JDBC client drivers.

  • PIVOT and UNPIVOT.

  • Window funtion alias allows to specify a parameter within the window function definition. This eliminates the need to repeatedly input the same SQL code in queries that use multiple window functions with identical definitions.

  • CONCAT function concatenates one or more strings, or concatenates one or more binary values.

Version 4.7 - September 01, 2024

  • AWS private cloud deployment is now available for SQreamDB on AWS Marketplace.

  • Execute a single SQL statement across your SQreamDB cluster using the new Cross-Database syntax.

  • Safely cast data types with the new IsCastable function.

  • Automatically delete source files being copied into SQreamDB using the COPY FROM command.

Version 4.6 - August 20, 2024

  • You can now sign in to SQreamDB Studio using your universal Single Sign-On (SSO) provider authentication

  • Announcing a new Activity Report reflecting your storage and resource usage

  • Announcing a new Java-based cross-platform SQream SQL CLI

  • TOP clause enhancements

  • Saved Query command permission enhancements

Version 4.5 - December 5, 2023

  • Introducing a new Health-Check Monitor utility command empowers administrators to oversee the database’s health. This command serves as a valuable tool for monitoring, enabling administrators to assess and ensure the optimal health and performance of the database

  • A new Query Timeout session flag designed to identify queries that have exceeded a specified time limit. Once the flag value is reached, the query automatically stops

Version 4.4 - September 28, 2023

Version 4.3 - June 11, 2023

Version 4.2 - April 23, 2023

Version 4.1 - March 01, 2023

Version 4.0 - January 25, 2023