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
[SOLVED] Database backend
[SOLVED] Database backend
Last edited by rshepard on Mon Sep 27, 2010 8:54 pm, edited 1 time in total.
-
- Support Guru
- Posts: 8169
- Joined: Tue Oct 19, 2004 6:44 pm
Re: Database backend
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.
I personally recommend MySQL because many of the independently contributed modules (including ALL of mine) do not support Postgres.
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Re: Database backend
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

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
Hello Rich,
Morever, considering that several add-on modules are also not supported, I'd say that using MySQL is the only safe bet.
Although CMS Made Simple uses Adodb database abstraction, according to this list, it looks as SQLite is not supported.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.
Morever, considering that several add-on modules are also not supported, I'd say that using MySQL is the only safe bet.
