I love everything about SQLite except its lack of strictness about types; it reminds me of when Excel is trying to be helpful/"intelligent". The Numeric type le

I love everything about SQLite except its lack of strictness about types; it reminds me of when Excel is trying to be helpful/"intelligent". The Numeric type leads to three types of different behaviour for the same row of data, so any downstream processing will need to cover all these cases. [And read the rest of this thread for some examples of how people got hurt by unexpected behavior resulting from it (e.g. the case of HN user koyote who got the wrong result for "where x > 10").] Therefore, I'm firmly in the 'strict typing'/protect me from myself camp...