I'm tempted to use mysql version 4.1.3 for a project. However when
finished say a month from now, I'll want it to run on as many ISP's as
possible.

The app is in PHP5, which now has 2 ways of accessing a mysql database, I
kind of like the new and improved way. (Old way doesn't support place
holders and other neat object oriented techniques other languages have
had for years.)

Downside is the new and improved way requires mysql 4.1.3, which is a
beta version.

The gamble is.. will ISP's upgrade their mysql to something 4.1.3+
by then? Do you think it'll leave beta status in 4-6 weeks?

Opinions?

Jamie

--
http://www.geniegate.com Custom web programming
User Management Solutions Perl / PHP / Java / UNIX

"Average_Joe" <joe (AT) geniegate (DOT) com> wrote

Anticipate up to a year for ISPs to commit to a new version
(unless there are big security holes in the old version).

Hosting companies generally (and should) take a very conservate attitude
- they want to make sure something works and doesn't break existing
applications before deploying it. Every upgrade puts websites out
of action for a while and also risks breaking something. So if you
want the widest possible market, assume a platform at least a year
behind the leading edge.

I don't have any hard data on this - but I did lose my web site for a
day due to a problematic PHP upgrade... so as a user I don't want any more
upgrades than necessary either.

FYI, the hosting company I use ,
PowWeb http://signup.powweb.com/powweb-bin/...count_id=34523
runs PHP 4.3.8 and MySQL 4.0.15, but PHP5 is also available on a beta
basis using a .PHP5 file extension. PHP MySQL API is V3.23.58. I would
suspect they are fairly typical, if not a little more current than most.


Hope this helps,

-- Mike --

In article <%S8Nc.349$3f4.4371 (AT) newscontent-01 (DOT) sprint.ca>, Mike Bell wrote:
Thanks!

PHP5 is now out of beta, but I do see your concern, I can understand
where a lot of stuff could break.

Jamie


--
http://www.geniegate.com Custom web programming
User Management Solutions Perl / PHP / Java / UNIX

Oops! Average_Joe <joe (AT) geniegate (DOT) com> was seen spray-painting on a wall:
MySQL AB has changed their licensing arrangements between version 3
and 4, which is also likely to be significant to ISPs. In many cases,
the new license will require paying ~$450 per host, which, for an ISP
with a lot of hosts, may represent a prohibitively expensive
"upgrade."
--
let name="cbbrowne" and tld="ntlug.org" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/advocacy.html
Hard work pays off in the long run. Laziness pays off now.