DBeaver Ultimate Edtion 23 Multilingual (macOS, Linux, Windows) - 通用数据库工具，现已集成 ChatGPT

请访问原文链接：https://sysin.org/blog/dbeaver-23/，查看最新版。原创作品，转载请保留出处。

作者主页：www.sysin.org

通用数据库工具

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 23.0 新增功能

DBeaver 23.0

March 13 2023

  • Database drivers:
    • A new ODBC driver was added
  • ChatGPT:
    • OpenAI (ChatGPT) integration was implemented out-of-the-box in PRO versions
  • Cloud Explorer:
    • Azure Cloud support was added
    • PostgreSQL and MySQL support was added in Azure Cloud
  • Accessibility:
    • The text reader for the entity editor was improved
    • The text reader for the data grid was improved
    • Font settings are now respected in all editors/popups
    • Many new keyboard shortcuts were added
    • The catalog/schema selector now supports keyboard-only mode
    • Reader texts were localized
  • Data Editor:
    • A few elements and behavior in Data Editor were redesigned
    • The issues with filtering and ordering data were fixed
    • The context menu was improved
  • SQL Editor:
    • Query generation from human language text was added
    • Query execution plain was improved
    • Auto-completion issues were fixed
  • Data transfer:
    • Data export to Google Sheets and Google Drive was added
    • Data export in SQL INSERT format now supports custom target table name configuration
  • Databases:
    • PostgreSQL: The ability to create a full backup and SSL keys automatic conversion was added
    • SQL Server: VARCHAR(MAX) data type support and table column comments support were added
    • MongoDB: issues with running db.runCommand, JSON view and boolean values display were fixed
    • Teradata: mutiple issues were resolved including secure zones support and kerberos authentication
    • Snowflake: Schema Compare and Table constraints reading issues were fixed
    • Redshift: The issue with access to Redshift Datashare was resolved

下载地址

MacOS DMG – just run it and drag-n-drop DBeaver into Applications.
Debian package – run sudo dpkg -i dbeaver-<version>.deb. Then execute “dbeaver &”.
RPM package – run sudo rpm -ivh dbeaver-<version>.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 23.0 Multilingual (macOS, Linux, Windows), 13th March 2023
百度网盘链接：https://sysin.org/blog/dbeaver-23/

for macOS：DBeaver Ultimate Edtion 23 for macOS Intel x64 & Apple ARM64 (sysin)

for Linux：DBeaver Ultimate Edtion 23 for Linux deb (sysin)

posted @ 2023-03-14 14:23  sysin  阅读(74)  评论(0)  编辑  收藏  举报