471,073 Members | 1,299 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

MySQL 4.1.x Rleease

Arc
Sorry if this has been gone over before, but I checked google groups and I
couldn't find anything.

Does anyone here have any idea when 4.1.x will be released into production
(i.e. come out of beta). It is currently impossible to find a commercial web
host who supports it because it is in beta, even though it has been out for
a long time now.

My system *requires* subqueries, and so I can't even host it until 4.1.x is
released to production.

On the other hand, anyone know of a reputable web host that provides MySQL
4.1.x as an option?

TIA,
Arc
Jul 20 '05 #1
2 1547
Arc wrote:
Sorry if this has been gone over before, but I checked google groups and I
couldn't find anything.

Does anyone here have any idea when 4.1.x will be released into production
I don't think even MySQL AB can offer a date that is carved in stone.
Think of any software company you have ever been involved with. It
would not do for any company to quote a date, until they are positive
that the product is done and ready to ship. Otherwise, they'd have to
risk either changing the date and upsetting people who were depending on
the release, or else shipping a product that wasn't ready. Not good,
either way.

I've always had the attitude, don't rely on technology that isn't
available yet.
It is currently impossible to find a commercial web
host who supports it because it is in beta, even though it has been out for
a long time now.
Keep in mind that it might take some significant amount of time before
*any* ISP upgrades their hosting support to MySQL 4.1.x. There are some
significant issues between 4.0 and 4.1 (such as the PASSWORD()
encryption function) that make the upgrade nontrivial without breaking
some existing applications.
My system *requires* subqueries, and so I can't even host it until 4.1.x is
released to production.


Many queries that use subqueries can be rewritten:

- as joins of some sort (see
http://dev.mysql.com/doc/mysql/en/Re...queries.html);

- as two separate queries: get the result of the subquery in the first,
make a string of comma-separated values out of it, and then use that in
the second query (for instance, in an IN( ) predicate);

- as an initial query, then a loop on the result set, executing the
second query for each value -- this can simulate correlated subqueries.

Of course, these are less convenient than using the subquery syntax, but
they do work in previous versions of MySQL.

Regards,
Bill K.
Jul 20 '05 #2
Arc
Thanks for the info Bill!

Regards, Arc
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Randell D. | last post: by
reply views Thread by Donald Tyler | last post: by
4 posts views Thread by mikey | last post: by
reply views Thread by Mike Chirico | last post: by
2 posts views Thread by Arc | last post: by
2 posts views Thread by trihanhcie | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.