Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Relational databases and tied hashes?
- Lee Goddard
December 15, 2004, 7:59 am
rate this thread
>If you're thinking this would take three separate SQL queries, you
Thanks, that's true, but what I'm really looking for is a way to tie
multiple, linked tables to a hash.
And at 2004-12-14 08:50:03 PST, Matija Papec (email@example.com)
>Check for Tie::DBI, it does even table updating for you
It does, but I can't find any info there on using it on tables related
by UID. I've been look at the author's Tie::RDBM too, but that rather
seems a misnoma - it doesn't seem to be so much a Relational DataBase
Manager, as a way of freezing and thawing perl data to a database.
I'm trying to use perl to dynamically create an RDB based upon an XSD
file, and then to parse SCORM Manifest XML on the fly, using the XML's
cross-referencing UIDs as related fields.
Does anyone out there have any ideas of another module that might
provide the underlying functionality? I don't much fancy writing a DB
Tie this close to the holidays with so much 'flu' around ...
Re: Relational databases and tied hashes?
firstname.lastname@example.org (Lee Goddard) wrote:
>>Check for Tie::DBI, it does even table updating for you
>It does, but I can't find any info there on using it on tables related
>by UID. I've been look at the author's Tie::RDBM too, but that rather
>seems a misnoma - it doesn't seem to be so much a Relational DataBase
>Manager, as a way of freezing and thawing perl data to a database.
Didn't try the Tie::RDBM but with first one you can tie hash with sql table
and retrieve $uid properties like,
my $name = $item;
my $price = $item;
my $image = $item;