On 05/11/2011 01:47 PM, Seregwethrin wrote:
I fear that I'd lose my data because of some concurrent processes to Sqlite db.
In my experience, the Sqlite libraries understand locking, but it's table-level locking. So, you don't corrupt data, you just time out when someone else is trying to do something and it's taking too long.
The documentation suggests to use Sqlite and use MySQL only as the last option, but it's for version 0.10.
You can use PostgreSQL as well. I've not had issues with it and am on 0.11.6.
I'm using Sqlite but there's also MySQL Server is available at the same host. And it's known that MySQL DBMS is very reliable.
More or less. :-) I've managed to corrupt all of them (though not with Trac).
Whould you suggest me to migrate into MySQL for Trac version 0.12/0.13?
Depends on how well-supported MySQL is in those versions. I stayed away from it in 0.11 because it was still being added.
-- Matthew Caron Build Engineer Sixnet | www.sixnet.com O +1 518 877 5173 Ext. 138 F +1 518 602 9209 [email protected] -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
