Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Comment on

( #3333=superdoc: print w/ replies, xml ) Need Help??
Otherwise Perl is wrong tool

Wrong tool for what? And what would you consider as alternative tools?

Santander, you have to be more forthcoming with what you want and what you don't want. You wanted a free database, but you didn't specify that you didn't want to deal with DBI (hence, I am assuming, SQL). So, various wise monks recommended SQLite, and one even recommended DBD-CSV, but they all seem to not meet your requirements. These kinds of questions are not very helpful and waste everyone's effort.

You also say that you want a "freeware database PERL SCRIPT." What do you want... a database, or a script?

What do you exactly want to do? From your original post it seems that your text file is doing the work for you quite well, isn't it? 8847 rows, 10 columns are peanuts for a decent computer and Perl... no one will even know there is any processing going on. And since you also mentioned "Correct/update items online is not necessary" (whatever that means), a text file would be fine for you. Perl can happily munch through few tens of thousands of lines of text without any problems. If you start running into speed issues, you can think of converting to BerkeleyDB, but you haven't specified upfront if that is too "abtract" for you.

Ask mostly exactly what you want, and also check out a recent article on perl.com regarding embedded databases.

Hope all this helps.


In reply to Re^3: Simple & convenient Perl database by punkish
in thread Simple & convenient Perl database by santander

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • Outside of code tags, you may need to use entities for some characters:
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    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: (8)
    As of 2014-07-29 22:14 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      My favorite superfluous repetitious redundant duplicative phrase is:









      Results (229 votes), past polls