On Tue, Aug 02, 2011 at 12:41:55 +0000, Black, Michael (IS) wrote:
> Since SQLite is type agnostic
Actually no, it's not. The optimizer usually does much better job if the
types are declared (I've seen many cases where it failed to use index when
some column was untyped). Plus there are unique constraints, foreign key
constraints and the very important 'integer primary key'.
> why don't you use generic field names?
You are not serious, are you? That's about the worst thing you could come up
with.
--
Jan 'Bulb' Hudec <b...@ucw.cz>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
