[sf-perl] Going from XML to SQL

[Chris Mungall]

On Thu, 24 Mar 2005, David Fetter wrote:

> On Thu, Mar 24, 2005 at 10:10:43AM -0800, Joseph Brenner wrote:
> >
> > Chris Mungall <cjm at fruitfly.org> wrote:
> >
> > > Joseph Brenner wrote:
> >
> > > > Before the last meeting, Rich Morin and Josh Berkus were talking
> > > > about the issues involved with translating data structures
> > > > between XML to SQL. I just came across something on CPAN that
> > > > looks relevent, DBIx::DBStag::Cookbook:
> > > >
> > > >     http://search.cpan.org/~cmungall/DBIx-DBStag-0.06/DBIx/DBStag/Cookbook.pm
> >
> > > I'm the author of this, and as it happens I'm an occasional lurker
> > > on sfpm. Glad you found the module interesting. It is being
> > > actively used in a number of bioinformatics projects at the
> > > moment.
> > >
> > > Yes, lots of people find the stag concept a bit funny, I'm
> > > emphasising that less these days, the module can be used as a
> > > general SQL<->XML mapping tools.
> >
> > What I meant was that sometimes you get the usual technical
> > religious wars going with the XML vs. lisp s-expressions.  Your
> > answer is something like "what's the difference?", that's what makes
> > it funny.
> >
> > > I haven't made it out to an sfpug event yet but I'm always happy
> > > to chat about SQLy-XMLy-perly stuff.
> >
> > Well you know, if you feel like giving a little presentation on
> > DBIx::DBStag sometime, I'd certainly be interested.
>
> <aol>Me, too!</>

OK! I'll give it some thought; this month is a bit busy, perhaps in April?

> BTW, do you have any plans to integrate this with the SQL:2003
> standard WITH RECURSIVE syntax, or is it orthogonal, or...?

No plans as yet. DBIx::DBStag doesn't really help you with recursive
queries, that's something that is best handled by the DBMS. I'd love to
see this in MySQL and PostgreSQL but I'm not sure when it'll arrive...

> Cheers,
> D
>