sqlite or mysql for symfony2 CMF

Question

I was installing the symfony2 CMF using composer and I noticed that the default PDO handler for it is set to sqlite. I'm just curious if there's any reason behind it that related to performance or the symfony team just don't feel like using mysql for CMF.

score 5 · Accepted Answer · answered Sep 20 '13 at 07:45

the cmf sandbox is using sqlite only because this is the most simple thing to setup. for a production system with jackalope-doctrine-dbal, i would rather use mysql or postgres.

if you want optimal performance, your best option is jackalope-jackrabbit and installing the jackrabbit java server. for a production environment, you should install jackrabbit with tomcat. there is a tutorial in the jackalope wiki: https://github.com/jackalope/jackalope/wiki/Running-jackrabbit-in-tomcat-with-mysql

score 4 · Answer 2 · answered Dec 13 '13 at 13:11

4

And if you still prefer MySql, use the defaults but change database_driver: pdo_mysql database_path: null

answered Dec 13 '13 at 13:11

ajthewebdev

432
2
5
17

`database_driver: pdo_mysql` would be updated in `app/config/config.yml` and `database_path: null` would be updated in `app/config/parameters.yml`. – Sithu Nov 17 '16 at 09:10

sqlite or mysql for symfony2 CMF

2 Answers2