SQLite1 user found helpful
I am a HUGE fan of Concrete and I use it on a number of websites that I manage. I came to Concrete after having had enough nightmares with Drupal 6. However, I am now working on a new project where I need multilingual capabilities (which C5 now offers) as well as the ability to use SQLite as the database (which C5 does not offer).
I have spent the day evaluating a number of alternatives in my desire to stay away from Drupal 7 (which offers both multilingual + the SQLite option). The closest I came was Xaraya but gave up at the installation + test phase.
So I am back to the option of (perish the thought) using Drupal 7. However, before I do I just want to explore the C5 + SQLite option further. If C5 uses PHP PDO to access the database it should be a relatively simple matter to recode it to use SQLite. I would be willing to undertake the task if I am going to get some help - and if the C5 team feel it is feasible.
We do use ADOdb for database abstraction, so on paper that sounds feasible.
We are trying to spend some time rewriting beefier queries for
performance with the next version of c5.
If you're going to take the time to make it work with SQLite, we will
certainly answer whatever questions we can as you go. If you're going
to lead the effort, we'll certainly post it to our roadmap page in the
blog to draft you some help.
CEO - concrete5.org
I did a quick search for ADONewConnection in my local C5 installation and came up with a number of hits all in the libarries/3rdparty folder. Can you give me a pointer to the locations C5 opens and manipulates the DB? Just the files that I need to look at will be adequate.
concrete5 users the ADODB database abstraction layer:
Here's the docs for the adodb library itself:
Also in concrete/config/base.php around line 450 you'll see:
# Variables/constants necessary for ADODB define('DB_TYPE', 'mysql');
Just a heads up converting this app won't be a simple task. Also SQLLite would be a really bad choice for a live site since the whole database is locked by each read/write action.
I'm interested in using concrete5 on a host without mysql (by choice that is, they provide mysql but I'd like to do without it, it's a bit cheaper that way).
With regard to the "don't use sqlite for live sites" thing, the makers say it should be fine up to 100k hits a day, and that the whole-database locks should normally only last a few milliseconds, both of which are well within the mean of the sites I'm thinking of:http://www.sqlite.org/whentouse.html...