MySQL 直接访问数据库的开发者工具
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/721852/
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
Developer tools to directly access databases
提问by Kapsh
I work with several different databases and find myself trying connecting to these quite often to test a query. I use the database specific tools to connect to the DB and run the query.
我使用了几个不同的数据库，发现自己经常尝试连接到这些数据库来测试查询。我使用特定于数据库的工具连接到数据库并运行查询。
I find these DB specific tools like SQL Query Analyzer (SQL-Server), Oracle Enterprise Manager, MySQL Query Browser to be quite clunky and slow when it comes to running quick queries and looking at data directly. It is also hard to remember all the userids and pwds for the develop and test databases.
我发现这些特定于数据库的工具，如 SQL 查询分析器 (SQL-Server)、Oracle 企业管理器、MySQL 查询浏览器，在运行快速查询和直接查看数据时非常笨拙和缓慢。也很难记住开发和测试数据库的所有用户 ID 和密码。
What tools do you use as developers to connect to the database of choice? I use Eclipse as an IDE. So any Eclipse specific tips are also appreciated.
作为开发人员，您使用哪些工具连接到所选数据库？我使用 Eclipse 作为 IDE。因此，任何 Eclipse 特定提示也值得赞赏。
Even if a tool were to work with one DB and not with the other, I am willing to look into it if it were more user-friendly than the one the DB vendor provides. I am already using 3 different ones.
即使某个工具适用于一个数据库而不是另一个数据库，如果它比数据库供应商提供的工具更方便用户使用，我也愿意研究它。我已经在使用 3 种不同的了。
回答by tpdi
SQuirreL, written in java, will work with any RDBMS for which there's a JDBC driver.
SQuirreL是用 Java 编写的，可以与任何具有 JDBC 驱动程序的 RDBMS 一起使用。
It works very well for both sending SQL, rendering result sets, and allowing browsing of database objects (from a tree). For several RDBMS, it includes extensions to automatically generate common statements.
它非常适用于发送 SQL、呈现结果集和允许浏览数据库对象（从树中）。对于几个 RDBMS，它包括自动生成通用语句的扩展。
Especially nice is that the query pane executes either the selected sql, or the line the cursor is on up to the first blank line. This allows you to write several statements, and to execute them either individually or in a batch.
特别好的是查询窗格执行选定的 sql，或者光标所在的行直到第一个空行。这允许您编写多个语句，并单独或批量执行它们。
And it's free and open source.
而且它是免费和开源的。
回答by cletus
I've used quite a few.
我用了好几个。
- PL/SQL Developer: as the name implies this is Oracle specific but is by far my favourite DB tool. It greatly simplifies import/export;
- Toad: Also Oracle-specific. I used to be a big fan of this but it's expensive and I think more DBA-oriented these days. For a developer I don't think it offers all that much (given the price difference) over PL/SQL Developer;
- DBVisualizer: this tool isn't bad. I'm not sure the commercial version is worth the price they're asking for it. The free version is OK. It's good that it works with pretty much any database;
- Navicat for MySQL: it's OK but honestly I wouldn't pay for it;
- SQL Server management Studio: comes with SQL Server. I don't think I really need much more for SQL Server than this except perhaps a better way of importing/exporting databases, soemthing for which this is garbage;
- Oracle SQL Developer: this is the poor man's tool you use on Linux when you don't have much other choice. It's fairly basic but OK given that it's free.
- PL/SQL Developer：顾名思义，这是特定于 Oracle 的，但迄今为止我最喜欢的数据库工具。它大大简化了导入/导出；
- Toad：也是特定于 Oracle 的。我曾经是这个的忠实粉丝，但它很贵，而且我认为现在更面向 DBA。对于开发人员，我认为它并没有比 PL/SQL Developer 提供那么多（考虑到价格差异）；
- DBVisualizer：这个工具还不错。我不确定商业版本是否值得他们要求的价格。免费版没问题。它几乎适用于任何数据库，这很好；
- Navicat for MySQL：还可以，但老实说我不会为此付费；
- SQL Server management Studio：SQL Server 自带。我认为对于 SQL Server，我真的不需要比这更多的东西了，除了可能是一种更好的导入/导出数据库的方法，这对它来说是垃圾；
- Oracle SQL Developer：当您别无选择时，这是您在 Linux 上使用的穷人工具。这是相当基本的，但鉴于它是免费的，所以还可以。
回答by gsnerf
Also a nice tool is the AquaDataStudio
AquaDataStudio也是一个不错的工具
回答by majkinetor
When it comes to stuff like this, I prefer portable tools. Installed once, you can put them on flash or CD and carry with you. Connecting to DB should be easy as filling out usual fields: server, user, pwd..
说到这样的东西，我更喜欢便携式工具。安装一次，您可以将它们放在闪存或 CD 上随身携带。连接到数据库应该很容易，就像填写通常的字段一样：服务器、用户、密码..
Sql BuddyDecent one, open source, with syntax highlighting & code completition. Not recently updated but it generally works OK.
Sql Buddy体面的一款，开源，具有语法高亮和代码补全。最近没有更新，但它通常可以正常工作。
GiPo@DB UtilitiesVery nice one, has all of the above features plus its more feature filled as it was previously commercial.
GiPo@DB 实用程序非常好的一个，具有上述所有功能以及以前商业化的更多功能。
Mentioned tools are not more then few MBs in size and it takes 1 minute to install them and copy them to your portable location.
提到的工具大小不超过几 MB，安装它们并将它们复制到您的便携式位置需要 1 分钟。
回答by Csaba_H
Within Eclipse you can use the Eclipse Data Tools Platformfor doing database development. In recent versions you can find some kind of visual query builderas well. Oracle has a plugin for DTPand implements some Oracle-specific functions.
在 Eclipse 中，您可以使用Eclipse Data Tools Platform进行数据库开发。在最近的版本中，您还可以找到某种可视化查询构建器。Oracle 有一个DTP 插件并实现了一些 Oracle 特定的功能。
回答by Kevin Williams
I've used:
我用过：
I prefer DBVisualizer, but it's a bit of a memory hog so it might not be the right solution if your resources are an issue.
我更喜欢 DBVisualizer，但它有点占用内存，因此如果您的资源有问题，它可能不是正确的解决方案。
I've tried the eclipse plugins as well. For me I'd rather keep eclipse optimized to do the work it's meant to do.
我也试过eclipse插件。对我来说，我宁愿保持 Eclipse 优化来完成它应该做的工作。
回答by Hugues Van Landeghem
Database Workbench can be use for Oracle - SQL Server and MySQL
Database Workbench 可用于 Oracle - SQL Server 和 MySQL
回答by user114285
Aqua Data Studioand RapidSQLare two great tools/IDEs for sql development. You can connect almost any database engine and they include some vendor specific features for say Oracle etc..
Aqua Data Studio和RapidSQL是用于 sql 开发的两个很棒的工具/IDE。您几乎可以连接任何数据库引擎，它们包括一些供应商特定的功能，例如 Oracle 等。
Also since you use Eclipse IDE, you may consider Eclipse Data Tools Platform or QuantumDB plugin.
此外，由于您使用 Eclipse IDE，您可以考虑使用 Eclipse Data Tools Platform 或 QuantumDB 插件。
回答by ik_zelf
The tools depends a bit of the kind of work to do. For most browsing I go for DbVisualizer, I can customize it exactly to my needs. The support is good and responsive. For pl/sql editing I prefer oracle sqldeveloper. DbVisualizer is not a free tool but the price is fair, maybe even cheap when compared to Toad. It is also multi database but this is implemented in such a way that I am not limited in my oracle world and it helps me navigating on other vendor rdbms that I don't know so well. For real time monitoring DbVisualizer has a very nice option that I have not seen in any other application. VERY usable if you are trying to debug some, for example, performance problems.
这些工具在一定程度上取决于要做的工作。对于我使用DbVisualizer 的大多数浏览，我可以完全根据我的需要对其进行自定义。支持很好，反应灵敏。对于 pl/sql 编辑，我更喜欢 oracle sqldeveloper。DbVisualizer 不是免费工具，但价格公道，与 Toad 相比甚至可能便宜。它也是多数据库，但它的实现方式使我不受我的 oracle 世界的限制，它帮助我在我不太了解的其他供应商 rdbms 上导航。对于实时监控，DbVisualizer 有一个非常好的选项，我在任何其他应用程序中都没有见过。如果您尝试调试某些（例如）性能问题，则非常有用。
