• twitter image
  • facebook image
  • youtube image
  • linkedin image
Language: CMS Made Simple Czech CMS Made Simple France CMS Made Simple Spain CMS Made Simple Hungary CMS Made Simple Russia CMS Made Simple Netherlands

All times are UTC




Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 13 posts ] 

Do you use CMSMS With Postgres
Poll ended at Sun Dec 04, 2011 2:17 pm
Yes, I use it with CMSMS all of the time 6%  6%  [ 4 ]
No, because my hosts don't provide Postgres support. 14%  14%  [ 10 ]
No, I don't because support for modules is bad. 0%  0%  [ 0 ]
No, I never have, and have no desire to. 63%  63%  [ 45 ]
What's Postgres? 18%  18%  [ 13 ]
Total votes : 72
Author Message
 Post subject: CMSMS Database Support Poll
PostPosted: Fri Nov 04, 2011 2:17 pm 
Offline
Dev Team Member
Dev Team Member
User avatar

Joined: Tue Oct 19, 2004 6:44 pm
Posts: 7109
Location: Fernie British Columbia, Canada
In our discussion about what would be included in CMSMS 1.11 the topic of database support has come up.

Officially, the CMSMS core always has, and still supports Postgres (at least postgres 8 ). We rarely see any complaints from people that use CMSMS with postgres, however those few that do complain tend to be loud and vocal :)

The dev team tests and fixes bugs wrt postgres as an afterthought (simply because none of the dev team use it on a daily basis). We also know that many modules will not work 'out of the box' with Postgres. largely for the same reason, the developers don't use it.

But since we're in this decision making process, and we had no real (scientific or otherwise) statistic to tell us exactly what portion of our user community uses CMSMS with Postgres, we thought we'd put it out to the community to give us some feedback.

This poll will run for about 30 days, and I hope that we get enough information that we can make an informed decision about postgres, rather than a decision based on our casual observance. So please respond.

Thanks

The Dev Team.

_________________
Follow me on twitter
--
if you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
----------------
Don't make me angry..... you won't like me when I'm angry....


Top
 Profile  
 
 Post subject: Re: CMSMS Database Support Poll
PostPosted: Sat Nov 05, 2011 3:44 am 
Offline
Forum Members
Forum Members

Joined: Thu Dec 16, 2010 9:48 pm
Posts: 11
Does it mean next CMSMS version will not use adodb lite?


Top
 Profile  
 
 Post subject: Re: CMSMS Database Support Poll
PostPosted: Sat Nov 05, 2011 4:05 am 
Offline
Dev Team Member
Dev Team Member
User avatar

Joined: Tue Oct 19, 2004 6:44 pm
Posts: 7109
Location: Fernie British Columbia, Canada
Assange wrote:
Does it mean next CMSMS version will not use adodb lite?


No, it does not. Even if we were to decide to drop support for postgres, if we dropped adodb_lite and went with some other abstraction library we would instantaneously break each and every module that is stored in the forge, along with alot of the UDT's. and many plugins. That's just not feasible.

What it would mean, if we decided to drop postgres support; would be that we could then delete one file from the distribution (the adodb_lite postgres driver). And then not worry about finding somebody to test CMSMS with postgres, or setting up another database, and a duplicate environment of CMSMS just for testing postgres. We could also ignore any bug reports that happen to come into the forge or forum related to postgres.

On a related subject: Without getting into the religious debate about performance and whether 0.01% of a performance gain, or 1000 bytes is important enough to consider rewriting thousands of lines of code. I have looked through the adodb_lite code, and done some hours researching the issue... and relatively speaking, with the exception of one thing the adodb_lite library is fairly light weight, and efficient. Also, we've already tweaked it and trimmed it down a fair bit. That 'one thing' is that it uses some trickery for multiple inheritance because of the PHP4 era that it was written in.

To answer the next question: Yes, it is possible to morph adodb_lite into something that uses PHP5's OOP capabilities so as to not break all of CMSMS code... but would it really gain us that much performance? would it be worth the effort? I don't know. There are bigger performance fish to fry before we go down that road.

_________________
Follow me on twitter
--
if you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
----------------
Don't make me angry..... you won't like me when I'm angry....


Top
 Profile  
 
 Post subject: Re: CMSMS Database Support Poll
PostPosted: Sat Nov 05, 2011 4:25 am 
Offline
Dev Team Member
Dev Team Member
User avatar

Joined: Tue Oct 19, 2004 6:44 pm
Posts: 7109
Location: Fernie British Columbia, Canada
Daniel15 wrote:
Is there any advantage of ADOdb any more, now that PDO is built-in to PHP? I haven't used it for a while so don't know if it's changed much in the past few years.


In a word, the answer is 'no'... but in many ways we're stuck with the adodb interface. Unless of course we want to break everything, and re-do it.

Though I do kinda like the adodb datadictionary stuff... and at one time I was looking at finding/implementing an adodb library for sqlite3... but sqlite3 has a few missing key features that shot that idea down for me. Again, though I could've worked around those issues it made it 'not worth the effort'.

_________________
Follow me on twitter
--
if you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
----------------
Don't make me angry..... you won't like me when I'm angry....


Top
 Profile  
 
 Post subject: Re: CMSMS Database Support Poll
PostPosted: Sat Nov 05, 2011 7:59 am 
Offline
Forum Members
Forum Members
User avatar

Joined: Sun Jul 10, 2011 7:11 am
Posts: 35
Location: Haarlem, the Netherlands
Don't waste time on Postgres db. Only really geeks are still using it. No offence.

Since dev time is limited, focus on one thing only.


Top
 Profile  
 
 Post subject: Re: CMSMS Database Support Poll
PostPosted: Sun Nov 06, 2011 6:07 am 
Offline
Forum Members
Forum Members

Joined: Thu Dec 16, 2010 9:48 pm
Posts: 11
Thx for the clear answer ...


Top
 Profile  
 
 Post subject: Re: CMSMS Database Support Poll
PostPosted: Thu Nov 17, 2011 8:59 am 
Offline
New Member

Joined: Thu Nov 17, 2011 7:47 am
Posts: 1
Hello,

We use CMSMS with Postgres for two years. We use Postgres to manage a big weather database, so it's easy for us to maintain only one database system. I hope you'll still support Postgres in the future... ;)

Pam.


Top
 Profile  
 
 Post subject: Re: CMSMS Database Support Poll
PostPosted: Thu Nov 24, 2011 4:56 pm 
Offline
Dev Team Member
Dev Team Member
User avatar

Joined: Tue Oct 19, 2004 6:44 pm
Posts: 7109
Location: Fernie British Columbia, Canada
Just bumping this so that people read it and vote.

_________________
Follow me on twitter
--
if you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
----------------
Don't make me angry..... you won't like me when I'm angry....


Top
 Profile  
 
 Post subject: Re: CMSMS Database Support Poll
PostPosted: Mon Nov 28, 2011 7:19 am 
Offline
Power Poster
Power Poster

Joined: Wed Jan 25, 2006 11:53 am
Posts: 284
Location: Netherlands
If it isn't that much work to keep Postgres, keep supporting it for those people who are using it. If it takes a lot of time, then drop it. As already writen in this poll, there are other issues that need more attention. I think a big issues is the fact that there is no desent wysiwyg editor default with the installation.


Top
 Profile  
 
 Post subject: Re: CMSMS Database Support Poll
PostPosted: Wed Nov 30, 2011 4:12 am 
Offline
Forum Members
Forum Members
User avatar

Joined: Wed Apr 26, 2006 9:59 am
Posts: 44
If there are no postgres professionals for development AND support inside your team support should be removed.

The current situation casts a bad light to CMSMS.


Top
 Profile  
 
 Post subject: Re: CMSMS Database Support Poll
PostPosted: Wed Dec 07, 2011 5:05 pm 
Offline
Dev Team Member
Dev Team Member
User avatar

Joined: Tue Oct 19, 2004 6:44 pm
Posts: 7109
Location: Fernie British Columbia, Canada
This topic was interesting... not only because there were a low number of votes (which to me indicates general lack of interest, or lack of understanding)... but because of the range of those votes.

Indeed more people answered the poll with 'What is postgres?' than those that indicated that they used postgres with CMSMS full time. And the vast majority voted that although they knew what postgres is, had no intention of using it with CMSMS anyways. These two poll questions made our decision simple.

The decision: The dev team decided that we will be dropping support for postgres as of CMSMS 1.11. This does not mean that we will be dropping the adodb library (there is just too much of an investment and risk to drop that library). However we'll be removing the postgres support from that library and from the installer etc.

The CMSMS Dev team, and all module developers should continue to write their code using the adodb interface (even if they only support mysql for their modules) and in a database agnostic manner, to consider the future possibility that we add support for another database scheme (like as mentioned earlier sqlite, or pdo, etc).

Thanks for your time and cooperation.

_________________
Follow me on twitter
--
if you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
----------------
Don't make me angry..... you won't like me when I'm angry....


Top
 Profile  
 
 Post subject: Re: CMSMS Database Support Poll
PostPosted: Wed Dec 07, 2011 9:05 pm 
Offline
New Member

Joined: Thu Feb 07, 2008 9:18 am
Posts: 6
I use both on different sites. mysql is surly the most common, and default database, and next to it i would see the support of sqlite3 appreciated. But please don't simply drop the support of psql. If the development was slow because of the less feedback, it's OK. I don't know the inner core of the CMS that good, but is it possible to have the choice of database left to the choice of an implementation of an abstract class?
Then there could be a Plugin-Team supporting psql or other strange alternatives. :)


Top
 Profile  
 
 Post subject: Re: CMSMS Database Support Poll
PostPosted: Wed Dec 07, 2011 10:38 pm 
Offline
Forum Members
Forum Members

Joined: Sun Dec 19, 2010 9:05 pm
Posts: 32
calguy1000 wrote:
This does not mean that we will be dropping the adodb library (there is just too much of an investment and risk to drop that library).


Will we get ADOdb lite (very old version from 2007-01-12) again or current PHP5 related ADOdb full (version from 2011-09-08)?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 13 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
A2 Hosting