适用于各种 DBMS 系统的 Linux 最佳免费 SQL GUI 是什么
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/1001710/
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
What is the best free SQL GUI for Linux for various DBMS systems
提问by Phill Pafford
As I make the full switch from Windows to Linux (CentOS 5) I'm in search of the best free GUI SQL Client tool for MSSQL, MySQL, Oracle, etc... any suggestions?
当我从 Windows 完全切换到 Linux (CentOS 5) 时,我正在寻找适用于 MSSQL、MySQL、Oracle 等的最佳免费 GUI SQL 客户端工具……有什么建议吗?
I've tried DBVisualizer (The best bet so far but still limited by the free version, not all functionality is there), MySQL GUI Tools (Good but only for MySQL, need other DB's as well) and Aqua Data Studio (Same as DBVis, it's good but a lot of the functionality is missing in the free version).
我尝试过 DBVisualizer(迄今为止最好的选择,但仍受免费版本的限制,并非所有功能都在那里)、MySQL GUI 工具(很好,但仅适用于 MySQL,还需要其他数据库)和 Aqua Data Studio(与 DBVis 相同) ,这很好,但免费版本中缺少很多功能)。
采纳答案by Phill Pafford
I'm sticking with DbVisualizer Free until something better comes along.
我坚持使用 DbVisualizer Free,直到出现更好的东西。
EDIT/UPDATE: been using https://dbeaver.io/lately, really enjoying this
编辑/更新:最近一直在使用https://dbeaver.io/,真的很喜欢这个
回答by Chi
For Oracle, I highly recommend the free Oracle SQL Developer
对于 Oracle,我强烈推荐免费的 Oracle SQL Developer
http://www.oracle.com/technology/products/database/sql_developer/index.html
http://www.oracle.com/technology/products/database/sql_developer/index.html
The doucmentation states it also works with non-oracle databases - i've never tried that feature myself, but I do know that it works really well with Oracle
文档说明它也适用于非 Oracle 数据库 - 我自己从未尝试过该功能,但我知道它与 Oracle 一起工作得非常好
回答by sleske
I can highly recommend Squirrel SQL.
我强烈推荐Squirrel SQL。
Also see this similar question:
另请参阅此类似问题:
回答by Francisco Albert
I tried many GUI's, and the best for me continue being "SQLyog-comunity" by using wine. Is complete, is nice, and is intuitive. (and in wine work perfect)
我尝试了很多图形用户界面,对我来说最好的继续是使用葡萄酒的“SQLyog-comunity”。完整、美观、直观。(在葡萄酒中工作完美)
回答by Tomassino
I use SQLite Database Browserfor SQLite3 currently and it's pretty useful. Works across Windows/OS X/Linux and is lightweight and fast. Slightly unstable with executing SQL on the DB if it's incorrectly formatted.
我目前将SQLite 数据库浏览器用于 SQLite3,它非常有用。适用于 Windows/OS X/Linux,并且轻量级和快速。如果格式不正确,则在 DB 上执行 SQL 时会稍微不稳定。
Edit: I have recently discovered SQLite Manager, a plugin for Firefox. Obviously you need to run Firefox, but you can close all windows and just run it "standalone". It's very feature complete, amazingly stable and it remembers your databases! It has tonnes of features so I've moved away from SQLite Database Browser as the instability and lack of features is too much to bear.
编辑:我最近发现了SQLite Manager,这是一个 Firefox 插件。显然您需要运行 Firefox,但您可以关闭所有窗口并“独立”运行它。它的功能非常完整,非常稳定,并且可以记住您的数据库!它有大量的功能,所以我已经放弃了 SQLite 数据库浏览器,因为它的不稳定性和缺乏功能太难以忍受了。