Blue Flower

通用数据库工具

DBeaver 是一个通用的数据库管理工具,适用于需要以专业方式处理数据的每个人。使用 DBeaver,您可以像在常规电子表格中一样处理数据,根据来自不同数据存储的记录创建分析报告,以适当的格式导出信息 (sysin)。对于高级数据库用户,DBeaver 建议使用强大的 SQL 编辑器、大量管理功能、数据和模式迁移能力、监控数据库连接会话等等。开箱即用的 DBeaver 支持 80 多个数据库。

dbeaver-on-ubuntu

支持的数据库

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
  • 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
  • Document-oriented

    • MongoDB
      Free and open-source cross-platform document-oriented database
    • Couchbase
      Couchbase is an open-source, distributed multi-model NoSQL document-oriented database software that is optimized for interactive applications.
  • 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
  • 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
  • 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
  • Time Series

  • Graph

    • Neo4j
      Graph database management system
    • OrientDB
      Distributed Multi-Model and Graph Database
  • 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.
  • 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

版本比较

dbeaver-version-compare

DBeaver Community 免费下载

DBeaver 22.2 新增功能

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-.deb. Then execute “dbeaver &”.
RPM package – run sudo rpm -ivh dbeaver-.rpm. 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

下载仅供下载体验和测试学习,不得商用和正当使用。

下载体验

请输入密码查看内容!

如何获取密码?

 

点击下载