1. Project Overview

Data Visualization Analysis Platform

Free to create any data board you want

DataGear is an open-source and free data visualization analysis platform, free to create any data board you want, supporting access to SQL, CSV, Excel, HTTP interface, JSON, etc. multiple data sources.

The main functions of the system include: data source management, SQL workbench, data import/export, project management, data set management, chart management, board management, user management, role management, data source driver management, chart plugin management, etc.

2. Open Source License

Licensed under GPL-3.0

3. Screenshots

Interface

Data Source Management

SQL Data Set

Board Editing

Board Display

Board Display - Chart Interaction

Board Display - Real-time Chart

Board Display - Drill Down

Board Display - Form

Board Display - Asynchronous Loading of Charts

4. Feature Overview

Features

• Safe and Stable
  Years of continuous development and iteration, stable operation for thousands of hours without exception, smooth and non-blocking function, private deployment, single application, lightweight architecture, simple installation, running environment and data under control, based on role-based permission control strategy, data default private, can be shared and used, protect data security, access control, SQL injection prevention, data source protection, sensitive information encryption storage, log de-sensitization processing
• Rich Functions
  Data source management supports data CRUD, import/export, SQL workbench data set supports SQL/HTTP/CSV/Excel/JSON/file, supports defining parameters and parameterized syntax, charts support binding multiple data sets from different sources in one, built-in 70+ commonly used charts, data boards support importing HTML templates, visual/source code editing mode, password sharing, iframe embedding, user management, role management, data source driver management, chart plugin management, etc.
• Easy to Extend
  Supports adding data source drivers at runtime, connecting to any database that provides a JDBC driver library, including but not limited to MySQL, PostgreSQL, Oracle, SQL Server, Elasticsearch, ClickHouse, and numerous domestic databases such as OceanBase, TiDB, Renmin University Golden Warehouse, and Daman, etc. Supports writing and uploading custom chart plugins, extending system chart types, and rewriting and extending built-in chart plugins, custom chart options, and personalized chart display effects
• Free to Create
  Data boards use native HTML web pages as templates, support importing any HTML/JavaScript/CSS, support visual design, and also support free editing of source code, support introducing Vue, React, Bootstrap, Tailwind CSS, etc. web front-end frameworks, creating data boards with rich interactive effects and multi-terminal adaptability, built-in rich data board APIs, creating personalized data boards with chart interaction, data drill-down, asynchronous loading, and interactive forms

Function

5. Tech Stack

Technical Stack (Front-end and Back-end Integrated)

• Backend
  Spring Boot、Mybatis、Freemarker、Derby、Jackson、Caffeine、Spring Security
• Frontend
  jQuery、Vue3、PrimeVue、CodeMirror、ECharts、DataTables

Module Introduction

• datagear-analysis
  Data Analysis Bottom Layer Module, defining data sets, charts, and board APIs
• datagear-connection
  Database Connection Support Module, defining APIs to load JDBC drivers from specified directories and create new connections
• datagear-dataexchange
  Data Import/Export Bottom Layer Module, defining APIs to import/export data from specified data sources
• datagear-management
  System Business Service Module, defining service layer APIs for data sources, data analysis, etc.
• datagear-meta
  Data Source Meta Information Bottom Layer Module, defining APIs to parse specified data source table structures
• datagear-persistence
  Data Source Data Management Bottom Layer Module, defining APIs to read, edit, and query data source table data
• datagear-util
  System Common Toolset Module
• datagear-web
  System Web Module, defining web controllers and operation pages
• datagear-webapp
  System Web Application Module, defining program startup classes

Dependency

Java 8+
Servlet 3.1+

More content, please refer to README.md document