devlive-community / dbm Goto Github PK

Describe the bug
1:Display block in DBM table name, if the table name is too long, it will be incomplete，And the DBM table display box cannot be dynamically stretched up, down, left and right

2:Create table name on DBM, table name cannot start with a number

Version for 1.9.0

I tried to create a basic docker container based on node:16/node:16-alphine, and the latest tag 1.6.0, but the "yarn run build" fails on;
ERROR in ./node_modules/babel-loader/lib!./node_modules/vue-loader/lib/selector.js?type=script&index=0!./src/renderer/views/Data/Metadata/index.vue
Module not found: Error: Can't resolve '../../components/table/TableCreate' in '/dbm/src/renderer/views/Data/Metadata'
@ ./node_modules/babel-loader/lib!./node_modules/vue-loader/lib/selector.js?type=script&index=0!./src/renderer/views/Data/Metadata/index.vue 13:0-61
@ ./src/renderer/views/Data/Metadata/index.vue
@ ./src/renderer/router/index.js
@ ./src/renderer/main.js

Release time

2021-09-23

Components involved

• ClickHouse

Check list

Bugs

• Fix the migration data password null problem

UI

• Increase query history limit reminder
• Disallow clicking on the mask layer to close the dialog popover

Enhancement

• Support add column to table
• Support delete column
• Support modify column
• Support rename column
• Support preview data for column

Release time

2022-08-12

Components involved

• ClickHouse
• MySQL
• PostgreSQL
• Apache Druid
• ElasticSearch
• Hologres

Check list

General

• Rebuild the table configuration layout
• Fix the query result is not displayed in the column data under certain circumstances
• Optimize the display type icon of the data source list

Editor

• Support the new editor to delete the data table shortcut menu (new editor)
• Display and query additional information (new editor)

ClickHouse

• Support MySQL table engine
• Support Hive table engine
• Support PostgreSQL database engine
• Support https protocol issues-247

MySQL

• Support metadata management, build a database, specify character sets & collation issues-180
• Fix only_full_group_by could not obtain metadata issues-180

PostgreSQL

• Fix the exception of the metadata management build table
• Support rename database
• Fix failure to query when database is empty

Apache Druid

• Support quick query

ElasticSearch

• Support ElasticSearch (query and data source management)

Hologres

• Support Hologres (query and data source management)

Is your feature request related to a problem? Please describe.
tried following connection parameters

github.demo.altinity.cloud
8443
demo
demo

Describe the solution you'd like
Juxt add SSL support, also custom CA and custom Certs

Is your feature request related to a problem? Please describe.
my local dev env mysql not need a password,but with the gui, the password is a required field,

Describe the solution you'd like
the password field should be a optional field

Release time

2021-11-02

Components involved

• Database Engines
• Table Engines

Check list

UI

• Support for editor quick comments

Enhancement

• Support for building Sqlite engine tables
• Support for building JDBC engine tables
• Support slow query monitor
• Support MaterializeMySQL database engine
• Support mysql database engine
• Support for building ODBC engine tables
• Support to display the database DDL right-click menu

Optimize

• Modify the node heartbeat detection method
• Optimize the construction of data tables to verify whether the service
• Support metadata tree menu display engine | type

Please use the following code to reply to the issues

@all-contributors please add @<username> for <contributions>

Support query trino and presto on dbm

Release time

2022-05-13

Components involved

• ClickHouse

Check list

Enhancement

• SSH login is supported #40
• Support query ClickHouse to dynamically add configuration
• Support metadata management to filter the database

Optimize

• Optimize error reporting pop-up window #148

UI

• Optimize query history display list
• Migrate the software update function to the system menu
• Support editor bracket matching

Release time

2022-07-25

Components involved

• ClickHouse
• Apache Druid
• PostgreSQL
• Trino & Presto
• MySQL

Check list

General

• Add a new code editor layout
• Fix the style of the tree menu on the left side of metadata management is confused

ClickHouse

• Support MaterializedPostgreSQL database engine

Trino & Presto #158

• Support the currently stopped running process

MySQL #180

• Support the currently stopped running process

PostgreSQL

• Support metadata management to create database, filter database
• Support metadata management to create table
• Support metadata management to delete database

Apache Druid

• Support Druid (query and data source management)

Describe the bug
Running yarn install at the root directory of workspace failed.

To Reproduce
Steps to reproduce the behavior:

1. Go to root directory.
2. Type yarn insall and return.
3. Terminal would report error with information:
4. See error:

Error: Unresolved node modules: highcharts
    at /~/incubator-dbm/node_modules/electron-builder-lib/src/util/packageDependencies.ts:109:19
From previous event:
    at Collector.resolveUnresolvedHoisted (/~/incubator-dbm/node_modules/electron-builder-lib/out/util/packageDependencies.js:206:11)
    at /~/incubator-dbm/node_modules/electron-builder-lib/src/util/packageDependencies.ts:85:18
    at Generator.next (<anonymous>)
    at processImmediate (internal/timers.js:456:21)
From previous event:
    at Collector.collect (/~/incubator-dbm/node_modules/electron-builder-lib/out/util/packageDependencies.js:154:11)
    at computeDependencies (/~/incubator-dbm/node_modules/electron-builder-lib/src/util/packageDependencies.ts:50:26)
    at /~/incubator-dbm/node_modules/electron-builder-lib/src/util/packageDependencies.ts:45:28
    at Generator.next (<anonymous>)

Expected behavior
yarn install all dependencies successfully.

Screenshots
No.

Component (please set component name):

• Component: yarn
• Version 1.17.3
• Component: npm
• Version 7.19.1
• Component: node
• Version v12.18.2

Additional context
yarn -v: 1.17.3
npm -v: 7.19.1
node -v: v12.18.2
The highcharts as a peerDependency is in package.json of highchars-vue. After installing highcharts by command yarn add highcharts@latest, errors were gone.

Describe the bug
Auto update failed

Installation from dbm-1.22.0-windows-x64-nsis-installer.exe, also failed

Manual uninstallation from "C:\Program Files\dbm\Uninstall dbm.exe", also failed

To Reproduce
Steps to reproduce the behavior:

1. Install 1.21 version from github releases
2. Download 1.22 version from gjitub releases
3. Try to run dbm-1.22.0-windows-x64-nsis-installer.exe
4. See error

Release time

2022-02-22

Components involved

• ClickHouse

Check list

Enhancement

• Nullable decorated column type is supported
• Build tables support optional parameters
• Support version update check
• Support to clear partition data by filtering criteria
• Supports data migration

Docs

• Support For Chinese documents

Optimize

• Optimize database deletion UI

Bug

• Fixed inability to build Log related engine tables
• Fix slow query list cannot display DDL
• Fix README.md file logo cannot be displayed

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

We're abandoning VUE and refactoring with Angular and Typescript, and we're coming out with new versions!!

Describe the bug
Display block in DBM table name, if the table name is too long, it will be incomplete，And the DBM table display box cannot be dynamically stretched up, down, left and right

Version for 1.9.0

Release time

2022-04-25

Components involved

• ClickHouse

Check list

• Support metadata management, add column description information
• Support code snippet management
• Support query reference code snippet
• Support to quickly add code snippets after successful query
• Add multiple editor themes
• Quick query unavailable nodes prohibit operations
• It is forbidden to use functions such as quick query if the data source is not selected
• Add data sheet deletion prompt greater than 50GB

Describe the bug
Running yarn build on macOS Big Sur failed.

To Reproduce
Steps to reproduce the behavior:

1. Go to root directory of project.
2. Type yarn build and waitting for building.
3. See error:

Error: Exit code: 2. Command failed: /usr/bin/perl /private/var/folders/md/tfqt3nvs6fbb4110yq0smqb80000gn/T/t-FPHyHd/1-dmgProperties.pl
Can't locate Mac/Finder/DSStore.pm in @INC (you may need to install the Mac::Finder::DSStore module) (@INC contains: /Library/Perl/5.30/darwin-thread-multi-2level /Library/Perl/5.30 /Network/Library/Perl/5.30/darwin-thread-multi-2level /Network/Library/Perl/5.30 /Library/Perl/Updates/5.30.2 /System/Library/Perl/5.30/darwin-thread-multi-2level /System/Library/Perl/5.30 /System/Library/Perl/Extras/5.30/darwin-thread-multi-2level /System/Library/Perl/Extras/5.30) at /private/var/folders/md/tfqt3nvs6fbb4110yq0smqb80000gn/T/t-FPHyHd/1-dmgProperties.pl line 3.
BEGIN failed--compilation aborted at /private/var/folders/md/tfqt3nvs6fbb4110yq0smqb80000gn/T/t-FPHyHd/1-dmgProperties.pl line 3.

Can't locate Mac/Finder/DSStore.pm in @INC (you may need to install the Mac::Finder::DSStore module)

Expected behavior
yarn build successfully.

Screenshots
No.

Component (please set component name):

• Component: yarn
• Version 1.17.3
• Component: npm
• Version 7.19.1
• Component: node
• Version v12.18.2
• Component: macOS
• Version 11.4 (20F71)

Additional context
It looks like due to the question of old version of electron-builder. Relavant issue: electron-userland/electron-builder#3990. After upgrading electron-builder to "electron-builder": "^21.2.0", errors gone.

Release time

2022-06-10

Components involved

• ClickHouse
• Trino & Presto
• MySQL

Check list

General

• Split multiple data sources and configure them as separate components
• Support tray function
• Fix the exception of Presto using quick query
• Support metadata host filtering
• Support query history reference to the editor
• Fix the error message that the query history cannot be viewed

ClickHouse

• Support specifying a database when building a data source

Trino & Presto

• Support specifying a database and catalog when building a data source #158
• Support metadata source management Trino & Presto service information #158
• Support metadata source management Trino & Presto create database #158

MySQL

• Support MySQL (custom query and data source management) #180
• Add MySQL docs #180

Support query mysql on dbm

Release time

2021-01-01

Components involved

• e.g: XXXXXX

Check list

• check 1
• check 2

Release time

2021-03-29

Components involved

• e.g: XXXXXX

Check list

Enhancement

• Metadata management delete database supports quick input of database name
• Add EXPLAIN AST, EXPLAIN SYNTAX, EXPLAIN PLAN, EXPLAIN PIPELINE, EXPLAIN ESTIMATE, EXPLAIN TABLE OVERRIDE
• Query results can be exported to CSV files
• Support for deleting tables when deleting databases

Docs

• Add install docs
• Add query history docs

Optimize

• Optimize metadata management to delete data columns
• Optimize the query result display table
• Optimized data arrangement of deleted data partitions

Bug

• Fix the problem of clearing multi-partition data
• Fix run dev Last few GCs
• Fixed editor state not resetting after cancel execution
• Fix README.md file script pointing error

UI

• The status of the metadata management service request failure is red
• Metadata Management menu Added the number of submenus to display
• Add the total number of rows returned from the query result
• Supports highlighting of abnormal data in query history execution

Release time

2021-07-23

Components involved

• ClickHouse

Check list

• Support query progress display DDL
• Support stop running query
• Add one click refresh data source
• Add connection monitor
• Upgrade the default versions of Vue (2.5.10 -> 2.15.3 +) and electron
• Add release timeline to index
• Support users to authorize users to access Clickhouse
• Query history supports copying SQL
• Support sql format
• Support general configuration of global editor
• Add software website
• Support multiple query results display
• Supports text query selection Issues-13
• Support query history Pagination
• Support the construction of data source selection protocol

Release time

2021-08-31

Components involved

• e.g: ClickHouse

Check list

DBM Version for 1.5.0 is released!

UI

• Beautify the right-click menu style

Enhancement

• Add editor format SQL configuration
• Support for building Kafka engine tables
• Support metadata service shortcut menu
• Support metadata database and table shortcut menu
• Support for obtaining the columns of the metadata table
• Supports previewing table data in metadata
• Support for building HDFS engine tables
• Support for obtaining column information
• Support rename table

Optimize

• Optimize the StringUtils utility class
• Internationalization table engine
• Optimized the local data migration logic

Release time

2021-07-06

Components involved

• ClickHouse

Check list

• Add version for dashboard
• Replace the SVG icon with fa icon
• Refactoring menu style
• Optimize part UI and logic(query, datasource)
• Add data source timing detection task
• Add app info page
• Split the service tree into new components
• Shield invalid data in quick query
• Support internationalization
• Drop limit supported by data source construction
• Refactoring query history UI
• Support network timeout setting
• Add server occupancy process monitoring
• Add process chart

I tested Support to clear partition data by filtering criteria functionality against system.query_log, but after load the partitions, there were too many duplicated button showed in window. That looked wired.

Originally posted by @joint-song in #94 (comment)

when I execute 'insert into table xxxxx', display error
"Code: 27, e.displayText() = DB::Exception: Cannot parse input: expected '(' before: 'FORMAT JSON': at row 1 (version 20.8.3.18)", need to add a semicolon ';' to execute.

Whether SSH login is supported?

I find the feature at DATAgrip

Maybe this modify system table ,but its very useful!

and other , if press "ctrl+enter" can exec sql hot key ,it will be better.
thanks!

At present, Clickhouse data migration between different nodes of the DBM, the node of the distributed table is still the source node, and I hope it can be replaced with the domain name of the current node

Release time

2021-03-18

Components involved

• ClickHouse

Check list

Enhancement

• Support visual construction of data table and configuration of optional parameters
• Add data source list to display service version information
• Add editor execution status feedback
• Add ancillary information such as execution result and time
• SQL shortcut keys can be executed by Ctrl+Enter #102
• Support for data source maxTotal configuration (experimental) #102
• Add SHOW PARTITIONS quick query
• The EXPLAIN command is supported

Optimize

• Optimized the display of metadata management disk usage
• Merge Query Select the query & query function

Bug

• Fixed data source not paging problem in quick query
• Fixed the problem that metadata information cannot be distinguished due to multiple selections
• Fix top menu style exception
• Fix the problem that the metadata operation node is not refreshed #101

UI

• New data source window layout
• Add nine editor themes
• Execute button to add shortcut key prompt

When I format the sql, the error is as follows：

**> TypeError: Cannot read property 'formatter' of null

at t.b (renderer.js:1)
at r.handlerFormat (68.js:1)
at click (68.js:1)
at ie (renderer.js:1)
at r.a (renderer.js:1)
at ie (renderer.js:1)
at r.e.$emit (renderer.js:1)
at r.handleClick (renderer.js:1)
at ie (renderer.js:1)
at HTMLButtonElement.a (renderer.js:1)**

Release time

2021-08-16

Components involved

• ClickHouse

Check list

Enhancement

• Support migrate data
• Support for building Log engine tables
• Support display Track DDL
• Support the Track input box to obtain the focus display
• Supports Windows system construction
• Support track query execution thread
• Support data source query times to be displayed on the dashboard
• Add query link tracing visualization
• Support multiple query windows
 issues-12
• Supports obtaining the occupied space of columns throug… …
• Supports data source modification
• Support display table usage when the database is selected

• Support service nodes to display database disk usage
• Support service nodes to display disk usage
• Support Data construction of left tree menu issues-20
• Supports the monitoring of mutations operation

Optimize

• Support the mutation consumption duration
• Optimized README.md

UI

• Set the default maximized window

Bug

• Fix metadata selection library table causing data rendering errors


CI

• Add auto release version CI script

Describe the bug
Tables and databases information bar inside Management didn't refresh automatically while after deletion some tables or databases

To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Component (please set component name):

• Component: [e.g. XXXXX]
• Version [e.g. 1.0.2]

Additional context
Add any other context about the problem here.

Adding a close button to the error reporting pop-up window.
If not ,we must wait for the pop-up window to close automatically.
It wastes to much time of developers.

Release time

2022-06-23

Components involved

• ClickHouse
• Trino & Presto
• MySQL
• PostgreSQL

Check list

ClickHouse

• Support the currently stopped running process

Trino & Presto

• Supports query result time and total number of data issues-158

MySQL

• Support quick query operation issues-180
• Supports query result time and total number of data issues-180
• Supports monitor → processors issues-180
• Supports monitor → connection issues-180
• Supports metadata management of disk usage issues-180
• Support metadata management menu server related operations issues-180

PostgreSQL

• Support PostgreSQL (custom query and data source management)

Can it support the automatic setting of consumer groups when kafka engine tables are migrated?

Release time

2021-05-30

Components involved

• ClickHouse
• Presto
• Trino

Check list

Enhancement

• Support metadata management to filter the table
• Support trino and presto for query
• Support trino and presto for monitor --> processors
• Support trino and presto for monitor --> connection
• Support trino and presto for monitor --> slow query

Docs

• Refactoring software homepage
• Add clickhouse datasource docs
• Add presto & trino datasource docs

Bug

• Fix the exception that the data source is not selected in the track, the Track list can be selected

UI

• Add multiple editor themes
• Query the list of data sources on the page, support the display of logo

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.