[Columbus-pm] Fwd: MLDBM-like module

[Jonathan Hogue]

I would love to learn more! How is it different from Tie::DBI? :-)


2009/11/16 Michael Frager <mike at dialyourleads.com>:
> Hello,
>
> The big difference between my module and DBM::Deep is that my module uses a
> SQL database (like MySQL) instead of flat files. DBM::Deep has implemented
> its own locking and concurrency system that is not likely to be a robust as
> a real SQL database.
>
> Other than that the concepts are very similar. Basically, you do what you
> want to your data structures and the results are transparently and
> persistently stored for you.
>
>
> -Mike
>
>
> On Mon, Nov 16, 2009 at 5:27 PM, Rob Kinyon <rob.kinyon at gmail.com> wrote:
>>
>> I'd be very interested in seeing how this and DBM::Deep could play
>> together.
>>
>> Rob
>>
>> 2009/11/16 Michael Frager <mike at dialyourleads.com>:
>> > Hello (again) Columbus.pm,
>> >
>> > I have developed a module that is somewhat like MLDBM. In case you're
>> > not
>> > familiar with MLDBM, this module will take a hash and synchronize its
>> > contents with a DB file for persistent storage. Unlike a regular hash
>> > tied
>> > to a DB file, MLDBM will save entire data structures that are contained
>> > within the hash keys, serializing them on the fly.
>> >
>> > I've taken that concept a little bit further and developed a module that
>> > will synchronize both hashes and arrays with a SQL database. Each
>> > element of
>> > the data structure being stored can either be stored as its own row or
>> > its
>> > entire contents serialized (similar to MLDBM). The process is recursive
>> > so
>> > entire structures can be stored this way.
>> >
>> > The upshot is that you can take an entire Perl data structure, made of
>> > any
>> > combination of hashes and arrays, and just place it into a SQL database.
>> > It
>> > works no matter how deep the structure is and without the need for a
>> > custom
>> > SQL schema. Since Perl's "tie" function is use, once the structure is
>> > stored, it can be manipulated like any variable, except that changes
>> > will be
>> > transparently stored in the SQL database.
>> >
>> > I'm in the processes of preparing this module for CPAN, I was wondering
>> > if
>> > there is anyone in the Columbus.pm group who might be interested in
>> > learning
>> > about it?
>> >
>> >
>> >
>> > Thanks,
>> >
>> >
>> > Michael K Frager, Software Developer
>> >
>> > ~ Dial Your Leads ~
>> >
>> > [+] Phone:    (888) 310-4474
>> > [+] Website: https://www.dialyourleads.com/
>> >
>> >
>> > _______________________________________________
>> > Columbus-pm mailing list
>> > http://columbus.pm.org/
>> > Columbus-pm at pm.org
>> > http://mail.pm.org/mailman/listinfo/columbus-pm
>> >
>>
>>
>>
>> --
>> Thanks,
>> Rob Kinyon
>
>
>
> --
>
> Michael K Frager, Software Developer
>
> ~ Dial Your Leads ~
>
> [+] Phone:    (888) 310-4474
> [+] Website: https://www.dialyourleads.com/
>
>
> _______________________________________________
> Columbus-pm mailing list
> http://columbus.pm.org/
> Columbus-pm at pm.org
> http://mail.pm.org/mailman/listinfo/columbus-pm
>