This action will force synchronization from openGauss/DataStudio, which will overwrite any changes that you have made since you forked the repository, and can not be recovered!!!
Synchronous operation will process in the background and will refresh the page when finishing processing. Please be patient.
Notice: DataStudio will not maintenance from 2023.08.23, we recommend use DataKit + WebDS plugin.
This version is version 5.1.0 of opengauss Data Studio, which mainly provides the following functions:
Manage / create database objects
Support the management / creation of database, schema, function, stored procedure, table, column, index, constraint, view, appearance, sequence, synonym, trigger, tablespace, user / role and other database objects
Execute SQL statement or SQL script
Supports the execution of SQL statements or SQL scripts
Create, execute and debug functions / stored procedures
It supports the creation, execution and debugging of functions / stored procedures. In the debugging process, stack and variable information can be displayed, and operations such as adding, deleting, enabling and disabling breakpoints are supported
Table data addition, deletion, modification and query
Support the addition, deletion, modification and query of visual operation table data
Import / export table data
It supports the import and export of table data. The supported file formats include excel, CSV, txt and binary files
Import / export connection profile
Supports the import and export of connection configuration files
Display / export DDL
Support to display / export DDL of various database objects such as tables, functions / stored procedures, views, sequences, synonyms, etc
SQL assistant, formatting, execution history
It provides functions such as SQL assistant, editor, intelligent SQL prompt, formatting, historical SQL record, etc
security management
Support SSL secure network connection, user authority management, password management and other functions to ensure the security of the database in the management layer, application layer, system layer and network layer.
Specific steps of Building Data Studio binary package through source code
Download and install jdk11 http://jdk.java.net/archive/ and configure Java_ Home
environment variable. JDK recommended version 11.0.2
Download and install maven x. And configure M2_ Home
environment variable.
Maven recommends version 3.8.3 https://archive.apache.org/dist/maven/maven-3/3.8.3/binaries/apache-maven-3.8.3-bin.zip
Adoption https://gluonhq.com/products/javafx/ Download SDK 17.0.2 to any local directory and unzip it to javafx-17.0.2
Adoption https://downloads.efxclipse.bestsolution.at/p2-repos/openjfx.p2-17.0.2.zip Download openjfx p2-17.0.2. Zip and unzip to any local directory.
Configure POM file properties configuration information javafx.home and url.openjfx information .
<javafx.home>local_directory\javafx-sdk-17.0.2</javafx.home>
<url.openjfx>file:\\\local_directory\openjfx.p2-17.0.2</url.openjfx>
Example:
Download javafx-sdk-17.0.2 and openjfx P2-17.0.2 unzip to disk D of the local directory,Configure .
<javafx.home>D:\javafx-sdk-17.0.2</javafx.home>
<url.openjfx>file:\\\D:\openjfx.p2-17.0.2</url.openjfx>
Enter the src directory of Data Studio source code through git bash command line:
Use mvn - version command to check and confirm Maven and JDK version information.
$ mvn -version
Apache Maven 3.8.4 (9b656c72d54e5bacbed989b64718c159fe39b537)
Maven home: D:\tool\apache-maven-3.8.3 Java version: 11, vendor: Oracle Corporation, runtime: D:\tool\openjdk-11\jdk-11 Default locale: zh_CN, platform encoding: GBK OS name: "windows server 2016", version: "10.0", arch: "amd64", family: "windows"
Run compiled script
cd ${Data_Studio_code}\code\datastudio\src
sh copyExternalsToBuild.sh
mvn clean package -Dmaven.test.skip=true
The location of the generated installation package is:
${Data_Studio_code}\code\datastudio\build
After eclipse imports the project, open org Opengauss Mppdbide Mppdbide Product file, click launch an eclipse application to run the startup project.
If the project fails to start, configure the current running environment and run it after the following operations.
Click run-> run configurations - > plug ins - > Add required plug ins - > validate plug ins - > apply - > run in eclipse menu to start the project
Participating Contributions
As an openGauss user, you can assist the openGauss community in a variety of ways. See [Community Contribution] for ways to participate in community contributions. https://opengauss.org/zh/contribution.html ), Here is a simple list of some ways for reference.
Special Interest Groups
OpenGauss brings together people of common interest to form different special interest groups (SIGs). Currently existing SIGs see SIG List。
We welcome and encourage you to join an existing SIG or to create a new SIG, as described in the SIG Management Guide.
Mailing Lists and Tasks
Welcome to actively help users solve problems in mailing list and issue tasks (including Code Warehouse Tasks ) Questions raised. In addition, we welcome your question. These will help the openGauss community grow better.
Documentation
Not only can you contribute to the community by submitting code, but we also welcome your feedback on problems, difficulties, or suggestions for improving the usability and integrity of your documents. For example, problems in obtaining software or documentation, and difficulties in using the system. Welcome to pay attention to and improve the documentation module for the openGauss community.
IRC
OpenGauss also opens channels at IRC as an additional channel for community support and interaction. See openGauss IRC for details.
This document follows Knowledge Sharing License Agreement CC 4.0.
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。