In one of our Sqlite applications the gratuitous type changes of Sqlite 
were incompatible and it took only a very few patches to the Sqlite 
source to disable the detection and change code.

Clay Dowling wrote:
> Simon de Hartog wrote:
> 
>>SQLite has a feature called Manifest typing. As with many features of
>>software I run, I wonder whether this feature can be disabled. I prefer
>>to use static typing in my databases to prevent stored values not being
>>what my code (C++) expects them to be. So in short: is it possible to
>>use static typing instead of manifest typing in SQLite?
> 
> If you access the database strictly through your software, this is 
> trivially easy if you are using a strongly typed language like Pascal or 
> C.  Simply force the data to be of the appropriate type in your program 
> and it will be stored as the appropriate type in your database.
> 
> If you are allowing direct access to the database via SQL, you can 
> probably assume that any user smart enough to write their own 
> insert/update queries can probably also work out the correct data 
> types.  If not, you may wish to reconsider allowing direct SQL access.
> 
> Clay
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to