On Tuesday 19 May 2009 17:38:38 Rajen M. Parekh wrote:
Or you want the programmer to write zillions of lines of code to enforce foreign key constraints?
Foreign key constraints can be easily achieved with sqlite using triggers. I have personally implemented 3 desktop projects using sqlite + Qt and in all cases I have used triggers to enforce foreign key constraints. And you won't need zillions of lines of code. Only a few triggers for each constraint. And even that can be automated. In fact, there already is a web script which automatically generates triggers to implement foreign key constraints by parsing the original "CREATE TABLE" statement. Sqlite allows you to mention foreign key constraints in your "create table" statement even though it does not currently implement it.
there is one fundamental principle one follows in criticising/commenting on open source applications:
the developer gets to choose his platform and his tools. It is counter productive to give long arguments about his choice. He is not going to change especially after putting in a hell of a lot of hard work. Criticise the application - tear it to pieces, but respect his choice of the colour he uses to paint his bike shed.