Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

Re: Choosing a database for a new project

by fruiture (Curate)
on Oct 15, 2002 at 20:42 UTC ( #205515=note: print w/replies, xml ) Need Help??

in reply to Choosing a database for a new project

My recommendation: use a real SQL database if it's available. You'll need to write some administration scripts for easy manipulating the database, but that's not too hard (Maybe only submitting raw SQL Queries to the database).

Working with databases is extremely easy with Perl, thanks to the DBI. The DBI manpage is at least a good tutorial on the module only. I've read "Programming the Perl DBI", so I'm unable to give you other ressources, for i've never needed any apart from the book and the manpage...

Some more Pros for mySQL:

  • fast
  • extensible
  • Learning SQL is good and you're likely to need it sometime, so learn it now...
  • DBI is a powerfull tool. Learn to know it now and you'll be able to use it in future projects.
  • The time you spend now learning the stuff will be spared as soon as you need the features a flat BerkeleyDB can't give you.
  • Comment on Re: Choosing a database for a new project

Replies are listed 'Best First'.
Re: Re: Choosing a database for a new project
by signal9 (Pilgrim) on Oct 16, 2002 at 13:52 UTC

    When I was hired for my first Perl job, I only knew what SQL looked like -- not how to use it. Within a couple of days, I was up to speed enough to pull reports from Oracle, MySQL, and that other proprietary database, all using Perl's DBI. The SQL language is very straightforward, making it possible for absolute novices to get things done now and save the subtleties for later.

    Wasn't it Larry himself who said, "What you don't know won't hurt you... much?"

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://205515]
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: (2)
As of 2022-08-08 05:14 GMT
Find Nodes?
    Voting Booth?

    No recent polls found