开发工具直接访问数据库 [英] Developer tools to directly access databases
问题描述
我使用了几个不同的数据库，并发现自己尝试连接到这些经常来测试一个查询。我使用数据库专用工具连接到数据库并运行查询。
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.
我发现这些数据库特定的工具，如SQL查询分析器（SQL-服务器），Oracle企业管理器，MySQL查询浏览器在运行快速查询和直接查看数据时非常笨重和缓慢。也很难记住开发和测试数据库的所有用户ID和pwds。
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.
您使用什么工具作为开发人员连接到所选择的数据库？我使用Eclipse作为IDE。所以任何Eclipse特定的提示也赞赏。
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.
即使一个工具是与一个数据库，而不是与其他工作，我愿意调查它，如果它是比DB供应商提供的更友好。我已经使用了3个不同的。
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.
推荐答案
SQuirreL 用Java编写，将与任何有JDBC驱动程序的RDBMS配合使用。
SQuirreL, written in java, will work with any RDBMS for which there's a JDBC driver.
发送SQL，呈现结果集，以及允许浏览数据库对象（从树）。对于多个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或光标所在的行第一个空白行。
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.
这是免费开源的。
这篇关于开发工具直接访问数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
