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

ASCII databases

by pschoonveld (Pilgrim)
on Mar 01, 2000 at 23:59 UTC ( #4636=perlquestion: print w/ replies, xml ) Need Help??
pschoonveld has asked for the wisdom of the Perl Monks concerning the following question:

Has anyone ever used any good modules for ASCII delimited databases? I have seen a couple kicking around, but it seems to me that there was a really good module for this I saw a while back. Thanks.

Comment on ASCII databases
Re: ASCII databases
by btrott (Parson) on Mar 02, 2000 at 00:49 UTC
    Check out DBD::CSV. It's a DBI database driver that lets you use comma-separated text files as if they were databases.

      Yepp, Using DBI with DBD::CSV is fine for that job (and it does allow to use other delimiters than comma, too. I prefer "|" :-), but unfortunately it still lacks of joining data from several files/tables. That means "SELECT * FROM table1,table2;" doesn't work yet. :-/

      --
      There is no place like $HOME

      Reason: (blakem) delete, duplicate of 107924

      For more information on this node visit: this

RE: ASCII databases
by Anonymous Monk on Mar 02, 2000 at 01:15 UTC
    The Perl Cookbook by O'Reilly shows two ways to do this. The module to use is: use Text::ParseWords;
Re: ASCII databases
by Anonymous Monk on Mar 02, 2000 at 01:37 UTC
    I strongly recommend Shishir Gundavaram's sprite.pm. It gets a bit clunky if you've got more than a few hundred records (as you'd expect), but since it uses SQL-like syntax it shouldn't involve too much pain to upgrade to a proper RDBMS at a later date. You can also use regular expressions as search criteria.
Re: ASCII databases
by Anonymous Monk on Mar 03, 2000 at 20:41 UTC
    i'd advise a DBI module for later migration options ;-)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://4636]
Approved by root
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: (13)
As of 2014-09-18 17:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (120 votes), past polls