Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re^2: Wisdom of data in hashes vs. SQL

by biosysadmin (Deacon)
on Jun 13, 2005 at 22:27 UTC ( #466307=note: print w/replies, xml ) Need Help??

in reply to Re: Wisdom of data in hashes vs. SQL
in thread Wisdom of data in hashes vs. SQL

Sticking information into a RDBMS is a good idea in my experience, here's some reasons:

  • It gives you a data model that's independent of your language and application, and potentially even RDBMS software. This can be very useful if you ever need to switch languages, which has been known to happen.
  • For projects that grow to be large, you can use an separate machine as your database server.
  • It's a solution that's well understood by people who develop software, which is a good thing if your code will ever be maintained and built upon by others.

On the other hand, sometimes throwing things in a full-blown RDBMS is overkill, and Perl hashes are very very fast. So, like many things it depends on your situation. I really think that knowing both ways of storing data is extremely valuable, it's part of fully grokking TIMTOWDI. :)

"There's lots of functionallity in relational databases that can be leveraged against. (Aside: any English whizzes like to correct or corroborate my use of 'leveraged' there?)"

Don't end a sentence in a preposition without mentioning to the object of the preposition! To quote Winston Churchill, "This is the kind of impertinence up with which I shall not put." :)

If I were to re-write your sentence, I would write somethng like this:

Relational databases have a lot of functionality that can be leveraged to speed up development.

Replies are listed 'Best First'.
Re^3: Wisdom of data in hashes vs. SQL
by monarch (Priest) on Jun 14, 2005 at 02:13 UTC
    I like the comment about giving you a data model independant of language and application. After all, even though, for example, I may prefer Perl over other languages, another person/department may prefer another language.

    And at the end of the day, it's the data that's most important.. so being able to share it is a big plus!

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://466307]
[choroba]: "Tatsächlich, das ist die Knochenstruktur eines Bettlers!" ??
shmem bows. Thank you
[marto]: slowclap.gif
[marto]: animated gif in question...
[1nickt]: Interesting article on the Coming Software Apocaplyse that I found while following one of eyepopslikeamosqui to's posts. Posits that no one can guarantee the quality of, or even understand, the 100 million lines of code in a mo
[holli]: you know, monk days are fun and all. but too many of them are bad for your health
[1nickt]: ...modern car. Suggests using TLA+ or other software modeling language to autogenerate code.
1nickt is not sure more and more layers separating the programmer from the program is the right way to go...
[holli]: happy one, shmem ;)
[1nickt]: I had an interview couople of weeks ago, heard from a principal engineer that a friend of his who works at The Google told him that the self-teaching software that determines the dynamic pricing for their adverts...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (10)
As of 2017-11-21 12:58 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (301 votes). Check out past polls.