[Building Sakai] MySQL or HSQLDB

[Anthony Whyte]

I also use MySQL as my development database.  Be sure to choose Innodb as your default database engine since it provides transaction support, foreign key support, row-level locking, etc.  You can specify Innodb as your default engine by creating a /etc/my.cnf file (example below):

-------------- next part --------------
A non-text attachment was scrubbed...
Name: my.cnf
Type: application/octet-stream
Size: 295 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100317/985b62b4/attachment.obj 
-------------- next part --------------


Cheers,

Anthony


On Mar 17, 2010, at 7:19 PM, Aaron Zeckoski wrote:

> HSQLDB does not support transactions or multiple connections. I always
> use mysql for development.
> -AZ
> 
> 
> On Wed, Mar 17, 2010 at 5:08 PM, Warwick Chapman
> <warwickchapman at gmail.com> wrote:
>> Hi All
>> Following on from my previous mail "Install 2.7", I see there is an option
>> to use MySQL or other DBMS instead of the default HSQLDB.
>> I come from a LAMP(ython) background and am more familiar with MySQL than I
>> am with HSQLDB.
>> Other than familiarity, ss there any reason to use MySQL instead of HSQLDB?
>> -- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
>> _______________________________________________
>> 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"
>> 
> 
> 
> 
> -- 
> Aaron Zeckoski - Software Engineer - http://tinyurl.com/azprofile
> _______________________________________________
> 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 --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2417 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100317/985b62b4/attachment.bin