Drupal 7: mySQL or SQLite

Events happening in the community are now at Drupal community events on www.drupal.org.
cbrasfield's picture
Posted by cbrasfield on March 29, 2011 at 12:58pm

Hi,

University Communications is moving toward use of Drupal, but there's just one minor set back. Currently the IT department does not enable the PDO PHP extension for mySQL (and it doesn't seem like they will, but you never know...). So, I was wondering, in what instances specific to Drupal 7 would SQLite be favored over mySQL?

The purpose of the current Drupal project is to move News sources onto a consistent platform, with the option to share as desired throughout campus. As an aside, other Colleges and Departments websites will begin to migrate to Drupal 7 soon.

Thanks for your help!
- C

Categories:

Comments

Either choice is a fine

Posted by humansky on April 1, 2011 at 2:20pm
humansky's picture

Either choice is a fine choice for a low to medium bandwidth sites, however, one caveat, it is extremely tough to convert from SQLite to MySQL. Every Perl/Python/etc script I found online didn't do the trick. Ended up having to redo the site from scratch. Also, I found this very helpful in choosing a database:

http://www.sqlite.org/whentouse.html

new project

Posted by ddorian on April 12, 2011 at 8:13pm
ddorian's picture

new project to convert from different databases: http://drupal.org/project/dbtng_migrator