Jay Pipes wrote:
Roy Lyseng wrote:
Brian Aker wrote:
Hi!
On Aug 12, 2008, at 12:28 AM, Roy Lyseng wrote:
why do you need both TIMESTAMP and DATETIME?
TEXT should be named CLOB to be aligned with SQL standard...
I am up for whatever folks want here. TEXT has always been the MySQL
type. I do not mind using the standard type name (or aliasing it).
If there is a standard, why not use it? Especially one that is so
comprehensive and consistent as the SQL standard (for most parts) :)
Consistent? Perhaps. Completely dated, vendor-centric, and geared
towards legacy environments? Absolutely.
So, when MySQL implemented subqueries, was anything but standard SQL
syntax considered? Views? Outer joins?
Sticking to the standard means very little to me, so -1 on this. If the
standard is reasonable and pertains to modern systems, sure, fine by me,
but I am not opposed to breaking standards, especially when they were
made by vendors 20 or more years ago and then bolted onto to fit needs.
Standards are good for portability, but in this day and age, one has to
wonder what, realistically, is the likelihood of writing portable
applications to run on multiple RDBMS. Standard and portable SQL is a
complete myth IMHO, and applications which try to be portable suffer
from poor performance by aiming at lowest common denominators.
Drizzle isn't really aimed at being the database for VARs or OEMs that
want a standards-compliant RDBMS on which to write some enterprise
application. Instead, it aims to tackle the specific problems of the
web and cloud environments.
Standards are not only good for portability. They also mean that a
developer can move from one database to another without having to learn
a completely new semantics. Of course that does not happen in the real
world, but that is because of the vendors, not the standard.
I do not mind extensions to the SQL standard, but incompatibilities
should generally be avoided. Most incompatibilities are also confusing
and illogical, IMHO.
Roy
My 2 cents,
Jay
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
