mysql 4.1.3 and ISP's.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Average_Joe - 25 Jul 2004 19:50 GMT

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

Signature

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

Reply to this Message

Mike Bell - 26 Jul 2004 15:50 GMT

> 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...

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/referer.cgi?account_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 --

Reply to this Message

Average_Joe - 26 Jul 2004 22:04 GMT

>> 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
[quoted text clipped - 25 lines]
>
> -- Mike --

Thanks!

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

Jamie

Signature

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

Reply to this Message

Christopher Browne - 28 Jul 2004 02:52 GMT

Oops! Average_Joe <joe@geniegate.com> was seen spray-painting on a wall:

> Downside is the new and improved way requires mysql 4.1.3, which is a
> beta version.
[quoted text clipped - 3 lines]
>
> Opinions?

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."

Signature

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.

Reply to this Message