Linux 替代 Sequel Pro?(基于 GUI 的 sql 导航器)
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/7759725/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Linux alternatives to Sequel Pro? (GUI based sql navigator)
提问by Walker
Anyone have any suggestions? Running Debian and looking for a good alternative.
有人有什么建议吗?运行 Debian 并寻找一个好的选择。
采纳答案by meouw
I use phpmyadminand find it adequate for most purposes, however I use greasemonkey to enhance various aspects. Here are a number of such scripts, you can of course write one on your own.
Another alternative is HeidiSQL. This is a Windows-only ® app but runs pretty well using Wine.
Then there is MySQL Workbench which has been mentioned in other posts. I don't find its query capabilities as fluid as phpmyadmin but generating ERD with it and synchronising with the database is pretty slick.
我使用phpmyadmin并发现它适用于大多数用途,但是我使用油脂猴来增强各个方面。这里有一些这样的脚本,你当然可以自己写一个。
另一种选择是HeidiSQL。这是一个仅限 Windows ® 的应用程序,但使用 Wine 运行得非常好。
然后是其他帖子中提到的 MySQL Workbench。我没有发现它的查询功能像 phpmyadmin 那样流畅,但是用它生成 ERD 并与数据库同步非常巧妙。
回答by codelol
MySQL Workbenchis a great and cross platform tool. The UI might not look as slick as Sequel Pro but the features it provides are good enough.
MySQL Workbench是一个很棒的跨平台工具。用户界面可能看起来不像 Sequel Pro 那样光滑,但它提供的功能已经足够好了。
回答by gregmac
phpMyAdmin is pretty simple and standard. Because it is web based, no installation required.
phpMyAdmin 非常简单和标准。因为它是基于网络的,所以不需要安装。
回答by Idealmind
Yes! The last version of MySQL Workbench, in linux, is better than Sequel Pro.
是的!MySQL Workbench 的最后一个版本,在 linux 中,比 Sequel Pro 更好。
With MySQL Workbench you can easily query, export data as csv and other formats, edit table data. It has a query guide inside. You can see the schema list, the table list, the columns for each table, the query box and the query result, everything at the same time.
使用 MySQL Workbench,您可以轻松查询、将数据导出为 csv 等格式、编辑表格数据。它里面有一个查询指南。您可以同时看到架构列表、表列表、每个表的列、查询框和查询结果,所有内容。
回答by styks
vStudioon linux or windows. I did have some problems with it crashing on linux but just updated to the latest version and it seems to run ok. It has a nice query editor and allows you to save your servers and projects. It is the best I have found so far.
linux 或 windows 上的vStudio。我确实遇到了一些问题,它在 linux 上崩溃,但刚刚更新到最新版本,它似乎运行正常。它有一个很好的查询编辑器,并允许您保存您的服务器和项目。这是迄今为止我发现的最好的。
Navicatis a paid client. I have only used it once but it fell short of expectations.
Navicat是付费客户。我只用过一次,但没有达到预期。
回答by David Gara?a
There are a few different options that I know of, depending on the platform you are running it on. You could use the following:
我知道有几种不同的选项,具体取决于您运行它的平台。您可以使用以下内容:
- Linux: Dbeaver
- Windows: HeidiSQL
- Mac: SequelPro
- Linux:Dbeaver
- 视窗:HeidiSQL
- Mac:SequelPro
回答by timg
try sqlyog, awesome and the community edition is free.
试试sqlyog,真棒,社区版是免费的。
回答by Prabhu Nandan Kumar
I recommend phpmyadmin or mysql workbench is best for any kind of DB GUI.
我推荐 phpmyadmin 或 mysql workbench 最适合任何类型的 DB GUI。
To setup phpmyadmin click herefor complete guide.
要设置 phpmyadmin,请单击此处获取完整指南。
To download mysql workbench you can simple go in ubuntu software and search mysql workbench and install it. You can click hereto download complete offline installer for mysql workbench according to your OS. By terminal you have to follow these steps click here
要下载 mysql workbench,您可以简单地进入 ubuntu 软件并搜索 mysql workbench 并安装它。您可以单击此处根据您的操作系统下载完整的 mysql 工作台离线安装程序。通过终端你必须按照这些步骤点击这里
回答by mafazans
im using SQLyog under wine
我在 wine 下使用 SQLyog
i think SQLyog have a good feature, not as much as mysql workbench but much faster
我认为 SQLyog 有一个很好的功能,不如 mysql workbench 但快得多
the paid version maybe even better
付费版本可能更好
回答by Leworoe
I recommend TablePlus: tableplus.com
我推荐 TablePlus: tableplus.com