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. 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. 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
