通用数据库工具
DBeaver 是一个通用的数据库管理工具,适用于需要以专业方式处理数据的每个人。使用 DBeaver,您可以像在常规电子表格中一样处理数据,根据来自不同数据存储的记录创建分析报告,以适当的格式导出信息 (sysin)。对于高级数据库用户,DBeaver 建议使用强大的 SQL 编辑器、大量管理功能、数据和模式迁移能力、监控数据库连接会话等等。开箱即用的 DBeaver 支持 80 多个数据库。
支持的数据库
Relational | Analytics | Document-Oriented | Cloud | Hadoop | Key/Value | Time Series | Graph | Search engines | Embedded
-
Relational
- MySQL
The most popular open-source relational database. Now supported by Oracle. - MariaDB
Fork of MySQL, bundled on many Linux systems as default MySQL engine - PostgreSQL
The most powerful open-source relational database. - Microsoft SQL Server
Enterprise-level relational database developed by Microsoft. - Oracle
Oracle database (Express or Enterprise) is one of the most advanced relational databases. - DB2
Enterprise-level relational database developed by IBM (sysin). Supported drivers are: DB2 for LUW (Linux/Unix/Windows), DB2 for z/OS, DB2 for iSeries / AS400 - SAP® MaxDB®
DBeaver is designed for use with SAP® MaxDB® - Informix
Secure embeddable database, developed by IBM. Optimized for OLTP and IoT - Sybase®/SAP® ASE
DBeaver is designed for use with SAP® ASE (Adaptive Server Enterprise), originally known as Sybase SQL Server, and also commonly known as Sybase DB or ASE, – a relational model database server product for businesses - Mimer SQL
Scalable and embedded database solutions conforming to ISO standards and suited for open environments - InterSystems Caché
Multipurpose relational and object-oriented DBMS - Firebird
Open source cross platform SQL relational database - Ingres
Open-source SQL relational database management system intended to support large commercial and government applications - Yellowbrick
Unveils Integrated Data Warehouse Platform - Linter
DBMS developed by the Russian company RELEX, certified by the Russian FSTEC and Ministry of Defense and providing solid security of information - Yugabyte DB SQL
Distributed SQL database for global, internet-scale applications with low query latency, extreme resilience against failures. - Virtuoso
Hybrid database engine that combines the functionality of a traditional RDBMS, object-relational database (ORDBMS), virtual database, RDF and XML database - CUBRID
Open source SQL-based relational database management system with object extensions
- MySQL
-
Analytics
- Greenplum
Massively parallel processing database based on PostgreSQL. - Exasol
Enterprise-level in-memory analytics database - Vertica
Relational analytics database widely used in BigData applications - Teradata
Enterprise-level analytics database - SAP® HANA®
DBeaver is designed for use with SAP HANA®. - Netezza
IBM data warehouse analytics database - PrestoDB
Distributed SQL Query Engine for Big Data - ClickHouse
Open-source distributed column-oriented DBMS
- Greenplum
-
Document-oriented
-
Cloud
- AWS Athena
Interactive query service that makes it easy to analyze data in Amazon S3, using standard SQL - AWS Redshift
Fully managed, petabyte-scale data warehouse service in the cloud - AWS DynamoDB
Key-value and document database that can handle more than 10 trillion requests per day and can support peaks of more than 20 million requests per second. - AWS Aurora
MySQL and PostgreSQL-compatible relational database built for the cloud. - AWS DocumentDB
Fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. - AWS Keyspaces
A scalable, highly available, and managed Apache Cassandra–compatible database service. - Google Bigtable
A petabyte-scale, fully managed NoSQL database service for large analytical and operational workloads. - Google BigQuery
Google’s serverless, highly scalable, enterprise data warehouse designed to make all your data analysts productive at an unmatched price-performance. - SQL Azure
Managed cloud database (SaaS) provided as part of Microsoft Azure. - Snowflake
Cloud data warehouse - NuoDB
Elastic SQL cloud database
- AWS Athena
-
Big Data / Hadoop
- Apache Hive
Data warehouse software that facilitates reading, writing, and managing large datasets residing in distributed storage using SQL - Spark Hive
Spark JDBC driver for Apache Hive - Apache Drill
Open-source version of Google’s Dremel system that is available as an infrastructure service called Google BigQuery - Apache Phoenix
Apache Phoenix HBase database - Apache Impala
Open source massively parallel processing (MPP) SQL query engine for data stored in a computer cluster running Apache Hadoop. Impala has been described as the open-source equivalent of Google F1 - Gemfire XD
Memory-optimized, distributed data store designed for applications that have demanding scalability and availability requirements - CockroachDB
The SQL database for building global, scalable cloud services that survive disasters. - SnappyData
In-memory data platform for mixed workload applications. Built on Apache Spark
- Apache Hive
-
Key Value
- Apache Cassandra
A free and open-source, distributed, wide column store, NoSQL database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure - Redis
An open source (BSD licensed), in-memory data structure store, used as a database, cache and message broker. - Yugabyte DB CQL
- Apache Cassandra
-
Time Series
- TimescaleDB
Open-source time-series database - InfluxDB
The platform for time-series data
- TimescaleDB
-
Graph
-
Search engines
- Elasticsearch
Distributed, RESTful search and analytics engine. It provides a distributed, multitenant-capable full-text search engine with an HTTP web interface and schema-free JSON documents. - Solr
Open source enterprise search platform. Its major features include full-text search, hit highlighting, faceted search, real-time indexing, dynamic clustering, database integration, NoSQL features and rich document (e.g., Word, PDF) handling.
- Elasticsearch
-
Embedded
- SQLite
Popular embedded database widely used in desktop and mobile (Android) applications - HSQLDB
Embedded database, written on Java and used as database engine in Open Office products. - H2
Embedded database, written on Java. Supports standalone server mode. - Apache Derby / Java DB
Embedded database, written on Java. Supports standalone server mode. - Microsoft Access
JDBC driver for embedded Microsoft Access database (mdb) - CSV
JDBC driver for flat CSV (comma separated) files - DBF
The .dbf file extension represents the dBase database file
- SQLite
版本比较
DBeaver 22.2 新增功能
September 12 2022
SQL Editor:
New Features
-
Introducing SQL Terminal which captures the query statement, query results and messages in text format. The SQL Terminal updates to append each SQL query creating a visual history of statements run, the corresponding result set, and any messages in one view. The new terminal is enabled by selecting the terminal icon on the SQL Editor screen.
-
Generate DDL from resultset enables DDL script for table creation while reviewing query results. Open the metadata panel and click DDL button.
Data Editor:
New Features
- Visualisation of arrays and multi-row data types for relational & NoSQL databases. Introduces the capability for cell expansion to see all lines in an array by selecting the down arrow icon within the data editor window.
- Excel-like behaviour for inline data editing when selecting ‘Enter’ after values are entered in a cell, the value will be saved and the field focus will move automatically to the next row. This feature is disabled by default, to enable go to settings (Preferences > Select next cell after line item).
General UI:
New Features
- Default embedded browser was changed to Microsoft Edge after Internet Explorer’s long awaited retirement. Browser view is used for GIS data and other browser based user elements.
Data Transfer:
New Features
- Target table properties (such as engine, charset, etc) were added in the import wizard for data transfer. Table property values entered will automatically be included in Target DDL creation script. To set table properties, access the import wizard and select the ‘Table Properties’ tab.
- Multiple improvements to data transfer capabilities. Configuration was added to enable or disable the header within CSV and TXT formats when exporting to the same file multiple times. Target DDL generator now checks for naming conflicts within existing non-table objects for the target table. See complete list of all improvements in detailed release notes.
Database Management:
New Improvements
- Oracle:
- Generate DDLs for Scheduler Jobs
- Oracle Cloud database connection issue was fixed
- Redis:
- Connect by URL, SSL support, and Cluster support
- S3 Browser:
- Copying files from DBeaver with drag and drop was fixed
- XML/JSON files not opening in DBeaver was fixed
下载体验
MacOS DMG – just run it and drag-n-drop DBeaver into Applications.
Debian package – run sudo dpkg -i dbeaver-
. Then execute “dbeaver &”.
RPM package – run sudo rpm -ivh dbeaver-
. Then execute “dbeaver &”. Note: to upgrade use “-Uvh” parameter.
ZIP archive – extract archive and run “dbeaver” executable. Do not extract archive over previous version (remove previous version before install).
Windows installer – run installer executable. It will automatically upgrade version (if needed).
DBeaver Ultimate Edtion 22.2 Multilingual (macOS, Linux, Windows)
百度网盘链接:https://pan.baidu.com/s/1bKB19kZTmwsENIShyR_2dg 提取码:5sb4
下载仅供下载体验和测试学习,不得商用和正当使用。
下载体验