2024.03.4

DataCap 发布！

发布版本	发布时间
2024.03.4	2024-05-19

主要功能

---

• 移除 stale ci
• 修复聊天对话框文本过多导致样式混乱的问题
• 添加数据库、表、列补全符
• 修复了单词未设置为编辑器的问题
• 更新 openai-java-sdk 版本
• 支持显示查询错误信息
• 支持即席查询可视化

用户界面

---

• 修复查看SQL时使用ESC导致页面异常的问题

数据集

---

• 修复虚拟列无法构建
• 修复临时查询不传递列类型的问题
• 支持根据表达式生成别名
• 更换头像

可视化

• 添加玫瑰图

MongoDB

---

• 支持多数据源

文件系统

---

• 支持 aliyun oss
• 将 fs 存储实验功能标记为正式功能

2024.03.3

DataCap released!

Release version	Release time
2024.03.3	2024-04-19

Core

---

• [User] Support upload avatar
• [Source] Remove v1 saveAndUpdate, getInfo fc
• [Source] Replace getSource fc
• [Source] Add code and name column
• [Source] Refactor metadata layout
• [Source] Add database info to metadata
• [Function] Fix error when converting undefined attribute in info
• [Query] Remove old api
• [Query] Fixed history data is null
• [Snippet] Adapter base module
• [Pipeline] Adapter base module
• [Dashboard] Optimize the way to obtain the dashboard
• [Dashboard] Add description
• [Dashboard] Add default image
• Remove schema to configure
• Enable unified BaseEntity, BaseRepository, BaseController, BaseService
• Support saveOrUpdate method to set related values based on attributes
• Add info by code permission

UI

---

• [Layout] Optimize menu selection and highlight display
• [Layout] Support parent menu selection highlighting display
• [Layout] Add callback to 404 page
• [Layout] Add redirect to 403 page
• [Layout] Add redirect to network page
• [User] Fix loading status
• Add page loading progress
• Remove echarts
• Merge i18n

Dataset

---

• Fix the problem of missing columns in data set construction
• Fixed info path
• Optimize query column transmission data problem that is too large
• Add permission to get columns
• Highlight indicator dimension container
• Replace id to code

Visual

• [Line] Add title to line
• Remove unused component
• Merge configuration into editor
• Fix the problem that the configuration is not echoed
• Remove unused configure component
• Disable visualization without querying
• Add scatter chart
• Add radar chart
• Add funnel chart
• Add gauge chart

Docker

---

• Replace schema path
• Repair docker compose image and change example address

2024.03.2

DataCap released!

Release version	Release time
2024.03.2	2024-04-12

Emergency release version: Due to an error in calling the API during pre-release testing, the data set building function cannot be used. This version is mainly used to modify the data set building function.

Env

---

• Fixed logo path reference error problem

Dataset

---

• Fixed the problem that the data set cannot be constructed

Docker

---

• Fixed the problem of missing fields in initialization script

2024.03.1

DataCap released!

Release version	Release time
2024.03.1	2024-04-11

In this version update, we mainly restructured the UI

Core

---

• Fixed dependency package import error
• [Report] Fixed the problem of jumping to the report list after publishing the report
• [Dashboard] supports displaying report names
• [Dashboard] Fixed the problem of missing lower right border of the report
• [Dashboard] Fixed the issue of error when modifying jump

UI

---

• Refactor UI to shadcn ui

Pipeline

---

• Removed old build functionality
• Supports specifying startup scripts

DataSet

---

• Fixed the problem of table creation failure due to not configuring the life cycle column
• Build failure prohibits ad hoc querying
• Combine ad hoc query grouping into dimensions
• Fix calculation of total rows and total size

File System

---

• Support delete function

Executor

---

• [Seatunnel] supports flink engine
• [Seatunnel] supports seatunnel engine

Dependencies

---

• Update testcontainers.version 1.17.6 to 1.19.5
• Update com.datastax.oss:java-driver-core 4.16.0 to 4.17.0

2024.02.1

DataCap Released!

Release Version	Published
2024.02.1	2024-03-01

Plugin

---

• ParadeDB support (#589)
• Support for TimescaleDB (#593)

DataSet

---

• [Chart] Add Area Chart (#611)
• [Chart] Add Multi-Area Chart (#610)
• [Chart] Add a pie chart (#613)
• [Charts] Support line chart breakpoint processing
• [Chart] Grouping Histogram (#612)
• [Chart] Support Word Cloud (#614)
• Support for adding primary keys (#624)
• Add 'Total Rows' and 'Total Size' (#676)
• Ad hoc queries with custom aliases (#615)
• Dimension sorting is supported
• Metric sorting is supported
• Support for data sampling columns (#605)
• Add a symbol number type
• Fixed an issue with the display of lists on small screens
• Ad hoc query custom functions (#603)
• Add filter groupings
• Merge query columns
• Fixed the issue that duplicate requests were caused by duplicated data
• Fixed the issue that the grouping of editing reports was abnormal
• The issue of infinite loop query is fixed
• SUPPORT FILTERS 'IS NULL', 'IS NOT NULL'
• Fixed an issue where multi-column queries caused expres to be confused
• SUPPORT FILTERS 'LIKE', 'NOT LIKE'
• Support filters '=', '<>'
• Support filters '>', '>='
• Support filters '<', '<='
• Support synchronization of historical error messages
• Support for clearing data (#622)
• Support for dynamically adding columns (#623)
• Restructure the dataset details page
• Add a datetime type
• Support for custom lifecycles (#616)
• DISABLE 'BOOLEAN', 'DATETIME' TYPE ASSIGNMENTS
• Support for virtual columns (#602)
• Docker Compose support (#648)
• Support Qiniu Cloud Storage (#618)

Dependencies

---

• Update io.crate: crate-jdbc '2.6.0' to '2.7.0'
• Update Impala: ImpalaJDBC42 '2.6.29.1035' to '2.6.32.1041'
• Update org.yaml: snakeyaml '2.0' to '2.2'
• Update org.apache.hive: hive-jdbc '3.1.2' to '3.1.3'
• Update org.elasticsearch.plugin: x-pack-sql-jdbc '8.11.3' to '8.12.0'
• Update jackson.version '2.16.0' to '2.16.1'
• Update org.apache.maven.plugins: maven-javadoc-plugin '3.6.0' to '3.6.3'
• Update com.microsoft.sqlserver: mssql-jdbc '11.2.1.jre8' to '12.6.0.jre8'
• Updated postgresql.version '42.6.0' to '42.7.2'

2024.01.1

DataCap Released!

Release Version	Published
2024.01.1	2024-01-30

General

---

• [Dashboard] Support for removing reports
• [Dashboard] Support preview
• [Dashboard] Modification is supported
• [Metadata] PostgreSQL database is supported
• [Metadata] Support for synchronizing error messages
• [Metadata] Support for metadata synchronization after build (#585)
• [Metadata] Support manual synchronization of metadata from data sources (#586)
• [Metadata] Support for synchronizing history from data sources
• Add a query schema
• Fixed function creation/update time issues
• Optimized the question template
• Support for GitHub CI localization
• Add a system architecture diagram (#491)
• Support for buffering query results (#490)

SPI

---

• Fixed the problem of data source concurrency exception (#513)

Parser

---

• Add a SQL parser SPI
• Add Trino SQL parser (#569)
• Add MySQL SQL parser (#568)

Scheduler

---

• Add a scheduling SPI
• Support for default schedulers

Pipeleine

---

• Fixed the issue of pipeline grouping
• SqlServer support
• Refactoring the Seatunnel actuator
• Refactoring SPI with Kotlin rewrites
• Reconstruct the pipeline configuration method

Plugin

---

• MatrixOne (#574) support
• Support for ScyllaDB (#543)

DataSet

---

• Add a column model (metric|dimension)
• Add an ad-hoc query visual editor
• Add a line chart
• Add a data table
• Add a histogram
• SQL statements can be displayed and queried
• Custom expressions for indicators are supported
• Dimension grouping is supported
• Add indicator expression hints
• Specify expressions by type
• Metric aliases are supported
• Published|Dataset reports can be edited
• Partition keys are supported
• Column aliases are supported
• Support for syncing history
• Support for ad-hoc queries (#581)
• Scheduled data synchronization (#590)

Docs

---

• Added file system integration development documentation
• Add a Partner Presentation (#582)

Dependencies

---

• Update org.apache.maven.plugins: maven-compiler-plugin '3.3' to '3.12.1'
• Update com.dameng:DmJdbcDriver18 '8.1.2.192' to '8.1.3.62'
• Update mysql to '8.0.30'
• Update snowflake to '3.14.4'
• Update com.taosdata.jdbc: taos-jdbcdriver '3.0.0' to '3.2.7'
• Update org.apache.kylin: kylin-jdbc '2.6.3' to '4.0.3'
• Update slf4j.version '1.7.36' to '2.0.10'
• Update org.apache.maven.plugins: maven-assembly-plugin '3.5.0' to '3.6.0'
• Update org.duckdb: duckdb_jdbc '0.8.1' to '0.9.2'
• Update org.apache.ignite:ignite-core '2.8.1' to '2.16.0'
• Update org.projectlombok: lombok '1.18.28' to '1.18.30'

1.18.0

The current version involves several major updates.

DataCap Released!

Release Version	Published
1.18.0	2023-12-22

General

---

• [Metadata] Support for cloning rows
• [Metadata] Support truncating tables
• [Metadata] Data can be refreshed
• [Metadata] Tables can be deleted
• [Metadata] Displays table structure
• [Metadata] Support for displaying table ER diagrams
• [Metadata] Table data can be exported
• [Metadata] You can create new tables
• [Metadata] Support for creating new columns
• [Metadata] Columns can be deleted
• [Query] Add auto-add LIMIT
• [Users] Support for user avatars
• [Data Source] Optimized the message for deleting a data source
• [Report] Support data report function
• [Dashboard] Dashboard function is supported
• [Dataset] Dataset data is supported

SPI

---

• Support for FileSystem
• Support for Local FileSystem

Docs

---

• Add documentation for using the SDK

SqlServer

---

• Support for multiple versions
• Fixed the connection failure caused by the connection handle

Pipeline

---

• MySQL JDBC mode is supported
• Support drag-and-drop builds

Dependencies

---

• Update org.mongodb: mongodb-jdbc 2.0.2 to 2.0.3
• Update ch.qos.logback: logback-classic 1.2.11 to 1.2.13
• Update org.apache.kafka: kafka-clients 2.8.1 to 3.6.1
• Update ch.qos.logback: logback-core 1.2.11 to 1.2.13
• Update com.oracle.database.jdbc: ojdbc8 21.9.0.0 to 23.3.0.23.09
• Update org.elasticsearch.plugin: x-pack-sql-jdbc 7.10.0 to 8.11.3
• Update jackson.version 2.14.2 to 2.16.0

1.17.0

The current release involves several major updates.

DataCap is released!

Release Version	Release Time
1.17.0	2023-11-20

General

---

• Remove invalid metadata manager
• Optimization issues template
• Add version to app
  
• Support to check whether the java version is compatible at startup
• Fixed an error in selecting columns directly without selecting tables
• Supports custom column display
  
• Supports resetting column positions
  
• Querying the table view results in a value that cannot be converted
• Add jvm config
• No column information is returned when the data is empty
• Fixed switching table query data results in null query columns
• Support reset auto increment
  
• Unify the data types returned by each plug-in
• Support for viewing build statement sentences
  
• Add filter for table
  
• Support add new row data
  

Web

---

• Remove unused components

Dependencies

---

• Bump com.h2database:h2 from 2.1.214 to 2.2.224
• Bump org.jetbrains.dokka:dokka-maven-plugin from 1.8.10 to 1.9.10

1.16.0

The current release involves several major updates.

DataCap is released!

Release Version	Release Time
1.16.0	2023-11-01

General

---

• Support column order
  
• Support delete rows
• Support delete multiple rows
  
• Supports data update without primary key
  
• Supports data update with primary key
  
• Support preview pending changes

Editor

---

• Support selection query
  
• Support custom configure
  

Docs

---

• Add user profile doc

Dependencies

---

• Bump org.apache.maven.plugins:maven-javadoc-plugin from 3.5.0 to 3.6.0
• Bump com.oceanbase:oceanbase-client from 2.4.2 to 2.4.5
• Bump org.apache.maven.plugins:maven-javadoc-plugin from 3.5.0 to 3.6.0

1.15.0

The current release involves several major updates.

🎉 🎉 🎉 🎉 🎉 🎉 DataCap is released 🎉 🎉 🎉 🎉 🎉 🎉

Release Version	Release Time
1.15.0	2023-10-18

General

---

• Support database synchronization
• Support table synchronization
• Support column synchronization
• Add scheduler history
• Refactor metadata module
• Improve SQL files

Editor

---

• Replace monaco to ace

Docs

---

• Add deployment documents in Chinese
• Refine the fragment and data source Chinese documentation