why sqlite instead of MySQL?

I’m curious, is sqlite faster than MySQL?

I tried running BitNami-Redmine, which is built with MySQL, but that was very, very slow.

Trac with sqlite is blazing fast – but I’m a little worried about using a sqlite database for the long term.

Is sqlite a good alternative for a project that will likely grow quite large over the years?

Hi,

There was a velocity issue with Ruby in BitNami Redmine on Windows in previous versions. Have you tried the latest release? My understanding is that SQLite is fast for small projects but MySQL has a better performance for big databases. More info at: http://www.sqlite.org/whentouse.html

I tried the upgrade for Ruby and it didn’t work. I couldn’t get any Ruby package to work with my Redmine install – which is why I went back to Trac.

Beltran, Have you tried converting the BitNami Trac install to working with MySQL? Can you think of anything that your team set up within BitNami that would cause trouble for me if I decide to install MySQL separately and hook Trac into MySQL?

Hi,

It should work fine. We didn’t include it because it was not officially supported in the past.

BTW, you may try latest Redmine Stack, we have added some speed improvements.