Hello, community friends, long time no see! After more than a month of hard work, CloudQuery V1.4.0 is finally available!

New features in V1.4.0 include the Scheduling Center module, DTS (Database Tools Service) data export, visual query builder, and Hive data sources.

As always, version updates indicate new features to begin with. Today we are going to talk about the front end students are proud of the query Tab page interaction optimization ~

First, query Tab Tab optimization

1. Open the library table query, Tab Tab shows the connection icon and the current library name, multi-tab when you want to use which workspace will know the Tab

2. The Tab Tab moves with the library, and the Tab content switches synchronously when cutting the library

2. Add Hive data source

1. Support to connect to Hive data source version 2.3.3

(2) Support Hive right click menu, including functions: open table, view table structure, delete table, add table, trundle table, design table and rename table, etc

3.Hive data sources include access control and audit analysis

3. Add “dispatch center” module

In V1.4 planning, we introduced the concept of DTS (Database Tools Service), and added the “scheduling center” module. V1.4.0 supports two data export tools: MySQL, MySQLDump and Oracle EXP.

1. Dump Export of Database Objects (Dump Export of Database Objects

② Oracle multi-database DMP export, same database/different database multi-table DMP export

2. Support custom export parameters

3. The task list shows the running status and time of tasks

4. Support to terminate running tasks

5. You can view the real-time log in the task details and download the exported results

6. In MySQL/Oracle connection management, configure the DTS tool access for the connection

Visual Query Builder

1. Drag and drop to create a linked table query, one drag, a row, a select, quickly generate query statement 2. Support common statement structures such as SELECT, FROM, WHERE, GROUP BY, HAVING, AND ORDER BY 3. Real-time SQL preview, change charts, edit table models, and change statements 4. Support detailed operations such as aggregation function 5. Generated statements are filled in the editor, and can be further edited and executed 6. Currently only Oracle is supported

https://www.bilibili.com/vide…

Five, the installation mode adjustment

2. Offline: Offline download is transferred to Texion Cloud Storage, and download is accelerated

VI. Repair and optimization

Fixed:

  • Fixed an issue where columns with periods in result sets could not be displayed
  • Fixed a magic issue where the number of exported rows in the result set exceeded 50,000 and the actual exported rows became 1.5 times
  • Fixed an issue where the execution button would flash without a follow-up or prompt when executing a very long statement
  • Fixed failure to export more than 65535 audit records
  • Fixed an issue where departments could not create groups with the same name in the organizational schema
  • Fixed an issue where PostgreSQL could not add tables
  • Fixed a variety of data source design table function anomalies
  • Fixed an issue where the second rendering of the result set failed

Optimization:

  • New interaction: SDT double-click the database hierarchy to create a new query Now, the query window tag name reflects the connection type and the library currently in use
  • Double-click to open the table, and all the data sources have added the 1000 row limit
  • The established database connection is now automatically disconnected when the user exits
  • The file name of the download center list is the same as the file name of the download
  • Provide a clearer explanation of why the export failed
  • Changing password related error prompts is more friendly
  • Now, the organization can change the group name
  • Adjusted the page visual proportion, fixed some style bugs
  • Optimized log output to no longer produce server log files in G
  • Other page styles and interaction optimizations

Special thanks to

Thanks to @rafeng_zhang and @dreambeer students for their feedback! CloudQuery is still growing, and we value every user’s experience. We encourage you to ask questions and suggestions to help us build CloudQuery!

Community public announcement

We encourage students who have experienced the new version to fill in the experience report on the official website, and CloudQuery will adjust the iteration plan according to your suggestions. As long as you dare to write, we dare to do!

New version experience report address:https://cloudquery.club/quest…

That’s all for this update.

At the end

CloudQuery download the update address: https://cloudquery.club/download

CloudQuery online trial: https://cloudquery.club/

In addition, we will meetAt 20:00 on July 6thLive on the ink wheel. We will share our vision for the next generation of database management platforms and detail the new features of CloudQuery V1.4.Students who participate in the interaction have more chances to get CloudQuery gifts and red envelopes!Welcome everyone to watch ~