DBeaver Ultimate Edtion 24 for macOS Intel x64 & Apple ARM64 (sysin) - 通用資料庫工具

sysin發表於2024-04-04

One tool for all data sources

請訪問原文連結：https://sysin.org/blog/dbeaver-mac/，檢視最新版。原創作品，轉載請保留出處。

作者主頁：sysin.org

DBeaver 24 釋出

通用資料庫工具

DBeaver 是一個通用的資料庫管理工具，適用於需要以專業方式處理資料的每個人。使用 DBeaver，您可以像在常規電子表格中一樣處理資料，根據來自不同資料儲存的記錄建立分析報告，以適當的格式匯出資訊 (sysin)。對於高階資料庫使用者，DBeaver 建議使用強大的 SQL 編輯器、大量管理功能、資料和模式遷移能力、監控資料庫連線會話等等。開箱即用的 DBeaver 支援 80 多種資料庫。

支援的資料庫

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