4 ms·

That is documented as a feature. https://www.sqlite.org/different.html https://www.sqlite.org/different.html under "Manifest typing". SQLite does not use colum

That is documented as a feature. https://www.sqlite.org/different.html https://www.sqlite.org/different.html under "Manifest typing". SQLite does not use column typing except in integer primary keys.

erik_seaberg 6y ago
SQLite accepts a type constraint without enforcing it. That's a bug just like MySQL sometimes accepting a foreign key constraint without enforcing it.
- camgunz 6y ago
  It's not a type constraint. It's a hint to SQLite to try and coerce values when it can. Here's what that link parent posted says: > As far as we can tell, the SQL language specification allows the use of manifest typing. Nevertheless, most other SQL database engines are statically typed and so some people feel that the use of manifest typing is a bug in SQLite. But the authors of SQLite feel very strongly that this is a feature. The use of manifest typing in SQLite is a deliberate design decision which has proven in practice to make SQLite more reliable and easier to use, especially when used in combination with dynamically typed programming languages such as Tcl and Python. It's intended behavior that's compatible with the SQL spec.
  - OOPMan 6y ago
    That doesn't change the fact that it's not a good idea.
    - kirstenbirgit 6y ago
      Why?
dannyw 6y ago
Fair enough, but just because you call a bug a feature doesn’t mean it’s not a bug. I think most people have realised weak typing is not a good idea in programming languages. It’s especially not a good idea in databases.
- zaphar 6y ago
  Most people have not in fact realized weak typing is not a good idea. I myself vastly prefer strongly typed languages and think they are superior. However there are a huge number of people I work with and know professionally who prefer dynamically typed languages. Weak versus strong typing is a highly subjective opinion. Each one has different costs and benefits and which camp you land in depends in large part on what you value personally.
  - SSLy 6y ago
    Most "scripting" plangs are both strong and dynamic typed at the same time.

That is documented as a feature. https://www.sqlite.org/different.html https://www.sqlite.org/different.html under "Manifest typing". SQLite does not use column typing except in integer primary keys.

erik_seaberg 6y ago

SQLite accepts a type constraint without enforcing it. That's a bug just like MySQL sometimes accepting a foreign key constraint without enforcing it.

camgunz 6y ago
It's not a type constraint. It's a hint to SQLite to try and coerce values when it can. Here's what that link parent posted says: > As far as we can tell, the SQL language specification allows the use of manifest typing. Nevertheless, most other SQL database engines are statically typed and so some people feel that the use of manifest typing is a bug in SQLite. But the authors of SQLite feel very strongly that this is a feature. The use of manifest typing in SQLite is a deliberate design decision which has proven in practice to make SQLite more reliable and easier to use, especially when used in combination with dynamically typed programming languages such as Tcl and Python. It's intended behavior that's compatible with the SQL spec.
- OOPMan 6y ago
  That doesn't change the fact that it's not a good idea.
  - kirstenbirgit 6y ago
    Why?

dannyw 6y ago

Fair enough, but just because you call a bug a feature doesn’t mean it’s not a bug. I think most people have realised weak typing is not a good idea in programming languages. It’s especially not a good idea in databases.

zaphar 6y ago
Most people have not in fact realized weak typing is not a good idea. I myself vastly prefer strongly typed languages and think they are superior. However there are a huge number of people I work with and know professionally who prefer dynamically typed languages. Weak versus strong typing is a highly subjective opinion. Each one has different costs and benefits and which camp you land in depends in large part on what you value personally.
- SSLy 6y ago
  Most "scripting" plangs are both strong and dynamic typed at the same time.