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• TimescaleDB Open-source time-series database• InfluxDB The platform for time-series data
- • 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)