Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

Slightly OT MySQL question

by Anonymous Monk
on Feb 19, 2008 at 16:31 UTC ( #668830=perlquestion: print w/replies, xml ) Need Help??

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

This node falls below the community's threshold of quality. You may see it by logging in.

Replies are listed 'Best First'.
Re: Slightly OT MySQL question
by Fletch (Bishop) on Feb 19, 2008 at 16:58 UTC

    If you need any help (googled or otherwise) to answer that question then you're clearly not qualified for the position in question and should probably stop wasting their time and yours (and, well, ours). Not to mention you need help with your reading comprehension since "fixed width" is clearly in reference to "fixed width flat files" (not that a googled answer on that is really going to get you through the interview process either).

    (Yes, I'm being slightly cruel and curmudgeonly; it's virtual Monday. BMSMA.)

    The cake is a lie.
    The cake is a lie.
    The cake is a lie.

      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.

Re: Slightly OT MySQL question
by marto (Cardinal) on Feb 19, 2008 at 16:56 UTC
    Your post title is misleading since the question you seem to be trying to answer is asking about your experience with various brand name database products, as well as using flat file databases, such as delaminated (comma delaminated etc), or fixed width.

    See Flat File database for an explanation. Is this question from some sort of job application form?

Re: Slightly OT MySQL question
by Zen (Deacon) on Feb 19, 2008 at 18:42 UTC
    Nothing to do with perl or SOPW. Not mysqlmonks.
      Now that is a fine idea. SUN will certainly like it and may throw money at it too.

      And we're not MonitorMonks either... yet you had no trouble with that here. Am I missing something?


        Yes. I consider monitors to be part of the dev environment.
        My gripe is that editors more and more are not moving things to the appropriate forum (and approving non perly things). It's raising the signal to noise ratio..which is fine, if we all want to move towards general IT consulting.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (4)
As of 2022-12-07 22:37 GMT
Find Nodes?
    Voting Booth?

    No recent polls found