什么是 PL/SQL 开发的完美工具箱?

2021-12-24 00:00:00 oracle plsql

几个月以来，我参与了两个项目，其中包含大量 PL/SQL 代码.

I work on two projects with a lot of PL/SQL code since few months.

然而，我没有找到任何真正有趣的工具来开发这种语言.

However, I didn't find any really interesting tools to develop on this langage.

目前，我的配置包括以下工具:

For the moment, my configuration includes the following tools:

  • Eclipse (应用程序的其余部分是用 Java 开发的)，使用 PL/SQL 编辑器插件
  • 因为我真的不喜欢也不信任 Eclipse 的 PL/SQL 编辑器插件，所以我主要使用 PsPad用于编辑我的 PL/SQL 文件.
  • SQL Developer(我也有 TOAD，但我不太了解/喜欢这个工具).
  • Eclipse (the rest of the application is developed in Java), with PL/SQL Editor plugin
  • As I really don't like and trust the PL/SQL Editor plugin for Eclipse, I use mainly PsPad for editing my PL/SQL files.
  • SQL Developer (I have also TOAD, but I don't really know/like this tool).

那么，您开发 PL/SQL 应用程序的完美"工具箱是什么?

So what is your "perfect" toolbox for developing PL/SQL applications?

我还了解到 SQL Developer 2.1 引入了 PL/SQL 单元测试功能.有没有人对这个功能和这个版本的 SQL Developer 有反馈(我还在用 1.5)?

I've also read that SQL Developer 2.1 introduces a PL/SQL unit testing feature. Does anybody has a feedback about this feature and this version of SQL Developer (I still use 1.5) ?

推荐答案

作为一个老式的家伙，我仍然主要与 SQL*Plus 和 TextPad IDE.TextPad 是 nagware，但许可证很便宜，而且该工具有一些很棒的功能.人们也为它编写了 PLSQL 语法库，它为您提供关键字突出显示.也可以将 TextPad 连接到其他桌面工具，例如 Subversion.

Being an old-fashioned sort of chap I still mainly get along with SQL*Plus and the TextPad IDE. TextPad is nagware, but the licence is cheap and the tool has some fantastic features. Also people have written PLSQL syntax libraries for it, which give you keyword highlighting. It is also possible to hook TextPad into other desktop tools such as Subversion.

SQL^Developer 是用 java 编写的，这意味着它是一个贪婪的内存消费者.拥有数据浏览器仍然有无可置疑的优点.即将推出的 2.1 版还具有内置单元测试，这可能非常好吃.

SQL^Developer is written in java, which means it is a voracious consumer of memory. Still there is undoubted merit in having a data browser. Also the upcoming version 2.1 features built-in unit test, which could be very tasty.

实用工具:

  • pldoc :: 生成 Javadoc 样式来自评论中的文档您的包装规格
  • utplsql :: 单元测试工具；旧但它仍然有效
  • QUTO :: 另一个，更多复杂的单元测试工具(我不使用相同的我还在用的原因SQL*Plus 和 TextPad)
  • QGCU :: PL/SQL 代码生成器(以前是 QNXO)
  • pldoc :: generate Javadoc-style documentation from the comments in your package spec
  • utplplsql :: unit test harness; old but it still works
  • QUTO :: another, more sophisticated unit test harness (which I don't use for the same reason I'm still hacking with SQL*Plus and TextPad)
  • QGCU :: PL/SQL code generator (previously QNXO)

捍卫卢德主义

使用 TOAD 和 SQL*Developer 等工具的危险在于，它们允许我们直接针对数据库执行 DML 和 DDL，包括编辑 PL/SQL 源代码.这很好，很花哨，而且非常符合完成任务"的精神.直到我们需要恢复我们的更改.或者生产 DBA 需要一个脚本....

The danger with tools like TOAD and SQL*Developer is that they allow us to execute DML and DDL directly against the database, including editing PL/SQL source. This is fine and dandy and awfully in the spirit of Getting Things Done. Until we need to revert our changes. Or the production DBA demands a script....

当然可以以安全的方式使用 TOAD 或 SQL Developer - 我知道 SQL Developer 也可以连接到源代码控制 - 如果只是需要更多的自律.

Of course it is possible to use TOAD or SQL Developer in a safe fashion - I know SQL Developer can hook into source control as well - if just requires more self-discipline.

相关文章