[Building Sakai] A Sensitive Subject

Mon Oct 15 02:59:25 PDT 2012

This statement translates to: "we don't care enough to require developers not to break Sakai production installations by introducing arbitrary and unnecessary inconsistencies".

I would hope that the project's technical leadership could set a higher bar than this.

Regards
Stephen

Stephen Marquard, Learning Technologies Co-ordinator
Centre for Educational Technology, University of Cape Town
http://www.cet.uct.ac.za
Email/IM/XMPP: stephen.marquard at uct.ac.za 
Phone: +27-21-650-5037 Cell: +27-83-500-5290 

>>> Steve Swinsburg <steve.swinsburg at gmail.com> 10/15/2012 11:25 AM >>>
That part of the db guide has been around since 2007. I don't think either case sensitivity or case insensitivity was ever discussed, but it because the defacto standard.
I'm not suggesting you need to change anything, if it works as is then that's fine, but if the recommendation is to set the db as case insensitive, then I wouldn't be surprise to see mixed case SQL.

cheers,
S

On 15/10/2012, at 7:23 PM, David Horwitz <david.horwitz at uct.ac.za> wrote:

> Steve,
> 
> By the same token abandoning case support case sensitivity has never been properly discussed or decided on by those of us who’ve been running mysql on *nix since before this was added to the setup script. Changes to production database configuration are something we are extremely loathe to do without good reason ...
> 
> D
> On 10/15/2012 10:19 AM, Steve Swinsburg wrote:
>> Nowhere is it stated that the case of SQL needs to be maintained.
>> It is true that if you are running a case sensitive database then you might have issues, which is why its recommended not to run a case sensitive database.
>> 
>> https://confluence.sakaiproject.org/display/DOC/Sakai+Admin+Guide+-+Database+Configuration+and+Tuning 
>> 
>> Also, have a look at the chat2_channel table for some mixed case mayhem.
>> 
>> cheers,
>> Steve
>> 
>> On 15/10/2012, at 6:09 PM, Stephen Marquard <stephen.marquard at uct.ac.za> wrote:
>> 
>>> I have to disagree with that ("there is no standard case enforced").
>>> Sites running databases with case-sensitive table names (as we are)
>>> would take a dim view of any changes checked in that referred to
>>> existing tables with different case, as it basically would not work.
>>> Developers are required to use the same case for table names as the
>>> table names were set up with (in the DDL SQL or hibernate config).
>>> 
>>> Cheers
>>> Stephen
>>> 
>>> Stephen Marquard, Learning Technologies Co-ordinator
>>> Centre for Educational Technology, University of Cape Town
>>> http://www.cet.uct.ac.za 
>>> Email/IM/XMPP: stephen.marquard at uct.ac.za 
>>> Phone: +27-21-650-5037 Cell: +27-83-500-5290
>>> 
>>> 
>>>>>> Steve Swinsburg <steve.swinsburg at gmail.com> 10/15/2012 1:18 AM >>>
>>> And there is no standard case enforced when referring to the same
>>> tables or
>>> columns, ie SAKAI_USER, sakai_user for example.
>>> 
>>> Bottom line, set your db up to be case insensitive.
>>> 
>>> cheers,
>>> Steve
>>> 
>>> On Mon, Oct 15, 2012 at 3:44 AM, David Horwitz
>>> <david.horwitz at uct.ac.za>wrote:
>>> 
>>>> One way of putting is:
>>>> 
>>>> "Sakai does not require case sensitive table names but all scripts
>>> and
>>>> code should assume that it may be running on a database that is case
>>>> sensitive"
>>>> 
>>>> D
>>>> 
>>>> 
>>>> 
>>>> On 10/12/2012 04:04 PM, Matthew Jones wrote:
>>>> 
>>>> If you're running Mysql on Non-OSX UNIX, then by default the table
>>> names
>>>> are case sensitive.
>>>> 
>>>> In the admin guide we recommend altering the Mysql configuration so
>>> it
>>>> isn't case sensitive which is the default value for OSX and Windows
>>> (
>>> https://confluence.sakaiproject.org/display/DOC/Sakai+Admin+Guide+-+Database+Configuration+and+Tuning)
>>>> but it should work either way. All hard coded queries, conversion
>>> scripts
>>>> as well as Mysql QA servers are set to be case sensitive
>>>> 
>>>> On Fri, Oct 12, 2012 at 9:56 AM, Mark J. Norton
>>> <markjnorton at earthlink.net 
>>>>> wrote:
>>>>> Does Sakai require database table names to be case sensitive?  I
>>> don't
>>>>> seem to recall anything about this in the database set-up of the
>>> install
>>>>> instructions.
>>>>> 
>>>>> - Mark Norton
>>>>> 
>>>>> _______________________________________________
>>>>> 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
>>> listsakai-dev at collab.sakaiproject.orghttp://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"
>>>> 
>>> 
>>> 
>>> 
>>> ###
>>> 
>>> UNIVERSITY OF CAPE TOWN
>>> 
>>> This e-mail is subject to the UCT ICT policies and e-mail disclaimer
>>> published on our website at
>>> http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from
>>> +27 21 650 9111. This e-mail is intended only for the person(s) to whom
>>> it is addressed. If the e-mail has reached you in error, please notify
>>> the author. If you are not the intended recipient of the e-mail you may
>>> not use, disclose, copy, redirect or print the content. If this e-mail
>>> is not related to the business of UCT it is sent by the sender in the
>>> sender's individual capacity.
>>> 
>>> ###
>>> 
>>> ________________________________
>>> UNIVERSITY OF CAPE TOWN
>>> 
>>> This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.
>>> 
>> 
> 
> 

###

UNIVERSITY OF CAPE TOWN 

This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.

###