[Columbus-pm] Fwd: MLDBM-like module

[Rob Kinyon]

Since we don't have a projector, am I giving a talk?

Rob

On Tue, Nov 17, 2009 at 09:23, Jonathan Hogue <jon at hogue.org> wrote:
> The date would be 11/19, this Thursday.
>
> The time? 6:30ish PM?
>
> what about DBIx::Tie ? You get the name recognition of DBIx and Tie.
>
> 2009/11/17 Michael Frager <mike at dialyourleads.com>:
>> Actually, I haven't decided on a name for the version I'm going to release.
>>
>> I'm considering: Tie::SQL or DBIx::Deep or something like that.
>>
>> Right now the current modules are tied into my own webapp framework and need
>> some changes to be made to work independently and thus viable for CPAN.
>>
>> However, the underlying concept is sturdy and it is something I think a lot
>> of people would benefit from, so my goal is to push toward a release within
>> a month.
>>
>> Also, though this module is the thing that other people would find useful
>> immediately. I've been working on some other things that are also very cool
>> and contain ideas that other Perl programmers might want to learn about.
>>
>> My hope is that I can show some people in Columbus.pm what I've been up to
>> (beyond the "tie" module), see if they like it, and then head toward a
>> release of the whole thing in time for YAPC 2010.
>>
>> On that note, let me put my vote in for the Winking Lizard (on Bethel). What
>> date/time would that meeting be?
>>
>> -Mike
>>
>> On Tue, Nov 17, 2009 at 1:33 AM, Reginald Tapo <reginald.tapo at gmail.com>
>> wrote:
>>>
>>> Michael,
>>>
>>> This module sounds very intresting, what will you
>>> call it Tie:: something?
>>>
>>> I'd like to see it available through PPM.
>>>
>>> ----- Original Message -----
>>> From: Michael Frager
>>> To: columbus-pm
>>> Sent: Monday, November 16, 2009 5:40 PM
>>> Subject: [Columbus-pm] Fwd: MLDBM-like module
>>> 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
>>
>>
>> --
>>
>> 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
>>
> _______________________________________________
> Columbus-pm mailing list
> http://columbus.pm.org/
> Columbus-pm at pm.org
> http://mail.pm.org/mailman/listinfo/columbus-pm
>



-- 
Thanks,
Rob Kinyon