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 ( [id://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.

Replies are listed 'Best First'.
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 ;-)
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
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;

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
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?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (2)
As of 2024-06-21 17:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuli‥ 🛈The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.