> > floating point operations. If you're creating a very large database > why should > > you pay for 80 bits (an IEEE float) of storage when 8 will do just > fine? > > So don't make the field 10 bytes long, make it only 8. SQLite won't > care a bit, and will give you the value in whatever format you want.
Then it's not type agnostic any more. You now have an 8 byte numeric and a 10 byte numeric. Which is no different than integer and real.