Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

comment on

( [id://3333]=superdoc: print w/replies, xml ) Need Help??

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.


In reply to Re^2: Wisdom of data in hashes vs. SQL by biosysadmin
in thread Wisdom of data in hashes vs. SQL by punkish

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



  • Are you posting in the right place? Check out Where do I post X? to know for sure.
  • Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
    <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
  • Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
  • Want more info? How to link or How to display code and escape characters are good places to start.
Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (4)
As of 2024-03-29 01:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found