This has been discussed in a few circles, but this seems the optimal place for it. I propose that for Drupal 7 we make MySQL 5.0 our minimum MySQL version. Justification: Active support for MySQL 4.1 has long-since ended[1]. It is in legacy/extended support status now only. The same is true of MySQL 4.0, which we've already left behind (fortunately). Now, let's be realistic. Drupal 7 is most likely a year away from release, give or take a month. Like previous versions, it will likely be the premiere release for a year or so. In that year, MySQL 4.1 will cease even extended support, at the end of 2009, just as MySQL 4.1 legacy support ends at the end of this year. That means by the time Drupal 7 ships, with PHP 5.2 as a minimum requirement, MySQL 4.1 will be about as modern as PHP 4.2. :-) What does MySQL 5 offer us? 1) SQL Views 2) Stored procedures 3) Perhaps most importantly, many many fewer minor versions each with their own bugs for us to have to work around. 4) The full changelog[2] I am flexible on which minor version of MySQL 5.0 to target, but a year from now there will be no point to keeping MySQL 4.1 around anymore. Let's plan ahead to make Drupal 7 the "all 5s" release. :-) [1] http://www.mysql.com/company/legal/lifecycle/#calendar [2] http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html -- Larry Garfield AIM: LOLG42 larry@garfieldtech.com ICQ: 6817012 "If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an idea, which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of every one, and the receiver cannot dispossess himself of it." -- Thomas Jefferson
On Sun, 10 Feb 2008 01:12:21 -0600 Larry Garfield <larry@garfieldtech.com> wrote:
This has been discussed in a few circles, but this seems the optimal place for it. I propose that for Drupal 7 we make MySQL 5.0 our minimum MySQL version.
Justification:
... and it should be easier to support other DB (MS SQL, Oracle, pgsql...) that have had some of those features from years. You're going to incur in less penalty cos you're forced to follow the mysql way and things could be written more uniformly. -- Ivan Sergio Borgonovo http://www.webthatworks.it
+1 for dropping MySQL 4.x On Feb 10, 2008 10:54 AM, Ivan Sergio Borgonovo <mail@webthatworks.it> wrote:
On Sun, 10 Feb 2008 01:12:21 -0600 Larry Garfield <larry@garfieldtech.com> wrote:
This has been discussed in a few circles, but this seems the optimal place for it. I propose that for Drupal 7 we make MySQL 5.0 our minimum MySQL version.
Justification:
... and it should be easier to support other DB (MS SQL, Oracle, pgsql...) that have had some of those features from years. You're going to incur in less penalty cos you're forced to follow the mysql way and things could be written more uniformly.
-- Ivan Sergio Borgonovo http://www.webthatworks.it
-- Please don't send me Word or any other Microsoft formatted attachments. I can't read and won't bother reading these proprietary formats so please send me any files in PDF,HTML,ODF, or TXT formats.
Indeed, MySql 6 is actually available to some. I have already encountered things that don't work as well in 4 as they do in 5. ++1 for me. Nancy E. Wichmann, PMP -----Original Message----- From: development-bounces@drupal.org [mailto:development-bounces@drupal.org]On Behalf Of Larry Garfield Sent: Sunday, February 10, 2008 2:12 AM To: development@drupal.org Subject: [development] Minimum MySQL version This has been discussed in a few circles, but this seems the optimal place for it. I propose that for Drupal 7 we make MySQL 5.0 our minimum MySQL version. Justification: Active support for MySQL 4.1 has long-since ended[1]. It is in legacy/extended support status now only. The same is true of MySQL 4.0, which we've already left behind (fortunately). Now, let's be realistic. Drupal 7 is most likely a year away from release, give or take a month. Like previous versions, it will likely be the premiere release for a year or so. In that year, MySQL 4.1 will cease even extended support, at the end of 2009, just as MySQL 4.1 legacy support ends at the end of this year. That means by the time Drupal 7 ships, with PHP 5.2 as a minimum requirement, MySQL 4.1 will be about as modern as PHP 4.2. :-) What does MySQL 5 offer us? 1) SQL Views 2) Stored procedures 3) Perhaps most importantly, many many fewer minor versions each with their own bugs for us to have to work around. 4) The full changelog[2] I am flexible on which minor version of MySQL 5.0 to target, but a year from now there will be no point to keeping MySQL 4.1 around anymore. Let's plan ahead to make Drupal 7 the "all 5s" release. :-) [1] http://www.mysql.com/company/legal/lifecycle/#calendar [2] http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html -- Larry Garfield AIM: LOLG42 larry@garfieldtech.com ICQ: 6817012 "If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an idea, which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of every one, and the receiver cannot dispossess himself of it." -- Thomas Jefferson
On Sunday 10 February 2008 02:24:42 pm Nancy Wichmann wrote:
Indeed, MySql 6 is actually available to some. I have already encountered things that don't work as well in 4 as they do in 5.
If MySQL 6 is available then we should definitely target version 5, else we will just be carrying even more baggage around to support 6 in the future!
++1 for me.
Nancy E. Wichmann, PMP
-----Original Message----- From: development-bounces@drupal.org [mailto:development-bounces@drupal.org]On Behalf Of Larry Garfield Sent: Sunday, February 10, 2008 2:12 AM To: development@drupal.org Subject: [development] Minimum MySQL version
This has been discussed in a few circles, but this seems the optimal place for it. I propose that for Drupal 7 we make MySQL 5.0 our minimum MySQL version.
Justification:
Active support for MySQL 4.1 has long-since ended[1]. It is in legacy/extended support status now only. The same is true of MySQL 4.0, which we've already left behind (fortunately).
Now, let's be realistic. Drupal 7 is most likely a year away from release, give or take a month. Like previous versions, it will likely be the premiere release for a year or so. In that year, MySQL 4.1 will cease even extended support, at the end of 2009, just as MySQL 4.1 legacy support ends at the end of this year. That means by the time Drupal 7 ships, with PHP 5.2 as a minimum requirement, MySQL 4.1 will be about as modern as PHP 4.2. :-)
What does MySQL 5 offer us?
1) SQL Views 2) Stored procedures 3) Perhaps most importantly, many many fewer minor versions each with their own bugs for us to have to work around. 4) The full changelog[2]
I am flexible on which minor version of MySQL 5.0 to target, but a year from now there will be no point to keeping MySQL 4.1 around anymore. Let's plan ahead to make Drupal 7 the "all 5s" release. :-)
[1] http://www.mysql.com/company/legal/lifecycle/#calendar [2] http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html
-- Larry Garfield AIM: LOLG42 larry@garfieldtech.com ICQ: 6817012
"If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an idea, which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of every one, and the receiver cannot dispossess himself of it." -- Thomas Jefferson
-- Benjamin Lewis Fedora Ambassador ben.lewis@benl.co.uk ----------------------------------------------------------------------- http://benl.co.uk./ PGP Key: 0x647E480C "In cases of major discrepancy, it is always reality that got it wrong" -- RFC 1118
Indeed, MySql 6 is actually available to some. I have already encountered things that don't work as well in 4 as > they do in 5.
Though MySQL 5 normal support would be ended by the time Drupal 7 is released I would not target anything above 5.0 because 5.1 is in RC right now and 6.0 is in alpha -- too early.
Since no-one's objected, I've opened an issue here: http://drupal.org/node/220329 Also - I've seen dropping PostgreSQL 7.4 support mentioned in a couple of issues. I won't claim to know what changed between 7.4 and 8.x (nor when support is due to be dropped for 7.4 - it's still getting security releases at least), but it's been around since 2003 now...
Larry Garfield wrote:
This has been discussed in a few circles, but this seems the optimal place for it. I propose that for Drupal 7 we make MySQL 5.0 our minimum MySQL version. Agreed, +1 and all that.
Assuming this is going to happen, would a post be put up on the front page advising people of the change? Also, how do we get this ratified, has an issue been created to generate further discussion? Kind Regards, Liam McDermott.
Quoting Larry Garfield <larry@garfieldtech.com>:
This has been discussed in a few circles, but this seems the optimal place for it. I propose that for Drupal 7 we make MySQL 5.0 our minimum MySQL version.
+1 for me. It goes along with a requirement I have for new module I'm creating. Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
On Sun, 2008-02-10 at 01:12 -0600, Larry Garfield wrote:
This has been discussed in a few circles, but this seems the optimal place for it. I propose that for Drupal 7 we make MySQL 5.0 our minimum MySQL version.
I'm totally in accord for upping min mysql version to a 5.0.x. I haven't touched a 4.x server in a while myself. features aren't really my concern I just don't want to be supporting old versions or have to think about them. .darrel
On Wed, Feb 13, 2008 at 10:57 PM, Darrel O'Pry wrote:
On Sun, 2008-02-10 at 01:12 -0600, Larry Garfield wrote:
This has been discussed in a few circles, but this seems the optimal place for it. I propose that for Drupal 7 we make MySQL 5.0 our minimum MySQL version.
I'm totally in accord for upping min mysql version to a 5.0.x. I haven't touched a 4.x server in a while myself. features aren't really my concern I just don't want to be supporting old versions or have to think about them.
.darrel
participants (10)
-
Benjamin Lewis -
catch -
Darrel O'Pry -
Earnie Boyd -
Ivan Sergio Borgonovo -
Karoly Negyesi -
Larry Garfield -
Liam McDermott -
Nancy Wichmann -
Omar Abdel-Wahab