Using sqlite3 with a small commercial site

Question

I am looking for recommendations for a db to use for a small commercial web store (about 10000 products, about 200 entries a day) written in RoR.

Is sqlite3 sufficient for this or should I go for MySQL? How complicated is migration between these two at a later stage if required?

Answer 1

You should take a look at the "When to use SQLite" from the SQLite's wiki for more information but here's a snippet :

Websites

SQLite usually will work great as the database engine for low to medium traffic websites (which is to say, 99.9% of all websites). The amount of web traffic that SQLite can handle depends, of course, on how heavily the website uses its database. Generally speaking, any site that gets fewer than a 100000 hits/day should work fine. The 100000 hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.