| T O P I C R E V I E W |
| Davio |
Posted - 24 October 2005 : 23:23:25
MySQL 5.0 is the most ambitious release in MySQL's history. MySQL 5.0 delivers the enterprise features the community has been asking for, including Stored Procedures, Triggers, Views, Information Schema, XA Distributed Transactions, and new Storage Engines. We also added Strict SQL Mode to eliminate some of the ‘Gotchas’. Plus, MySQL 5.0 builds on our reputation for Reliability, Performance, and Ease of Use.
More information and how to use the new features found at the MySQL developers site:
http://dev.mysql.com/
Download mirrors found here: http://dev.mysql.com/downloads/mysql/5.0.html< |
| 15 L A T E S T R E P L I E S (Newest First) |
| Doug G |
Posted - 26 October 2005 : 19:15:23
quote:
Originally posted by pweighill
quote:
Originally posted by Doug G
Who knows, maybe someday SQL Server will introduce the new LIMIT SQL attribute :)
No need to now that SQL Server 2005 has the ROW_NUMBER() function.
Thanks for the info! I guess I should check out 2005 one of these days 
< |
| pweighill |
Posted - 26 October 2005 : 15:42:00
Probably the best feature in mySQL 5.0:
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
SQL MODE settings, especially the NO_BACKSLASH_ESCAPES option .
< |
| pweighill |
Posted - 26 October 2005 : 15:33:34
quote:
Originally posted by Doug G
Who knows, maybe someday SQL Server will introduce the new LIMIT SQL attribute :)
No need to now that SQL Server 2005 has the ROW_NUMBER() function.< |
| ruirib |
Posted - 26 October 2005 : 10:35:01
New version has better and simpler support for those features.< |
| -gary |
Posted - 26 October 2005 : 10:15:47
quote:
Originally posted by ruirib
What exactly do you mean. Not that I've done it, but clustering is supported by SQL Server with the proper OS and hardware config...
Fail over clustering, but that's it. It's a stretch to call that clustering in the first place. Hot spare would be more appropriate.< |
| Doug G |
Posted - 26 October 2005 : 00:08:27
MySQL 5 has worked well in beta, I've been using it for a few months, I've ported most of my internal db applications to mysql on linux from SQL Server on W2K and I have no plans to go back to sql server. Most of the missing db features are now available. Who knows, maybe someday SQL Server will introduce the new LIMIT SQL attribute :)
< |
| ruirib |
Posted - 25 October 2005 : 22:47:40
Seems like those features are improved in SQL Server 2005. You can have a look at the SQL Server site, there is a lot of info on high availability capabilities of the new SQL Server version.< |
| ruirib |
Posted - 25 October 2005 : 22:12:47
What exactly do you mean. Not that I've done it, but clustering is supported by SQL Server with the proper OS and hardware config...< |
| -gary |
Posted - 25 October 2005 : 21:59:37
All I want is MS SQL to do a simple cluster and I'd be happy. Fault tolerance and automatic fail over are two things that MS hasn't even gotten close to yet. Not that MySQL's implemention is much better than a single point system, but at least it has some support for it.< |
| AnonJr |
Posted - 25 October 2005 : 18:28:59
quote:
Originally posted by Podge
And if you thought you needed a degree to figure out Microsoft's licencing you need a PhD to figure out Oracles - http://www.oracle.com/corporate/pricing/eplext.pdf
Must ... find ... asprin ...  < |
| ruirib |
Posted - 25 October 2005 : 17:51:09
Much harder to admin, much harder to optimize, much harder to program. Just MVHO.< |
| Podge |
Posted - 25 October 2005 : 17:47:25
Neither do I. I installed the developer edition (10g I think?) and it was a nightmare to admin. I guess thats why Oracle DBA's are paid so much.
And if you thought you needed a degree to figure out Microsoft's licencing you need a PhD to figure out Oracles - http://www.oracle.com/corporate/pricing/eplext.pdf< |
| ruirib |
Posted - 25 October 2005 : 17:27:24
Personally I don't like Oracle.< |
| laser |
Posted - 25 October 2005 : 17:24:52
If you're talking corporate, I wouldn't go past Oracle. Not really Snitz-friendly, but IMHO walks all over MS. But I'm a tad biased, I worked there for over 5yrs, but was more focussed on the multi-dimensional side rather than the relational side.< |
| ruirib |
Posted - 25 October 2005 : 11:42:41
Frankly I don't know the Express version. It has the limitations we discussed previously, but I guess it should have all the other major features. Can't be sure about it though.< |
