On Fri, 29 Jun 2018, danap wrote:
Unless your trying to create a generic user interface.
I have spent the last month trying to solve affinity with the columns.
The only way it seems to me to guarantee to solve the issue is to test
every retrieved column value and test its affinity.
Affinity is only a hint and not an assurance of anything.
I solve the problem by bloating the schema with checks like this:
foo integer default 1234
check (typeof(foo) == 'integer'),
This enforces that someone can't put "Hello world" where an integer
belongs.
Without adding all the necessary safe-guards to ensure that only valid
data goes into the database, sqlite puts the using application at risk
(security and stability) with its wishy-washy ways.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer, http://www.GraphicsMagick.org/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
