Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re^2: Slightly OT MySQL question

by papidave (Monk)
on Feb 22, 2008 at 19:33 UTC ( #669637=note: print w/ replies, xml ) Need Help??


in reply to Re: Slightly OT MySQL question
in thread Slightly OT MySQL question

I was in the field for years before I realized that my system admin code (grep, awk, cut, on flat files) qualified as 'database' work. Thus, even if this isn't strictly a valid Perlish question, I don't think that the question is inherently bad.

Note: This may have something to do with the fact that half of my posts might be invalidated if we insisted that I actually provide technical insight on everything I say. :)

In any event, if you treat a flat file as a database table, each line of input becomes a database "row." In that context, you can identify "fields" in that table by their relative position in the line (fixed width), or by split /x/ on some character (delimited). If you sysread() your data, I guess you could treat it as binary. Does anyone do this any more? I don't think I've done it since I worked (in C) under VAX/VMS, and it's mostly been supplanted in the database world by BLOBs (binary large objects).

Having now said this, if you are trying to get a database job that isn't entry level, you're probably overmatched (as Fletch has stated). But that said, I never object to people wanting to grow in knowledge. If you show a willingness to make the effort to learn, it may just get you where you want to be.


Comment on Re^2: Slightly OT MySQL question
Select or Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (17)
As of 2015-07-31 20:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (282 votes), past polls