Hello, These days, SQLite supports an extensive set of constraints (unique, referential, null, check, etc, etc). This is all very wonderful and allows one to fully describe its data model in term of constrains, at the database level. All good and much appreciated.
Unfortunately, there is one aspect of the SQLite implementation which spoils this idyllic situation: constraint violation and the rather laconic way SQLite reports them, namely the dreadful "constraint failed" message. Such a terse feedback mechanism renders all the great work of supporting constraints (precisely named, painstakingly crafted, thoroughly implemented) all but useless as one is left with the equivalent of customer's support favorite one-liner: "it doesn't work". Rather a let down. Would there be a way, in a future version of SQLite, to provide more informative constraint violation messages? Or is that just not feasible, implementation wise? Or? Thanks in advance. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
