[MySQL] DB PowerStudio 19.2 added support for AWS authentication for MySQL for DBArtisan, Rapid SQL, and DB Change Manager. This option provides authentication without passwords through Identity and Access Management (IAM) authentication.
[Oracle] Updated Oracle support to versions 23ai and 26 for DBArtisan, Rapid SQL, and DB Change Manager, providing improved data protection, searches, and performance including support for:
Vector Data Type. A new native data type implemented specifically to store vector embeddings for AI similarity or semantic searches.
JSON Relational Duality Views. These objects allow data to be treated as both relational (tables) and JSON documents (document store) simultaneously without compromising data consistency, enabling developers to build APIs easily.
JSON Collection Tables. Tables designed to support NoSQL-style APIs (like MongoDB API) connecting to Oracle Database. MLE Environments. Helper entities used in Multi-Language Engine (MLE) to manage JavaScript modules, which are treated as schema objects.
Database Search Indexes (DBMS_SEARCH). A new feature that simplifies the creation of a single index across multiple tables or views, replacing the need for complex USER_DATASTORE procedures.
BOOLEAN Data Type. Native support for Boolean values (TRUE/FALSE/NULL) directly in tables, eliminating the need to simulate them with NUMBER(1) or VARCHAR2.
Staging Tables. A new variation of heap tables intended for faster data ingestion, created using the FOR STAGING clause.
修正
Updated log4j to 2.25.3.
[Oracle] Resolved an issue preventing some users from adding a user to the Tablespace Quota.
[PostgreSQL] Resolved an issue preventing all PostgreSQL database connections to appear by default.
[SQL Server] Resolved a Schema Comparison Job issue displaying Don't Match when comparing Tables with Primary Keys, but no differences are displayed.
Rapid SQL 19.1主要版本2026年4月15日
功能
Modernized the interface with a cleaner, more professional design. Refined UI elements make features easier to locate and workflows clearer to follow.
Updated Java to version 21.
修正
Resolved an issue causing incorrect tooltips to appear on some main menu items.
[Azure SQL DB] Updated the network connection selection to Microsoft Entra MFA.
[Oracle] Resolved an issue causing an error when running a Select query that includes binary_double fields containing NaN values.
[Sybase ASE] Resolved an issue preventing the system from saving changes or generating SQL when altering some values to "0" in Sybase ASE.