[Building Sakai] Why use XML in database?

[Adrian Fish]

It makes development iterations shorter as it minimises the need to modify
database schemas in parallel with code changes. It's a pain,though, as you
can't query the data as easily, as you describe. Doing that kind of thing
is pretty much deprecated now, I'd say, but it takes a reasonable amount of
effort to extract out into columns, so it doesn't happen.

That's my take on it, anyway.

Cheers,
Adrian.

On 21 November 2014 at 21:21, Gregory Guthrie <guthrie at mum.edu> wrote:

> What is the reason that some entries in the database are encoded in XML,
> instead of basic fields in another table?
>
>
>
> As one example; in the ASSIGNMENT_ASSIGNMENT table, to find by dates one
> has to do an SQL lookup, and then decode into the XML entry with the date
> encoded as strings in one of the XML fields.
>
>
>
> The ASSIGNMENT_ID and CONTEXT fields are then replicated in the
> <assignment> field of the XML as values.
>
>
>
> -------------------------------------------
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20141124/2f10d060/attachment.html