Roy Lyseng wrote: > > > Jim Starkey wrote: >> Roy Lyseng wrote: >>> >>> >>> Jim Starkey wrote: >>> >>>> My thinking about blobs has changed. Blobs originally were an >>>> escape from fixed length SQL types. Now that I've abandoned fixed >>>> length SQL types, the utility of blob as a declared type diminishes >>>> to about nothing. Nimbus will retain clob/blob types to humor the >>>> traditional, but they will (probably) be synonyms for string and >>>> bytes, respectively. There will still be a storage type for blobs, >>>> but it will be dynamic, based on a length threshold. (Why, I can >>>> hear you asking? Simple: There is no point to slop around a >>>> high-res jpeg to update a last_reference column in the same row.) >>>> >>> I guess VARCHAR existed before BLOB/CLOB, so I am not so sure about >>> that... >> Uh, for a little historical context, try this: >> >> http://en.wikipedia.org/wiki/Binary_large_object > > Hm, when was VARCHAR first used, and when did you have the BLOB > implemented in RDB? > > As an aside, I implemented a datatype called "sequence" in the DBMS > Techra in 1984. The sequence was a sequence of any structured type, such > as points (implemented polygons), characters (implemented CLOBs) or > variable-sized strings (implemented text documents). The sequence could > be operated on as a whole or on ranges of elements - so we could e.g. > add another point to a polygon - with full transactional support.
Ha! That's nothin'! In 1952, I invented the CLARCHAR data type and implemented it using nothing but punchcards and an ironing board. ;) -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
