[Building Sakai] Why use XML in database?

[Steve Swinsburg]

Yes, it's a massive pain, it's a bunch of wasted processing overhead on
every request, and if anyone is doing it in Sakai nowadays I'll have a word
with them in a dark corner at the next conference.

That said though, I have written a bunch of SQL to extract the data out and
do stuff with it so if you want some SQL or PL/SQL, let me know what you
need and the SQL you currently have.

cheers,
Steve

On Mon, Nov 24, 2014 at 8:45 PM, Adrian Fish <adrian.r.fish at gmail.com>
wrote:

> 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"
>>
>
>
> _______________________________________________
> 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/b52aa477/attachment.html