Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

comment on

( [id://3333]=superdoc: print w/replies, xml ) Need Help??
Okay, I need some ideas...

I'm trying to come up with creative ways in which to use Perl (or Python) to make my life at work easier. It seems like there must be a way that I can automate some piece(s) of the process and in doing so, perhaps accidentally come off being more productive than I really am (which isn't that hard to do when you get the computer to do your work for you).

My daily routine involves some of the following tasks:

  • Developing large client/server database GUI programs with Powerbuilder on NT4WS
  • Writing zillions of lines of SQL (using the RapidSQL Editor) for stored procedures using a Sybase ASE database
  • Routinely having to diff our DEV and TST directories to see which procs we've made changes to on the DEV side that have to be copied to TST and then also compiled on the test database (this one, of course, screams for a program that can manage all of that)
Now, aside from the last point mentioned there, the first thing that might spring into one's mind in a situation like this is to write a <your favorite language> to <sucky language that you work with> converter to make things more fun. In this case however, I would simply get a new job before doing that. :)

Doing my "prototyping" in a language like Perl or Python isn't feasible really either because the app is huge, so the amount of code I'd have to write just to get to the point where I could start prototyping wouldn't be worth the effort.

But what about, for example, all that SQL coding? Has anyone figured out some interesting ways of reducing their workload when faced with writing lots of SQL (an Access-like drag-drop style SQL generator seems like farrrrr too much work)?

What about unit testing? Writing effective unit tests for GUIs seems impractical enough to call "impossible".

What other ways have you found to make your life easier at work? I'm far lazier than Powerbuilder allows me to be, and feel like I'm missing out on ways to do things faster.

Any ideas would be appreciated.


In reply to Using Perl with Proprietary Development Tools by mothra

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":



  • Are you posting in the right place? Check out Where do I post X? to know for sure.
  • Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
    <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
  • Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
  • Want more info? How to link or How to display code and escape characters are good places to start.
Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others wandering the Monastery: (3)
As of 2024-03-28 18:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found