SQLite
Permalink 1 user found helpful
Hello All,
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.
Any thoughts?
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.
Any thoughts?
Thank you, Frank. I am going to give this a go - with some luck I can spend a few days on it and get paid doing it by my current client :-).
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.
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.
Here's some info that will help you out:
concrete5 users the ADODB database abstraction layer:
http://www.concrete5.org/documentation/developers/system/database-c...
Here's the docs for the adodb library itself:
http://phplens.com/lens/adodb/docs-adodb.htm#drivers...
Also in concrete/config/base.php around line 450 you'll see:
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.
concrete5 users the ADODB database abstraction layer:
http://www.concrete5.org/documentation/developers/system/database-c...
Here's the docs for the adodb library itself:
http://phplens.com/lens/adodb/docs-adodb.htm#drivers...
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.
Hi, has there been any progress on this?
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...
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...
Given that the level of enthusiasm from the C5 team was not much better than luke warm - that comment re SQLite not being suitable - I decided not to waste my time on this.
Ok, thanks for the follow up. I appreciate it.
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.
best wishes
Franz Maruna
CEO - concrete5.org
http://about.me/frz