首页 > 数据库 >DBeaver Ultimate Edtion 23.1 Multilingual (macOS, Linux, Windows) - 通用数据库工具,现已集成 ChatGPT

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

时间:2023-06-15 14:36:18浏览次数:262  
标签:macOS database Windows Multilingual DBeaver source SQL relational data

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

One tool for all data sources

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

作者主页:sysin.org


通用数据库工具

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

dbeaver-on-macos

支持的数据库

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

DBeaver 23.0(点击可查看最新版 changelog)

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

ChatGPT 在哪里

我们知道你们中的许多人已经尝试过 我们的新功能——GPT-3 AI Assitant,它可以帮助您使用人类语言的句子快速创建 SQL 查询。最新版本的 DBeaver PRO 包含改进的 GPT-3 Smart Completion,其中包括自动查询格式、保存应用程序重启之间的历史记录以及其他完成设置。如果您的数据库架构很大而 AI Assistant 无法处理,您现在可以自定义范围并仅选择您要使用的表。

img

GPT-3 Smart Completion 在 DBeaver Enterprise、Ultimate 和 Team Edition 中开箱即用。默认情况下,该功能被禁用。要打开它,请转到首选项 -> 编辑器 -> AI(ChatGPT)并选中“启用智能完成”框。

下载地址

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://pan.baidu.com/s/1UCrY-7IEVfmVYn6LNNzycg?pwd=xf6k

DBeaver Ultimate Edtion 23.1 Multilingual (macOS, Linux, Windows), Jun 14, 2023
百度网盘链接:https://sysin.org/blog/dbeaver-23/

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

for LinuxDBeaver Ultimate Edtion 23 for Linux deb (sysin)

All Version:DBeaver Ultimate Edtion 23.1 Multilingual (macOS, Linux, Windows) - 通用数据库工具,现已集成 ChatGPT

标签:macOS,database,Windows,Multilingual,DBeaver,source,SQL,relational,data
From: https://www.cnblogs.com/sysin/p/17482774.html

相关文章

  • 在 Apple silicon Mac 上 DFU 模式修复或恢复 macOS 固件
    搭载Apple芯片的Mac电脑DFU模式全新安装macOSVentura请访问原文链接:https://sysin.org/blog/apple-silicon-mac-dfu/,查看最新版。原创作品,转载请保留出处。作者主页:sysin.orgMaccomputerswithApplesilicon,简称ApplesiliconMac,中文翻译为“搭载Apple芯片的M......
  • Windows上安装Rust
    1.下载RUSTUP-INIT.EXE下载地址:https://www.rust-lang.org/tools/install2.配置环境变量,设置更新源#字节跳动的更新源RUSTUP_DIST_SERVER=https://rsproxy.cnRUSTUP_UPDATE_ROOT=https://rsproxy.cn/rustup3.执行RUSTUP-INIT.EXE开始安装,初学者建议按14.等着被恭......
  • windows环境下操作,同一台机器 如何跑两个mysql服务?
    在同一台机器上运行两个MySQL服务是可行的,但需要注意以下几点:确保端口号不冲突。每个MySQL服务都需要监听一个独立的端口,以便客户端可以连接到正确的服务。配置文件的区分。每个MySQL实例需要有自己独立的配置文件,包括数据存储路径、日志文件路径等信息。确保资源......
  • 【Windows】百度网盘桌面“同步空间”图标删除
    ✨百度网盘桌面“同步空间”图标桌面出现“同步空间图标”右键无法删除✨解决方案搜索注册表编辑器或者regedit在注册表编辑器中,编辑>查找:同步空间,删除相关项!注意:搜索出来同步空间相关项较多,如仅需删除桌面图标请直接定位到计算机\HKEY_LOCAL_MACHINE\SOFTWARE\Mic......
  • [-002-]-Python3+Unittest+Uiautomation Windows桌面App UI自动化之鼠标操作
    1、单击鼠标左键Click(x:int,y:int,waitTime:float=OPERATION_WAIT_TIME)模拟鼠标在点x,y的点击。OPERATION_WAIT_TIME默认为0.5即等待时间默认为0.5秒2、单击鼠标中键MiddleClick(x:int,y:int,waitTime:float=OPERATION_WAIT_TIME)模拟鼠标在点x,y......
  • CentOS搭建NFS服务、windows挂载权限问题; NFS读写缓慢调优
    CentOS搭建NFS服务、windows挂载权限问题CentOS和统信UOS(与ubuntu一样)命令不一样,但操作大同小异,参考如下:https://blog.csdn.net/wangzongyu/article/details/127009158 windows读写linux搭建的NFS内文件是比较慢,调优:https://blog.csdn.net/yysalad/article/details/11736623......
  • DataX在Windows上实现Mysql到Mysql同步数据以及配置多个job/多个表同步定时执行bat
    场景DataX-阿里开源离线同步工具在Windows上实现Sqlserver到Mysql全量同步和增量同步:https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/130330353DataX-在Windows上实现postgresql同步数据到mysql:https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/130......
  • windows php7、PHPStudy(小皮)配置oracle扩展
    一、php配置oci扩展1.访问链接下载对应oracle版本的即时客户端(OracleInstantClient)https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html  2.解压下载文件,将下面两个文件放入php目录下   3.访问链接https://windows.php.net/down......
  • windows 11安装telnet教程
    很多时候我们需要使用telnet命令,ping端口通不通,所以得先安装下系统自带的telnet工具。telnet工具日常还是非常好用的。如果未安装则会提示:'telnet'不是内部或外部命令,也不是可运行的程序或批处理文件。 下面介绍两种方式,一个是老的操作方式,在"控制面板"中安装,另一个是在win......
  • Windows安装多版本MySQL(命令行)
    注意:电脑上可以多个数据库版本共存,但是在初次安装执行mysqld-installmysql的时候需要将mysql替换为唯一的名字,并且环境变量只能配置一个1.windows中下载指定版本官网下载命令行版本:https://dev.mysql.com/downloads/mysql/解压到指定位置编写my.ini文件[mysqld]#设......