On 28 Oct 2009, at 5:57pm, Ted Rolle wrote: > Doesn't dynamic data typing lead to bad data? > And proliferation of home-grown editing routines?
True in an application which interacts with a user. Not true in a database backend. SQLite does not at any time interact with a user: it does not accept data, so it doesn't have to validate it. Your application is free to validate data according to whatever you feel 'valid' means. > It seems that a strict data typing at column definition time would be > MUCH better. For instance, date-editing routines... SQLite does not have a 'date' type. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
