MySQL gets more customers, sales projected to double
Posted Nov 12, 2003 16:29 UTC (Wed)
by aa056 (guest, #16232)
[Link]
Posted Nov 12, 2003 17:13 UTC (Wed)
by ccyoung (guest, #16340)
[Link] (5 responses)
bad news: mySql uses M$ SQL "standards", a perversion (and downright ugly). We need to get users moved to PostgresQL for example. think Linux, think standards. and vice versa.
Posted Nov 12, 2003 19:14 UTC (Wed)
by FarcePest (guest, #3065)
[Link] (3 responses)
MS SQL? How do you figure that? The section of the manual What Standards Does MySQL Follow? states:
Entry-level SQL-92. ODBC levels 0-3.51.
We are aiming toward supporting the full SQL-99 standard, but without concessions to speed and quality of the code.
Now ODBC is a crappy MS API, but it is not the primary API for MySQL.
It's in there for compatibility reasons so MS SQL clients can migrate. PostgreSQL is a good free software choice too; use the one that suits your needs. It also has an ODBC driver.
Posted Nov 13, 2003 13:00 UTC (Thu)
by cbbrowne (guest, #10867)
[Link] (2 responses)
The way "autoincrement" fields work parallels those databases' approaches, as opposed to associating this functionality with the 'sequence objects' that emerged in SQL 1999 as used by DB/2, with similar notions used by Oracle and PostgreSQL. (I don't recall what Informix does, offhand.) The standard went in a different direction, but when MySQL AB implemented "their way," they were doing it the way that several popular vendors had chosen to do it, and there was no 'standard' for them to break.
In terms of looseness of data typing, the best parallel would be with MS Access, which similarly minimizes data types by coercing invalid values to "zeros," by not having a 'NULL' value, and generally with a paucity of functionality. (No stored procedures, minimal constraint controls, weak data typing, and such.)
On the other hand, perhaps the vital parallel to Microsoft would be that both companies' names start with the letter "M."
Posted Nov 13, 2003 20:43 UTC (Thu)
by Scott_Marlowe (guest, #16840)
[Link] (1 responses)
If there was a flavor of MySQL that: enforced type constraints I'd use it for lots more stuff, but those are just too ugly of a set of warts to want to deal with. I shouldn't have to remind my database to use transaction safe tables, I should have to tell it NOT to if that's what I want, i.e. create table automagically created innodb tables. But now that Postgresql 7.4 is basically due out next week, and is quite fast nowadays, I see no reason to use MySQL for anything more complex than content management.
Posted Nov 16, 2003 14:05 UTC (Sun)
by Peter (guest, #1127)
[Link]
That confirms my impression (made from afar, as a non-mysql user) of the MySQL developers. They treat these things as checkboxes to be ticked off - "yes we have transactions, yes we have subselects, etc., but we still don't see why you normally need them." It just seems they have this history of being dragged kicking and screaming into the database world where (for example) ACID is not considered a bell or whistle but a baseline feature, and through it all not really understanding why these things are a big deal. I dunno, I just can't put a lot of trust in DBMS software built by people with that mindset. Why haven't we all migrated to Postgres, Firebird and other real DBMSes yet? The world may never know.
Posted Nov 12, 2003 19:24 UTC (Wed)
by coriordan (guest, #7544)
[Link]
MySQL AB produce a copylefted Free Software database that runs on many platforms, they release their docs as Free Documentation, they donated $25k to FSF in return for voluntary GPL assistance, and they're a corporate patron of FSF (http://patron.fsf.org/2003-patrons.html). I don't know of any company that supports our community to the extent that MySQL AB do. (RedHat maybe, I've lost track of RedHats complete dealings though.) > think Linux, think standards. and vice versa If MacOS was more standards compliant than GNU/Linux, would you jump?
Posted Nov 12, 2003 19:28 UTC (Wed)
by sandy_pond (guest, #9734)
[Link] (2 responses)
Posted Nov 12, 2003 21:10 UTC (Wed)
by tomsi (subscriber, #2306)
[Link] (1 responses)
Or install Suse Linux which have MySQL 4.0. Or continue to use PostgreSQL. (I am using both) That is what I like about the Free software world. I make the decisions on how I want my system. Tom
Posted Nov 12, 2003 22:29 UTC (Wed)
by sandy_pond (guest, #9734)
[Link]
We probably wouldn't be a money maker for MySQL anyhow. So I doubt they'll miss us.
Um, it says "on track to more than double."
MySQL gets more customers, doubles sales
good news: many Linux, and taking away from M$good news - bad news
Say what?
In style, there are a couple of areas in which MySQL behaves similarly to the family of (Sybase SQL Server| Microsoft SQL Server | Microsoft Access).
Say what?
Actually, innodb tables now use an external sequence, and don't do the horrific lock table;select max(id)+1;insert row;unlock table boogie that myisam files do.Say what?
used only innodb tables, or at least by default,
spit out an error when trying to create foreign keys to non-transaction safe tables,
ran in ansi mode,
had real check type constraints,
had all the other little non-ansi buglets fixed, and
forbid allowing a parent table to be dropped out from under a child table.Say what?
I shouldn't have to remind my database to use transaction safe tables, I should have to tell it NOT to if that's what I want, i.e. create table automagically created innodb tables.
Whether your M$ SQL claim is true or not, there are other things to consider.good news - bad news
I'll stick with Free Software.
Unfortunately I've switched to PostgreSQL since Red hat only ships outdated MySQL
MySQL gets more customers, doubles sales
You can download 4.0.16 from www.mysql.com and use that.MySQL gets more customers, doubles sales
I probably should have said we, as it was the companies decision (although I did have input). But mainly for ease of staying current and who knows when license skirmish will end. However, we've found the "notify" a handy tool that's not in MySQL so I doubt we'll ever go back.
MySQL gets more customers, doubles sales