Long time no see!

It has been more than a month since CloudQuery V1.2.1 was released, during which time we have received a lot of feedback and suggestions from our friends, many of whom expressed their expectations for CloudQuery V1.3.0. Thank you very much.

The new Version of CloudQuery was originally scheduled to go live on December 10th, but due to the additional requirements and higher standards we put on V1.3.0, the release has been delayed until today.

This function upgrades more, please prepare!

1. Statement collection function

  1. Support SQL statement collection, support for the collection of statements to define the name.

  1. You can view the execution statement, statement alias, update time and usage times in the collection management. Supports search for statements or aliases.

Add a PostgreSQL data source

  1. PostgreSQL data source versions 10 and 11 are supported.

  1. PostgreSQL Data source menu and result set editing function ① Data source menu includes: open table, delete table, truncate table, empty table, schema, view, function, dump SQL file, etc. Support PostgreSQL data source result set editing and export functions.

  1. Supports authorization management and application analysis of PostgreSQL data source application accounts.

  1. Supports terminal connections to PostgreSQL data sources.

3. Add dameng data source

  1. Supports Damont data source version 7.6 and 8.0.

  1. Supports dameng data source menu and result set editing functions. ① Data source menu functions include: open table, delete table, truncate table, empty table, schema, view, function, dump SQL file, etc. ② Support the function of editing and exporting result set of Dameng data source.

  1. Support the authorization management and application analysis of application account of Dameng data source.

  1. Supports terminal connection function of Dameng data source.

4. The rights management function has been upgraded comprehensively

  1. Added menu permission management functions, including adding connections, audit analysis, and system Settings. Users without authorization will not be able to see relevant buttons on the interface.

  1. Added the data operation permission management function. It can be detailed to a table, view, function group, and stored procedure in a specific database. It can also authorize user operations, such as view, DML, and DDL. It can restrict the permission of specified database elements.

  1. Add a permission set. Administrators can set a permission set to grant or revoke user rights efficiently and conveniently.

  1. Added ** minimum permission set function, ** minimum permission set is automatically generated with connection, automatically deleted with connection deletion, with the minimum public rights of the most basic role. A minimum permission set helps administrators quickly assign permissions to users.

5. The audit analysis function is completely revised

  1. Supports audit filtering on conditions such as statement types and execution results.

  1. Supports the audit export function to export audit details to Excel tables.

  1. Supports the Top SQL rankings. In application analysis, you can view the SQL execution counts of today, seven days, and all, as well as the SQL mode, latest execution time, execution host, average time, total time, and execution counts.

  1. Supports slow SQL ranking. This helps the administrator filter out SQL statements that take a long time on average.

  1. Audit the large-screen function. Audit and analyze the current day, seven days or all data, and display the total number of executions, number of incorrect statements, active users, proportion of executions, and execution rankings of users.

  1. SQL mode merging is supported and can be classified according to specific SQL categories. (More functionality will be added through SQL schema merging in the future)

  1. Support the function of displaying the jade Jue graph of database objects, where you can see the reading and writing times of today’s commonly used tables.

  1. Support for separate deployment of audit parts – V1.3.0 supports separate deployment of audit parts to another server, reducing the stress of a single server

Application of probe

  1. You can view the application name, ID, creator, DBA, detailed information about the deployed node, and status of the application and probe.

  1. Supports SQL capture and provides SQL statements for application audit, facilitating application audit analysis.
  2. SQL fetching is supported for MySQL, Oracle, SQL Server, and PostgreSQL. (More and more in the future)
  3. Supports Java application heartbeat detection.

Backup and restore

  1. Backup function: It backs up all user data and user data generated on CloudQuery to prevent accidents.

  1. Recovery: Data can be recovered on different CloudQuery nodes, but only of the same version.

These are the main content of CloudQuery V1.3.0, and there are many more small features and new experiences to discover!

CloudQuery v1.3.x todo list:

  1. Support nTU common database

  2. Application audit SQL schema coverage (currently only MySQL&Oracle) will be extended to all data sources

  3. Automatic probe installation and deployment

  4. Apply probes to cover more data sources

  5. SQL manual & automatic commit

  6. Submit & Undo buttons

  7. Personal folder

Finally, please visit cloudQuery. Club to experience it online or download CloudQuery V1.3.0. See you next time!