5 ms·

This is not dynamic types. In a dynamic type system, runtime values have types. This is weak typing.

• anyfoo 5y ago
  But it is dynamic typing. The type in sqlite is associated with the value. For example you can have a number column, but actually store a string in it. Proper shocked now?
  • deleted 5y ago
    [deleted]
  • neolog 5y ago
    I guess it depends if you consider columns values or expressions. A dynamically typed number column would not accept non-number values.
    • anyfoo 5y ago
      sqlite does accept non-number values in a number column, and gives them back in those non-number types.
    • jayd16 5y ago
      The breakdown is it appears SQLite columns are not actually typed. Its just a hint. Only the values are typed.
  • vbezhenar 5y ago
    How do you store "001" string in a number column?
• goto11 5y ago
  Columns are like lists in Python - they can contain values of any type. The type is associated with the individual value.