Any reason not to use SQLite3?


#1

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,
but
to move the database content from my local machine to the production
server
I am doing a dump then import approach. Is there a better way? Perhaps
something that can be automated into a deploy.rb file?

~Nate


#2

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
problems.

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. removed_email_address@domain.invalid: