On 10/10/2011 10:14 AM, ray wrote: > Thank you. That was very informative. I am still not sure as to what > the drivers are for choosing what DB to use for Trac. What are the > trade-offs between SQLlight and the others?
SQLite is a very lightweight single-process, single-file database. The trade off is it does not scale well to many users & large database. Postgresql is pretty good at handling concurrent users and large amounts of data. It's also an overkill for a one user, one little trac sort of setup. Mysql has some (as in "nowhere near all") of the posgresql's features without any of sqlite's simplicity. Not sure why anyone would use it. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
signature.asc
Description: OpenPGP digital signature
