Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Re: OK, OK, I'm taking the DBI plunge. Now what?

by peppiv (Curate)
on Jan 11, 2002 at 01:06 UTC ( #137838=note: print w/ replies, xml ) Need Help??


in reply to Re: OK, OK, I'm taking the DBI plunge. Now what?
in thread OK, OK, I'm taking the DBI plunge. Now what?

Thanks gmax for the advice. I do plan on putting this into a real database sometime soon. I thought that since it already was in a text file, I'd learn to DBI query it first as the transition to converting and querying a real database might be a bit too much to handle in one fell swoop.

I know I don't always put enough info in my questions. I try to be courteous and keep it short and simple.

thanks for the replies
peppiv
if time is money....is it safe to say it's five dollars past three hundred?


Comment on Re: Re: OK, OK, I'm taking the DBI plunge. Now what?
Re: Re: Re: OK, OK, I'm taking the DBI plunge. Now what?
by thor (Priest) on Jan 11, 2002 at 10:31 UTC
    Putting this into a database should be trivial once you are ready to do so. bcp is your friend (use "|" as your field terminator and "\n" as your row terminator and you're golden)
      And pray none of your data has returns or pipes.

      That is a pretty big assumption. Big assumptions like that are what leads to fragile infrastructures. Defensive programmers try to avoid that kind of fragility if at all possible...

        Well, in this case, that he chose those for his delimiters would lead me to believe that his data is what I might call 'vanilla' (no field contains a pipe or newline). Besides which, once he puts the data in to a RDBMS, thenhe doesn't have to worry about it.

        Just out or curiosity, what do you consider good delimiters? I use '||' for field delimiters, and '@@\n" for row delimiters...

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (12)
As of 2014-12-29 14:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (188 votes), past polls