Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: My first memorable Perl project was:

by perldigious (Priest)
on Oct 04, 2021 at 15:44 UTC ( #11137212=note: print w/replies, xml ) Need Help??

in reply to My first memorable Perl project was:

I reinvented the wheel of course...

Before I knew what a database was and that there was this thing called SQL I had the problem at work where I had to manually parse, filter, and cross reference very large data sets every week that were presented to me as massive very slow to load spreadsheets. Having some very old and dusty coding ability I hadn't used since college (I became an electronics hardware engineer) and annoyed by the time consuming manual process of going through the spreadsheets, I decided to try to automate it.

A colleague who had previously worked for IBM long ago suggested I learn Perl to try to do it (he said a lot of his coworkers at IBM used Perl). I bought a copy of Learning Perl, spent my free time at work going through it, and once finished basically wrote a rudimentary database tool (I just didn't know it at the time) that extracted all/only the relevant columns from each data set, used hashes to give each row of each dataset a "primary key" via the hash key, and more or less wrote some basic core Perl to do what I later learned SQL and an actual database could do a lot more efficiently given the size of the datasets.

I don't regret it though, it lead to me using Perl for lots, and lots, and LOTs, of other very cool things. At my peak Perl usage, I once was able to use it to extract millions of storage locations/part numbers/inventory counts from our central database, decode (they followed a complex but consistent algorithm) the locations in to exact physical coordinates and storage location dimensions within our warehouse, and modify the files (fortunately human readable) used by my company's expensive warehouse motion simulation tool to automatically draw all our pallet racking, shelving, etc. in the proper physical location, to scale, with an inventory snapshot of any given day requested for ultimate use in the active simulation tool.

As merely a "dabbler" in coding/computer science, I would have never thought I would ever be capable of something like that, but that's what Perl enabled me to do... in my own hackish, workaround way. :-)

Just another Perl hooker - My clients appreciate that I keep my code clean but my comments dirty.
  • Comment on Re: My first memorable Perl project was:

Replies are listed 'Best First'.
Re^2: My first memorable Perl project was:
by perldigious (Priest) on Oct 04, 2021 at 15:53 UTC

    P.S. I owe a lot of thanks to many of the Monks here for helping me through many of the learning hurdles I faced along the way. I have little doubt that without a helpful community like Perl Monks to use as an occasional crutch when necessary, I would have given up on probably half of the things I accomplished without ever making them work.

    Just another Perl hooker - My clients appreciate that I keep my code clean but my comments dirty.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11137212]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (4)
As of 2022-01-27 13:41 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (70 votes). Check out past polls.