Any reason not to use SQLite3?

Since Radiant is meant for more medium scale projects, is there any real
drawback to using an SQLite3 database instead of the heavier-duty MySQL?
Sort of thinking out loud here. I have my projects now managed with git,
to move the database content from my local machine to the production
I am doing a dump then import approach. Is there a better way? Perhaps
something that can be automated into a deploy.rb file?


Hi Nate,

As far as my experience goes, I can see no problem in using sqlite as
a production database. Indeed, my site is about 200 pages with average
of 4000 to 5000 pageviews per day and sqlite is handling it with no

The only case I wouldn’t recomend sqlite is if you perform a bunch of
concurent writes to the database, then sqlite is not the tool,
otherwise if it’s mainly reads sqlite will do fine.

2009/1/5 Nate T. [email protected]:

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs