前言
提示:这里介绍了一个免费开源的数据库可视化工具DBeaver
提示:以下是本篇文章正文内容,下面案例可供参考
一、Navicat
1.Navicat介绍
Navicat 是一套数据库开发工具,让你从单一应用程序中同时连接 MySQL、MariaDB、MongoDB、SQL Server、Oracle、PostgreSQL 和 SQLite 数据库。它与 Amazon RDS、Amazon Aurora、Amazon Redshift、Microsoft Azure、Oracle Cloud、MongoDB Atlas、阿里云、腾讯云和华为云等云数据库兼容。你可以快速轻松地创建、管理和维护数据库。
2.优缺点
缺点:收费
二、DBeaver
1.DBeaver介绍
Free multi-platform database tool for developers, SQL programmers, database administrators and analysts.
Supports any database which has JDBC driver (which basically means - ANY database). Commercial versions also support non-JDBC datasources such as MongoDB, Cassandra, Couchbase, Redis, BigTable, DynamoDB, etc. You can find the list of all databases supported in commercial versions here.
- Has a lot of features including metadata editor, SQL editor, rich data editor, ERD, data export/import/migration, SQL execution plans, etc.
- Based on Eclipse platform.
- Uses plugins architecture and provides additional functionality for the following databases: MySQL/MariaDB, PostgreSQL, Greenplum, Oracle, DB2 LUW, Exasol, SQL Server, Sybase/SAP ASE, SQLite, Firebird, H2, HSQLDB, Derby, Teradata, Vertica, Netezza, Informix, etc.
开源、 免费、持续更新,功能好用
给个官网下载链接:https://dbeaver.io/download/
2.支持的数据库类型丰富
有多个数据库类型文件可以同在一个目录,使用一个类型的数据库时需要下载对应的驱动文件即可
ER 图和导出sql 都是支持的
总结
参考文章
再见收费的Navicat,良心推荐开源工具DBeaver,支持几乎所有库
图片地址:天使报喜https://www.allhistory.com/