My recent study of Damian Conway's "Object Oriented Perl" has proven useful for a current project I am working on. I am dealing with a database of just over 300k records (account information for a high volume site) which I have to constantly query with select statements looking for repeats on account creation etc. It would appear from my novice experience that a better way to structure the data is in an object manner and maintain persistent objects for the current information. All documentation I have read recommend using the Data::Dumper and pushing the data to a Db using the Persistence::Object::Postgres module. I would like to keep the current DB structure and not serialize the data as other non-perl applications will read from this. Is it possible to push the oid to the DB and somehow parse the varables to insert them into seperate colums? Anyone have any recommendation on sources of information for this? Any help would be greatly appreciated. Thanks.

In reply to Object Persistence to PostGRESQL by rgatliff

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!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • 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, details, 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, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            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.