Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Simple & convenient Perl database

by Paladin (Priest)
on Sep 22, 2004 at 15:42 UTC ( #392936=note: print w/ replies, xml ) Need Help??


in reply to Simple & convenient Perl database

Checkout SQLite for which there are Perl bindings on CPAN.

Update: Even better, the entire DB engine is included in the Perl module, so you don't even need to install SQLite to use it from Perl, just DBD::SQLite and DBI.


Comment on Re: Simple & convenient Perl database
Re^2: Simple & convenient Perl database
by santander (Acolyte) on Sep 22, 2004 at 16:05 UTC
    Hi, NO, I am not a guru. I use third-party hosting. I know nothing about SQLite; DBD::SQLite; DBI. Its very abstract. What I need is freeware database PERL SCRIPT. All I need is *change path to perl* and put script on web server. No *ANY* other headache, sorry. Otherwise Perl is wrong tool.
      What I need is freeware database PERL SCRIPT. All I need is *change path to perl* and put script on web server.
      It sounds to me like you're an end user, not a Perl programmer. In that case, you're probably asking this question in the wrong place, as The monastery is about supporting Perl programmers, not Perl end-users. Perhaps you could choose to become a programmer, or perhaps you should hire a programmer or consultant to finish your task, or find some sort of end-user support community.

      -- Randal L. Schwartz, Perl hacker
      Be sure to read my standard disclaimer if this is a reply.

        "In that case, you're probably asking this question in the wrong place, as The monastery is about supporting Perl programmers, not Perl end-users." Yes, I am END USER. Yes, I am not a Perl programmer!!! Does this sounds as a crime, that I not the Perl programmer? It's really difficult to ask something programmers.. You will never got concrete advice. But you will hear set of abstract things. The programmer is not able to think as the normal man. Therefore, to ask something the programmer, it's necessary to hire the special translator on normal language. Randal L. Schwartz: JUST FOR INFO: ONLY 5 -6 PERCENT OF PROGRAMMERS(same as any peoples) ARE CAPABLE TO CREATE SOMETHING REALLY USEFUL AND CREATIVE .. If you are not capable to think creatively, then even your Cambridge or Oxford education will not help. So, no more than 5-6 percent, no more than 5-6 percent of really useful programs. Are you one of these 5 percent? The Net is overflown with garbage software programs created by rest 95 percent. --------- Now about my question: i need perl script(again), with minimal configuration from my side. I need put flat text databse on web server. Something like Webteacher's Webdata database, but much more simple and freeware
      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.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (6)
As of 2014-08-23 10:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (173 votes), past polls