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.
|
