Page 1 of 1

[SOLVED] Database backend

Posted: Sat Sep 25, 2010 6:54 pm
by rshepard
I'm looking for a simple CMS for our consulting company's Web site and cms made simple looks good to me. Can I use SQLite on the back end instead of postgres? I've used both for a dozen or so years, and for the small site we have I think SQLite would be simpler and easier to maintain.

TIA,

Rich

Re: Database backend

Posted: Sat Sep 25, 2010 8:24 pm
by calguy1000
CMSMS doesn't support sqlite at the moment.  Just MySQL and Postgres.
I personally recommend MySQL because many of the independently contributed modules (including ALL of mine) do not support Postgres.

Re: Database backend

Posted: Sat Sep 25, 2010 10:16 pm
by rshepard
I suspected as much. :-)

I've been using postgres a long time so I'll use that with cmsms. I don't need to install, learn, and maintain a third rdbms.

Quick question: where do I install the pgsql-php driver?

Thanks,

Rich

Re: Database backend

Posted: Sun Sep 26, 2010 5:39 am
by gour
Hello Rich,
rshepard wrote:Can I use SQLite on the back end instead of postgres? I've used both for a dozen or so years, and for the small site we have I think SQLite would be simpler and easier to maintain.
Although CMS Made Simple uses Adodb database abstraction, according to this list, it looks as SQLite is not supported.

Morever, considering that several add-on modules are also not supported, I'd say that using MySQL is the only safe bet.  ;)