v2.0.0 is the release in which CYPEX becomes a multi-tenant PostgreSQL application platform. Tenancy is a first-class object (Organizations), isolation is enforced in the database (Row-Level Security), authorization is two-dimensional (Capabilities × Data Scope), schema exposure is explicit (Schema Access), identity can be federated (SSO Gateway), and outbound integrations are governed (allowlist, credentials, enablement, audit).

Warning

This is not a drop-in patch. v2.0.0 changes the permission and tenancy model. Read the Upgrade to v2.0.0 operator guide before planning a maintenance window, then the Upgrading to v2.0.0 technical reference for the database detail.

A CYPEX deployment can serve more than one tenant — an Organization — from the same PostgreSQL database. Isolation is enforced by Row-Level Security in the database, not by UI filtering.

v1.9.3 is a bug-fix release on the v1.9.x line. It ships the small set of fixes accumulated between v1.9.2 and the start of the v2.0.0 work, and is the recommended last stop on the v1.9.x line for deployments that are not yet ready to upgrade to v2.0.0.

• Hotfix roll-up of the fixes accumulated after v1.9.2. The multi-tenancy and password-policy changes are not part of this release; they ship in v2.0.0.

v1.9.3 is a drop-in replacement for v1.9.2: no schema changes, no permission changes, no behavior changes. Apply the upgrade during a normal maintenance window using the standard Migration guide.

• New Input Elements:

  • Code Field: New code input element for code editing
  • Radio Button Input: Added radio button input element for single-choice selections
  • Interval Input: Enhanced interval data type support across the platform

• UI Components & Layout:

  • Icon Element: Configurable icon element with customization options
  • Background Image Support: Added background image configuration for UI pages
  • Configurable Default Container: Enhanced default container with adjustable configuration
  • Modal Button Configuration: Added hidden state and size settings to modal buttons
  • Enhanced Conditional Container: Added toggle functionality to conditional containers

• Data Visualization & Charts:

• PDF Reporting:

  • Added a new page type for reports, allowing users to generate PDFs directly from the application

  • Introduced Interactive and Static PDF Report Generation with LaTeX support for structured reports.

• Application Management & Usability:

  • Merge Applications: Admins can now merge multiple applications built for the same user role using the Published Release or the Last Save Point, enhancing team collaboration and feature integration.

• Add the ability to set admin roles & others.
• Configure JWT token expiration.
• See Application owner on edit App page.
• List materialized views in the database overview.

• Several fixes on Create Queries.
• Translation fixes.
• UI fixes.
• Upate Application repository default Token.
• PGRST reload schema event on DDL Actions.
• UI Editor: fix error when removing all actions from a table.

• User-Friendly Geo JSON Editor: introducing a new, user-friendly Geo JSON editor that simplifies the process of editing and managing Geo JSON data.

• Custom Expression Editor: Added a custom expression editor that is now expanded in a modal window, enhancing the user experience by providing a more spacious and focused environment for creating and managing expressions.

• Workflows Enhancements: Implemented Swagger (SWG) and LaTeX endpoints for improved API documentation and reporting capabilities.

• Application Configuration:

  • Added functionality for changing the application logo, enhancing brand customization.

  • Introduced the ability to set the uploaded file name within the Admin panel, streamlining file management.

  • Enabled support for SSL connections, ensuring secure data transmission.

• User Interface Improvements:

• Ability to drag&drop query into the query group.

• Application creation: query selection tree and query description.

• Demo data for CYPEX trial version.

• Enable/disable autocomplete element via custom expression.

• Fix current_user and current_role functions to work also in old PostgreSQL versions.

• Backend Refactor.

• Added translation to the Query group.

• Enhanced Workflow UI.

• Button to create a new record moved to a default table config.

• Resolved bugs impacting Workflow transitions.

• Copy table element bug.

• Admin Panel - broken Query filter.

• Fixed function to create all possible custom queries if no query has been created.