Skip to main content

5.14 Release notes

Upgrade guides​

5.14.1 Patch notes​

Release date

Cinchy v5.14.1 was released on February 12, 2025.

Resolved issues​

  • The clipboard operations issue affecting Cinchy v5.13.1, v5.13.2, and v5.14 has been resolved.
  • Pivot tables created from Cinchy queries will be displayed.

Bug fixes​

  • The 'Query Parameters' tool tip in the Connections UI contains a functional example.

5.14 Release notes​

Release date

Cinchy v5.14.0 was released on January 31, 2025.

Important changes​

Log level​

The default log level is now Warning.

caution

Review your deployment to ensure that the appropriate log level is configured:

  • Trace should never be enabled in a production environment.
  • Debug may be used occasionally, with caution, due to the high volume.
  • Information may be used to track the general flow of the app.
  • Warning is recommended, to highlight abnormal or unexpected events.

Date handling​

Dates are transmitted using the ISO 8601 standard. This enables millisecond precision support for custom format date columns, i.e. YYYY-MM-DD HH:mm:ss.SSSSSS.

info

Though commonly used code libraries typically support ISO 8601, applications consuming Cinchy Query APIs should be validated to ensure compatibility.

Personal Access Tokens​

Personal Access Tokens created in Cinchy v5.14.0 or later no longer expire prematurely, and may be valid for up to one year. Pre-existing tokens may still expire earlier than intended; these can be replaced to mitigate the impact.

Chiseled images​

The IDP and Web components are built using chiseled container images, with numerous benefits including size, security and vendor support. Since these base images, which are suitable for Cinchy's core components, do not contains shells or package managers, they present an extremely small attack surface. To debug such images, see Docker Debug or Kubernetes debugging with an ephemeral debug container.

Postgres connection string​

This change pertains to Postgres connection strings, whether Cinchy's primary data store or user-defined connections sources or targets. SSL Mode=Require no longer validates certificates, it simply means that SSL/TLS is required. Should you wish to validate certificates, use SSL Mode=VerifyCA or VerifyFull in order to validate certificates provided by PostgreSQL. Further details available in the Npgsql release notes.

Known issues​

Clipboard Functionality in Chrome 133​

Following the Chrome 133 release on February 4, 2025, clipboard operations (copy & paste) in Cinchy versions 5.13.1, 5.13.2, and 5.14.0 have stopped functioning.

Workarounds

  • Downgrade Chrome browser to version 132.
  • Use a version of Cinchy that is not impacted, such as 5.14.1.

Pivot Tables​

Pivot tables created from Cinchy queries are failing to display in the UI.

New features​

API rate limiting​

Where queries are made available programmatically (query type API), limits can be applied to the API. These constrain how many calls may be made at any moment, or in a given time window. This provides a mechanism to manage resource allocation, so that other queries are not starved due to excessive usage. Further details available in the Rate Limiting documentation.

Batch query capability​

For Cinchy Event Broker/CDC real-time syncs, queries can be configured to run per batch instead of per event. This reduces overhead, and improves performance for syncs that can take advantage of this capability. Further details available in the Run Query documentation.

Enhancements​

  • Improved performance for data syncs that include link columns.
  • Angular 18 is now supported for building experiences.

Bug fixes​

  • Read-only users can no longer cancel change approval requests.
  • Removed invalid Feature-Policy that was causing (harmless) errors in the browser Console log.
  • Removed duplicate Content-Security-Policy policy that was causing (harmless) errors in the browser Console log.
  • The Query Editor applies the user-specified timeout correctly, so that longer running queries can be successfully executed.
  • Completed data sync jobs no longer show as 'Running' in the Execution Log.
  • The IDP component correctly applies logging configuration.