Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

Ovid (2709)

Ovid
  (email not shown publicly)
http://publius-ovidius.livejournal.com/
AOL IM: ovidperl (Add Buddy, Send Message)

Stuff with the Perl Foundation. A couple of patches in the Perl core. A few CPAN modules. That about sums it up.

Journal of Ovid (2709)

Friday December 10, 2004
12:36 PM

Testing build systems (and griping about Oracle)

[ #22252 ]

Testing is not that hard once you get used to it. Testing random things is a bit harder. Testing build systems seems to be the hardest of all. There are so many interdependent things that I was thinking about using state machines to ensure that the build process works correctly. Any state machine modules on the CPAN you recommend? There are some out there, but I've no idea which area really worth the trouble.

In other news, anyone who really knows Oracle is convinced of its power because Oracle really is powerful ... if you know how to tune it. Tuning Oracle is a black art that many are unfamiliar with but it pays huge dividends. Thus, for many applications Oracle can be the way to go despite its cost. Yet, for all the money that Oracle makes, why the hell can't they come up with a decent command line client? I've been working with Oracle's SQL*Plus for over a year and just a few minutes reacquainting myself with the Postgres command line client reminds me of what I was missing.

Are you hearing me Oracle? You command line client is awful. It sucks very, very hard. Yes, you have all of these neat features that are very useful, but for grunts like me, I want a tool that makes the common tasks easy. Give me autocompletion. Give me a friggin' up arrow. Give me a break.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • Are you hearing me Oracle? You command line client is awful. It sucks very, very hard. Yes, you have all of these neat features that are very useful, but for grunts like me, I want a tool that makes the common tasks easy. Give me autocompletion. Give me a friggin' up arrow. Give me a break.

    I agree so hard it hurts. That's why I use TOAD [toadsoft.com].

  • I remember thinking the same thing... six years ago! You could try the same thing I tried back then, DBI::Shell [cpan.org]?
    • There are error messages (like which line of SQL had a problem) which I get with sqlplus but not through DBI. For me that is a critical feature, since I'm generally not trying to interactively understand Oracle through the command line, but rather I'm trying to debug some SQL that is misbehaving (eg a large hunk of sql refuses to compile).

      Oracle's error messages suck nearly as badly as its command line client, and I see no reason to make them suck any worse than they have to.
  • I think I remember that you use vi, but Emacs has an Oracle mode that's better than SQL Plus. If you use etags on the DDL files, you get command completion on tables and fields etc.