On 8 Sep 2010, at 10:36pm, Jay A. Kreibich wrote: > I also have to say that handling NULLs as a value-less type is a very > clean and handy model.
Today at work I had to thoroughly investigate a program I wrote long ago and look for places where NULL, undefined, -1 and 'false' might appear through unexpected situations. It was educational, not only for how JavaScript handles these values but also for how they effect downstream results. My biggest surprise is that they tend to turn into things later. For instance, if you write a NULL to a file then read it back out you may end up with the four character string 'NULL'. One thing I like about SQLite is that it's almost impossible to have problems like this with NULL since every part of SQLite understands NULL. (Just in case I get attacked for this, the program I wrote was in no way safety-critical or mission-critical, and does not generate any data which is not immediately inspected by a human who would spot missing results. The reason for the inspection is that I'm shortly going to have to write a new version which won't have those advantages.) Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
