From: nephish <nephish@...>
Date: 2006-12-04T23:25:08+09:00
Subject: MySQL and SQLite question

Lo there all.

I have been giving some thought to moving to SQLite from MySQL. We are
moving our site from php to rails for what we call "the big rewrite"
and since these changes are going on. I really like that SQLite is
stored in flat files that can easily be moved around, like from one
computer to a backup computer. I also like that it sounds like it is
faster. I know that the SQL does not support all of the same abilities
that MySQL does... but, is there much difference with regard to how it
is hanled by ActiveRecord ? I was just curious as to how they may
compare from a rails point of view, or if there are some gotchas out
there i may need to be aware of.

thanks for any tips
sk