Re: Did Joe Celko say this ? "Worse than MySQL: Just Ms Access"
Date: 12 Feb 2007 06:18:37 -0800
Message-ID: <1171289917.061936.28140_at_j27g2000cwj.googlegroups.com>
If I did not say that in a sngle quote, then maybe I should have :)
Like the story about Samuel Johnson and Boswell; Dr. Johnson hears a great quote and says to Boswell, "I wish I had said that!", to whch Bosell replies "Oh you will, sir!"
I like MySQL much better these says since Peter Gulutzan started bring it up to Stamdard SQL. I am also teaching database design courses on on-line for them.
I consider ACCESS to be a bad product on many levels. I was at the COMDEX as trade press when MS presented it and the next FoxPro to the world. ACCESS sorted dates alphabetically, crashed when Gates did the Demo on stage and hsd no UNION (I later foundout that the engine coudl do UNIONs, but they crippled it because nobody had a cool UI).
It is a file system trying to look like SQL, but with ugly parts like DISTINCTROW sticking out it. It is still using left to right ordering as a processing model.
People that use ACCESS build simple, but often useful, projects with it. But their work does not port or scale when that project has to move to the enterprise level. The result is really awful code with poor performance as they try to make it do jobs for which it was not meant. Received on Mon Feb 12 2007 - 15:18:37 CET