[phpGroupWare-developers] minimum version of mysql supported in trunk

[Dave Hall]

Hi all,

I have been looking at what we should be supporting in 0.9.18 when it is
released.  MySQL is by far the most popular database backend used for
phpGW.

MySQL has come a long way in the last few years.  We still support
3.23.x, which is very old.  MySQL doesn't provide binaries for 3.23,x
these days it is so old.  It is time to move on.

I think we should be requiring MySQL 4.1 or later, so we can use sub
queries and other newer features of MySQL.  We already have transaction
support for people using InnoDB on MySQL 5+.

I did some checking on distrowatch.com today to see what distros support
MySQL 4.1+, there is a list of the significant platforms.

* Debian optional in 3.1/sarge (oldstable) and v5 in current stable
* Ubuntu 5.10+
* Mandriva 2005+
* Fedora 4+
* RHEL/CentOS 4.6+
* SUSE 9.3+
* SLES 10
* Gentoo 2006.1+
* Slackware 10.2+
* FreeBSD 5.4+

All of the distros listed above support MySQL 5 these days, but many
shared hosting providers lag significantly.  I think MySQL 4.1+ is a
safe compromise for 0.9.18.

Is there any compelling reason I haven't thought of for now making this
switch? :)

Cheers

Dave
-- 
Dave Hall (aka skwashd)
API Coordinator
phpGroupWare
e address@hidden
w phpgroupware.org
j address@hidden
sip address@hidden
       _            ____                    __        __             
 _ __ | |__  _ __  / ___|_ __ ___  _   _ _ _\ \      / /_ _ _ __ ___ 
| '_ \| '_ \| '_ \| |  _| '__/ _ \| | | | '_ \ \ /\ / / _` | '__/ _ \
| |_) | | | | |_) | |_| | | | (_) | |_| | |_) \ V  V / (_| | | |  __/
| .__/|_| |_| .__/ \____|_|  \___/ \__,_| .__/ \_/\_/ \__,_|_|  \___|
|_|         |_|                         |_|Web based collaboration platform