[Chandler-dev] Sharing API type system meeting

[Phillip J. Eby]

At 04:02 PM 9/12/2006 -0700, Morgen Sagen wrote:
>I'm no expert in SQL data types, but does a table like this help the
>discussion along?
>
>http://wiki.osafoundation.org/bin/view/Projects/ 
>ExternalInformationModelDataTypes
>
>The leftmost column contains the types supported by application/ 
>schema.py.  The middle column could get filled in with whatever types
>Cosmo supports.  The rightmost column are guesses at some SQL types
>based on the MySQL documentation.

Interesting.  MySQL may be a bit unusual with respect to its data types, in 
that most DB's include length information in their types, distinguishing 
between say VARCHAR(4) and VARCHAR(255), or between a NUMERIC(9) and a 
NUMERIC(10,2).  Although it does seem that more recent databases have had 
more inclination to offer some binary types like "int" and "bigint".

Is the Cosmo backend going to be MySQL?