What's new|V4.1.0|OceanBase Developer Center|ODC docs|Distributed Database

What's new

Last Updated：2023-09-05 07:40:36 Updated

OceanBase Developer Center (ODC) V4.1.0 released in January 2023 adds the SQL check and automatic running. This latest version also optimizes features such as connection management, permissions management, SQL window, table object management, import and export, and UI interaction.

Updated modules and features

Feature	Module	Description
SQL check	SQL window Database change tasks Create a table	SQL specification check is supported when you edit SQL statements in the SQL window, create database change tasks, and create tables.
Automatic running	SQL plan task	SQL plan tasks are supported. ODC can periodically execute SQL scripts created by users to complete database development and O&M tasks as required by the users.
Permissions management	Automatic authorization rules Manage public connections Manage roles	Automatic authorization rules are added. The administrator of the public resource console can automatically authorize specific roles or permissions to users that meet specified conditions when they log on for the first time or when they are created, which avoids redundant authorization. For example, automatic authorization can be performed for users whose name, organization or department, or logon method meets specified judgment conditions. Permission management for public connection lists in the public resource console is supported. Configure resource management and system operation permissions for roles in the public resource console are supported.
Interaction upgrade	ODC homepage SQL window Manage tasks	The layout on the homepage is upgraded. The Don't Remind Me Again button is added to the pop-up window for dragging objects. The latest settings of the period for task display can be saved in the Task Center panel.
Connection management	Create a private connection Manage public connections	SSL encryption is supported. The query timeout period is no longer set. You can dynamically change the query timeout settings in the SQL window.
SQL window	SQL window	In manual commit mode, the Commit or Rollback button is displayed based on whether any transaction is not committed for ODC V4.0.0 and later versions. You can set the query timeout through the session variable `ob_query_timeout` and there is no timeout limit. You can save SQL scripts by using the Ctrl+S or Ctrl+D shortcut. Supports the display of rare characters that are common in names, and non-national standard coded characters are displayed in code-displaying fonts. The prompt of the execution result of the `TRUNCATE TABLE` statement is optimized. The number of affected data rows is no longer displayed for `SELECT` and `TRUNCATE TABLE` on the logs tab. The Execute SQL metric in the database time consumption part of an execution record is optimized. The accurate time consumed is displayed. The result set is optimized in the following aspects: You can press Shift to select multiple rows in a column. The editable range of the result set is enhanced. If a multi-table join query contains the row ID of a table, the result set is also editable.
Table object management	Manage table attributes Manage table data	On the attributes tab of a table, you can view the table statistics, including the number of rows and data size of the table.
Import and export	Batch export and import	Some dependencies on the sys account are removed when table schemas are exported. When you export data by using the client ODC, you can directly export backup files to local directories. During import or export, you can select Retain Current Configuration to save the current configuration as the default configuration.

OceanBase

Customer Stories

Documentation

What's new

Updated modules and features