Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

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
if time 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?
Replies are listed 'Best First'.
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?

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

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (6)
As of 2015-11-27 13:27 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (729 votes), past polls