CRUDdy DBIC question

Chris Jack chris_jack at
Mon Jan 23 17:41:10 GMT 2012

Bob MacCallum uncoolbob at wrote:
> Sorry about the Perl question.
> We have a database model where the master copy of the data is file based.
> Is there some DBIx::Class magic which does some kind of nested
> update_or_create_or_delete? For example, an object might initially be
> written to the db along with its three children, but then someone
> edits the file and removes one child, adds another, and edits an
> existing child.
> I've seen
> and - if we convert our files into Stag format
> temporarily, maybe this could work. Are there any other options I've
> missed?
> many thanks,
> Bob.

You could use something like DBM and there's a section in the Perl Cookbook on using tie with objects but...
I really question the desirability of doing something like this with anything that doesn't pass the ACID test. There are so many advantages to using a relational database (mySQL is free), I'm wondering why you're not going down that route.
How much data are we talking about?
Do you care about maintaining your data if your program terminates abnormally?
Do you need more than one program to access it at a time?

More information about the mailing list