DBeaver Ultimate Edtion 22.3 Multilingual (macOS, Linux, Windows) - 通用数据库工具

Posted by sysin on 2022-12-13
Estimated Reading Time 19 Minutes
Words 3.2k In Total
更新日期:Tue Dec 13 2022 10:20:00 GMT+0800,阅读量:

请访问原文链接:DBeaver Ultimate Edtion 22 Multilingual (macOS, Linux, Windows) - 通用数据库工具,查看最新版。原创作品,转载请保留出处。

作者主页: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 22.3 新增功能

DBeaver 22.3

December 12, 2022

Changes since 22.2:

  • General improvements:
    • Multi-connections behavior configuration was improved
    • The possibility to forcibly disable or enable additional metadata or SQL editor connections was added
    • We switched to a new Eclipse platform version (2022-09)
    • Multiple MFA attempts were resolved (in drivers with MFA authentication)
    • RPM package: issue with the remaining symlinks after uninstall was fixed
    • External editor support to open BLOB files was added
    • Execution plan support for HSQLDB was added
    • Multi-character prefixes support in SQL preferences was improved
    • Metadata editor: schema refresh performance was significantly increased
    • Database backup: variable ${schema} was added
    • Eclipse plugin: a lot of DBeaver-related warnings in the error log were resolved
    • Apache Hive: default schema detection was implemented
    • Athena: driver version updated to 2.0.30
    • SQLite: table column delete was fixed
    • Vertica: default driver upgraded to version 12
    • Exasol: user list read was fixed (thanks to @allipatev)
    • DB2: driver version was updated to 11.5.7
    • MySQL/MariaDB: issue with grave accent quoting was fixed
    • OpenSearch driver configuration was added
    • The Default SSL truststore selection was fixed (it is now configurable)
    • Connection edit/create dialog performance was improved
    • The database server version is now shown in the connections’ tooltip
    • The object delete dialog was redesigned
    • The database create button was removed from the connection dialog for databases that don’t support it
    • Security patch for packaged drivers (additional validation of zip archives was added)
    • Intersystems Cache: community driver was added again
  • General UI:
    • Dark theme support was added to the XML editor
    • Dialog font settings are now applied to most popup dialogs
    • Database navigator quick filter now supports composite identifiers (thanks to @plotn)
    • Many minor UI bugfixes
    • UI perspective customization was fixed
  • Cloud Explorer and S3 browser:
    • Microsoft Azure support for SQL Server was added
    • The top-level checkbox was removed
    • The S3 folder names display was improved
    • The bug with deleting S3 folders and files was fixed
    • The option to create folders in S3 using File Explorer was added
    • Google BigQuery and Google Spanner were added to the Cloud Explorer
    • GCP support in the Cloud Explorer was improved
  • Data editor:
    • Refresh and row counts icons were updated
    • The status Details view was improved
    • Export options in UI were improved
    • The bug with complex data type displaying in the value panel with active record mode was fixed
    • URL transformer was fixed (for edit mode)
    • Grouping panel behavior was fixed
    • BLOB/CLOB viewer now shows smart warnings
    • NullPointer error was fixed in the spatial viewer
    • The “Hide all empty columns” action was added
    • The references panel now has a button to open the target table
    • Ordering by multiple columns was fixed
    • Filtering by spatial columns was fixed
    • URL transformer was fixed (original value edit is now supported)
    • LOB editor opening performance was significantly improved
    • SQL terminal now shows server output log
    • Column comments are now visible in record mode
    • Complex data types visualization was fixed for record mode
    • The value display format option was added to the grid data view
    • The Dictionary view panel now saves its ordering state
    • The row number in the record mode was fixed
    • Table columns resolution was improved for custom SQL queries
    • Hidden columns restore was fixed
    • The top and bottom action toolbars were redesigned
    • Action buttons now show hints
    • The data export toolbar button is now configurable
    • The image viewer was switched to embedded web browser mode (configurable)
    • The issue with the spatial data viewer was fixed (“no more handles” error)
    • Errors in virtual column definition are now handled properly
    • The “Count nulls” function was added to the Calc panel
    • The data export button UI was enhanced
    • Fetch all data and fetch size controls were returned to the status bar
    • The Lasso tool was added to the spatial viewer
    • Bug in spatial viewer initialization was fixed
    • Browser-based image viewer control was fixed (null or invalid images handle)
  • SQL editor:
    • The “Open in new tab” behavior was fixed
    • The issue with NULL column names in custom queries was fixed
    • SQL script active database/schema restore was fixed
    • Parameters prefix configuration was fixed
    • The issue with cursor change on context menu invocation was fixed
    • The option to disable all code completions/foldings were added
    • Auto-completion inside the SQL package was fixed
    • Table aliases auto-completion was fixed
    • SQL blocks auto-completion was fixed
    • SQL variables/parameters disable configuration was fixed
    • Auto-completion with the TAB key was implemented (!)
    • Hyperlink navigation was fixed for quoted identifiers and identifiers with spaces
    • The issue with keyword case auto-conversion was solved
    • Editor tabs now show the connection state icon (connected/failed)
    • Client-side commands prefix configuration was fixed
    • The issue with cursor position change on mouse right-click was resolved
    • Big SQL files support was improved (automatic disablement of syntax validation)
    • Table auto-completion tooltips UI was redesigned
    • Error on unassociated script opening was fixed
  • Data transfer:
    • The issue with the SMTP configuration was resolved
    • The bug with minimizing the Data Transfer wizard was fixed
    • The bug with blank cells in XLSX import was fixed
    • The display of a warning about override output files on data export to file was added
    • The data transfer process special case for Generics was improved
    • The bug with transferring data from XML to Table DT with a wrong column was fixed
    • ${schema} option to File name pattern in Backup/restore was added.
    • The bug with respect to column types with Excel files import was fixed
    • The fallback directory for data transfer tasks was added
    • The bug transfer binary data to Cassandra was fixed
    • Columns auto-mappings were improved (case-insensitive search)
    • Bug in CSV export with custom header format was fixed
    • Export to XLSX now supports different modes for spreadsheet rows append
    • The description column was added to XLSX format (configurable)
    • Additional confirmation is shown if the output file will be overwritten
    • A fallback directory was added for data export tasks
    • Columns mapping dialog was redesigned and improved
    • Columns scale/precision mapping was fixed
    • Import from XML format was fixed
    • Tables/column mapping dialog was improved, and problems with target column names were fixed
  • Database drivers:
    • Licenses for all of the packaged drivers were added
    • The display of driver information in the connection dialog was improved
    • The issue with driver jars re-download was fixed
    • It is now possible to disable Windows certificate storage usage
    • Driver version auto-update feature added
    • An issue with the driver download dialog was fixed (non-clickable dialog)
    • Driver license info button was added to the connection edit page
    • License information was added to the most drivers
    • It is no longer need to restart DBeaver after driver settings change (bug in recent versions)
  • Connections:
    • URL-based configuration support was added to PostgreSQL, SQL Server and Generic drivers
    • The network profile edit UI was fixed
    • Connection error messages
  • Data compare:
    • Tables comparison with different columns’ number was improved
    • The bug in the schema comparison between Teradata and Databricks was fixed
  • SSH:
    • The bug with the password in the SSH key was fixed
    • An issue with the redundant password prompt was fixed
    • The tunnel config tab is now hidden for databases that don’t support SSH
    • An issue with the private key password prompt was fixed
    • SSH user name is now optional (current user name is used)
    • SSH jump servers support was added for SSHJ implementation
    • The tunnel invalidation was fixed for SSHJ
  • Tasks:
    • The issue with the Task Scheduler setting on macOS was resolved
    • The debug logging on DT task execution was added
    • Tasks viewer now shows tasks only for the active project
    • New task create command enablement was fixed
    • Running tasks are now checked, and confirmation is shown on DBeaver app shutdown
    • Additional logging was added for tasks execution
    • A variable value prompt was added (configurable)
    • The issue with tasks operating with missing (deleted) tables was fixed
  • Visual Query Builder:
    • The bug with drag and drop tables was fixed
    • The issue with excessive relation on the diagram with more than two tables was resolved
    • The bug with displaying nullability and data types was fixed
    • The bug with an incorrect query when more than one column is dragged on the diagram to add a JOIN was fixed
    • The bug with displaying the query as a diagram was fixed
    • The bug with adding tables in PostgreSQL was fixed
    • Join tables visualization was improved
  • ERD:
    • The bug with saving diagrams was fixed
    • The issue with creating relationships between tables in edit mode was resolved
    • Association creation was fixed
  • Azure Cloud:
    • The extra dependencies were cleaned up
    • The access request process was improved
  • Netezza:
    • The bug with import .XLSX data into the database was fixed
    • The columns metadata read was improved
  • Clickhouse:
    • Execution Plan support was added
    • SSL connection configuration support was added
    • UUID data type support was added
    • Datetime64 data type support was added
    • SSL support was fixed
    • Driver version was updated (solves many data type conversion problems)
    • Driver version was updated, this resolves many issues with different data types’ support
    • Identifiers quoting was fixed (for non-ASCII characters)
  • MariaDB:
    • The issue with data transfer was fixed
    • UUID data type support was fixed
  • Snowflake:
    • The bug with executing SQL commands in Task manager was fixed
    • Java 17 support was added
    • Stored procedure and functions management was added
  • Fujitsu:
    • Fujitsu Postgres support was added
  • InfluxDB:
    • InfluxDB2 driver was added
    • The bug with incorrect order and filter in the query was fixed
    • The bug with opening the graphs was fixed
    • The tables reading was improved
    • The warning if the query result contains a lot of subtables was added
  • MongoDB:
    • The button “Show all databases” was added
    • The bug with execution db.test_col.find().toArray() query was fixed
  • Oracle:
    • The bug with missing attributes of key ‘VIRTUAL_PK’ in the result set was fixed
    • The bug with columns distortion when exporting data was fixed
    • Support MySQL in Oracle Cloud was added
    • Schema full DDL was added
    • DATE data type rendering was fixed (the time part was removed)
    • DATE data type rendering is now configurable
  • MySQL:
    • The default database client was changed to version 8+
    • JSON columns can now be used in filters and as keys
    • Hyperlinks navigation was fixed for procedures
    • Complex identifiers quoting was fixed
  • Redis:
    • The SSH connection process was improved
  • Greenplum:
    • The bug with the query re-triggered was fixed
    • SSL connection configuration support was added
    • The proper client app name is now sent to the server
    • Prepared statements usage was disabled
    • The table list read was fixed for recent GP server versions 6+
  • CouchDB:
    • The bug with unable to browse the database with a slash in the name was fixed
  • Couchbase
    • Couchbase Cloud support was added
  • Teradata:
    • Macros support has been added
    • LDAP to connection settings was added
    • The DBC level from the hierarchy tree was removed
  • SQL Server:
    • Issue with sequence value selection was fixed
    • It is now possible to disable the TOP clause in select queries
    • SQL Server driver was upgraded
  • PostgreSQL:
    • The bug with missing Inherited roles in the PG role DDL was fixed
    • The PostgreSQL JDBC driver was upgraded
    • Issue with the missing primary key in new tables was fixed
    • Table DDL for partitioned tables was fixed
    • Role comments are now visible/editable
    • Box data type support was improved
    • Issue with result sets fetch was fixed (OutOfMemory on big results)
    • Driver version was updated to 42.5.0 (security update)
    • The issue with numeric field formatting in struct types was fixed
    • Inherited roles support was added
    • Auth role editor was moved to the database level
    • The role create/edit command was fixed
    • PostgreSQL 15 support was improved (new data type category)
  • Localizations:
    • Chinese localization was improved
    • German localization was improved
    • Additional localization was done in many places in the application

下载地址

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 22.3 Multilingual (macOS, Linux, Windows), Dec 12, 2022
百度网盘链接:https://pan.baidu.com/s/13dbHCG34lGfFBAov_1y81A 提取码:v193


捐助本站 ❤️ Donate

点击访问官方网站


文章用于推荐和分享优秀的软件产品及其相关技术,所有软件默认提供官方原版(免费版或试用版),免费分享。对于部分产品笔者加入了自己的理解和分析,方便学习和测试使用。任何内容若侵犯了您的版权,请联系作者删除。如果您喜欢这篇文章或者觉得它对您有所帮助,或者发现有不当之处,欢迎您发表评论,也欢迎您分享这个网站,或者赞赏一下作者,谢谢!

支付宝赞赏 微信赞赏

赞赏一下


☑️ 评论恢复,欢迎留言❗️
敬请注册!点击 “登录” - “用户注册”。社交媒体联合登录无法接收通知邮件。已知不支持 21.cn/189.cn 邮箱。