Project

General

Profile

Forums » Help »

MySQL or Sqlite?

Added by fox_moxdah fox_moxdah almost 14 years ago

Does Redmine prefer any database the other (compatibility and performance wise)?

I am setting up Redmine for the first time on a local workstation.


Replies (5)

RE: MySQL or Sqlite? - Added by Felix Schäfer almost 14 years ago

SQLite is fine for development and testing (no or near to nigh concurrency), go with MySQL or PostgreSQL for production.

RE: MySQL or Sqlite? - Added by fox_moxdah fox_moxdah almost 14 years ago

I forgot to mention that for the time being there is going to be only one user. So there should not be any locking issues...I think.

Is there any data loss (or any other problem) if database is converted from SQLite to MySQL after Radmine has been in use for awhile in production (1 year+)?

I have only considered SQLite because low resources use and little administration.

RE: MySQL or Sqlite? - Added by Felix Schäfer almost 14 years ago

You won't have locking issues with SQLite, but SQLite is just not able to deal with (lots of) concurrency as well as dedicated databases.

Anyway, a migration from one database type to another is not possible because of how rails differently handles them (or let's say non-trivial), so you really should got with a full database if you plan on keeping the installation.

RE: MySQL or Sqlite? - Added by fox_moxdah fox_moxdah almost 14 years ago

MySQL it is then. SQLite looked good at first, but no migration is a deal breaker in the long run.

Thank you for taking your time to explain this issue to me.

RE: MySQL or Sqlite? - Added by Yuki Kita almost 14 years ago

It is possible to migrate the Redmine dataabse from SQLite3 to MySQL with Rails plugin(yaml_db).

See
http://www.kartar.net/category/redmine/

I had used SQLite3 for Redmine testing, and then switched to MySQL like this.

    (1-5/5)