The original question was that I was curious about the history. Noting where we are now at, I will give as examples of two real world applications:
1. 32 bit embedded sqlite. Realtime storing data from various hardware interfaces. The data includes unsigned 32 bit integers which are stored as float (don't ask me why, I guess the primary reason is the same reason that 32bit Lua uses floats as integers). There is heavy (unsigned) arithmetic computation at database read/write time. The application is stable. The maintainers/developers rue the additional code because of sqlite and no native unsigned type. They have a historic codebase for 3 other database systems which they have previously used. 2. Mixed 64/32 bit system that has integers that use the full 64 bits. Numbers are sourced by realtime hardware. Absence of 64 bit unsigned means addition of few functions to handle inserts and display representation(s), numbers stored as text/blobs. Again this all works, just extra code and indexes are less than optimum (compared to previous used mysql). _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
