MySQL 适用于 Windows 的 Sequel Pro 替代品
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/6817551/
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
Sequel Pro Alternative for Windows
提问by Mark McCook
Well my macbook pro is kind of not cutting it for me anymore and I have a perfectly good Windows Laptop I would actually rather use but I cannot find a reliable replacement for my SQL client. So I am looking for a replacement for SequelPro for Windows..
好吧,我的 macbook pro 不再适合我了,我有一台非常好的 Windows 笔记本电脑,我实际上宁愿使用,但我找不到可靠的 SQL 客户端替代品。所以我正在寻找 SequelPro for Windows 的替代品。
Ones I have Tried and Either Didn't like or found a few issues with.
我尝试过但不喜欢或发现一些问题的那些。
Navicat - This one when left inactive for more than 15 minutes crashes.. I don't mind that it wants to disconnect but please do it gracefully with out locking up my system for a few minutes.
Navicat - 这个在不活动超过 15 分钟时崩溃.. 我不介意它想断开连接,但请优雅地完成它,不要将我的系统锁定几分钟。
SQLyog - Works well but I would like something with atleast a free for non-commercial use. I don't do any freelance and rarely do I do any of my 'work' on my personal laptop.
SQLyog - 效果很好,但我想要一些至少可以免费用于非商业用途的东西。我不做任何自由职业者,也很少在我的个人笔记本电脑上做任何“工作”。
So does anyone have any suggestions?
那么有人有什么建议吗?
采纳答案by TehShrike
I use SQLYog at home and work. It turns out they DO have a free open-source version, though sadly they've been trying to hide that fact for the last few years.
我在家里和工作中使用 SQLYog。事实证明,他们确实有一个免费的开源版本,尽管遗憾的是他们在过去几年里一直试图隐藏这一事实。
You can download the open-source version from https://github.com/webyog/sqlyog-community- just click the "Download SQLyog Community Version" link.
您可以从https://github.com/webyog/sqlyog-community下载开源版本- 只需单击“下载 SQLyog 社区版本”链接。
回答by Spudley
You say you've had problems with Navicat. For the record, I use Navicat and I haven't experienced the issue you describe. You might want to dig around, see if there's a reason for your problem and/or a solution, because given the question asked, my first recommendation would have been Navicat.
你说你在使用 Navicat 时遇到了问题。作为记录,我使用 Navicat 并且我没有遇到您描述的问题。您可能想四处寻找,看看您的问题和/或解决方案是否有原因,因为鉴于提出的问题,我的第一个建议是 Navicat。
But if you want alternative suggestions, here are a few that I know of and have used:
但是,如果您想要其他建议,这里有一些我知道并使用过的建议:
MySQL has its own tool which you can download for free, called MySQL Workbench. Download it from here: http://wb.mysql.com/. My experience is that it's powerful, but I didn't really like the UI. But that's just my personal taste.
MySQL 有自己的工具,您可以免费下载,称为MySQL Workbench。从这里下载:http: //wb.mysql.com/。我的经验是它很强大,但我并不真正喜欢 UI。但这只是我个人的口味。
Another free program you might want to try is HeidiSQL. It's more similar to Navicat than MySQL Workbench. A colleague of mine loves it.
您可能想尝试的另一个免费程序是HeidiSQL。它比 MySQL Workbench 更类似于 Navicat。我的一个同事喜欢它。
(interesting to note, by the way, that MariaDB (the forked version of MySQL) is currently shipped with HeidiSQL as its GUI tool)
(顺便说一下,有趣的是,MariaDB(MySQL 的分叉版本)目前附带 HeidiSQL 作为其 GUI 工具)
Finally, if you're running a web server on your machine, there's always the option of a browser-based tool like PHPMyAdmin. It's actually a surprisingly powerful piece of software.
最后,如果你在你的机器上运行一个 web 服务器,那么总是有一个基于浏览器的工具的选项,比如PHPMyAdmin。它实际上是一个非常强大的软件。
回答by Brendan Bullen
Toad for MySQL by Questis free for non-commercial use. I really like the interface and it's quite powerful if you have several databases to work with (for example development, test and production servers).
Toad for MySQL by Quest可免费用于非商业用途。我真的很喜欢这个界面,如果你有几个数据库可以使用(例如开发、测试和生产服务器),它会非常强大。
From the website:
从网站:
Toad? for MySQL is a freeware development tool that enables you to rapidly create and execute queries, automate database object management, and develop SQL code more efficiently. It provides utilities to compare, extract, and search for objects; manage projects; import/export data; and administer the database. Toad for MySQL dramatically increases productivity and provides access to an active user community.
蟾蜍?for MySQL 是一款免费软件开发工具,可让您快速创建和执行查询、自动化数据库对象管理以及更高效地开发 SQL 代码。它提供了用于比较、提取和搜索对象的实用程序;管理项目;导入/导出数据;并管理数据库。Toad for MySQL 可显着提高生产力并提供对活跃用户社区的访问。
回答by alexblum
You can try DBVisualizersome features are not free, but you can get an evaluate license...
您可以尝试DBVisualizer某些功能不是免费的,但您可以获得评估许可证...