4 ms·

Just to be pedantic, SQLite is not really typed. I'd call them type-hints, like in Python. Their (bad IMHO) arguments for it: https://www.sqlite.org/flextypegoo

Just to be pedantic, SQLite is not really typed. I'd call them type-hints, like in Python. Their (bad IMHO) arguments for it: https://www.sqlite.org/flextypegood.html https://www.sqlite.org/flextypegood.html

edmundsauto 1y ago
Don’t you think it’s better in this dimension than CSV though? It seems to me like it’s a strictly better improvement than the other option discussed.
newlisp 1y ago
https://www.sqlite.org/stricttables.html https://www.sqlite.org/stricttables.html
ezekiel68 1y ago
TBH this is why I've never messed with SQLite. If I want to bother with a SQL database, I at least want the benefit of the physical layer compressing data to the declared types and PostgreSQL scales down surprisingly well to lower-resource (by 2025 standards) environments.
- MobiusHorizons 1y ago
  How exactly do you anticipate using Postgres on client? Or are you ignoring the problem statement and saying it’s better to run a backend?
  - throwaway032023 1y ago
    https://pglite.dev/ https://pglite.dev/
    - felipeccastro 1y ago
      Not sure why this was downvoted, but I’d be very interested in learning how well does pglite compares to SQLite (pros and cons of each, maturity, etc)
    - MobiusHorizons 1y ago
      Interesting. TIL
dragonwriter 1y ago
A sibling comment posted a blind link whose contents address this, but (for the benefit of people who aren't likely to follow such links), recent versions of SQLite support STRICT tables which are rigidly typed, if you have a meed tor that instead of the default loose type affinity system.
fer 1y ago
> Just to be pedantic, SQLite is not really typed. I'd call them type-hints, like in Python Someone already chimed in for SQLite, so worth mentioning that Python is hard typed, just dynamic. Everyone has seen TypeError; you'll get that even without hints. It becomes particularly obvious when using Cython, the dynamic part is gone and you have to type your stuff manually. Type hints are indeed hints, but for your IDE, or mypy, or you (for clarity). It's a bit like saying C++ isn't typed because you can use "auto".

edmundsauto 1y ago

Don’t you think it’s better in this dimension than CSV though? It seems to me like it’s a strictly better improvement than the other option discussed.

newlisp 1y ago

https://www.sqlite.org/stricttables.html https://www.sqlite.org/stricttables.html

ezekiel68 1y ago

TBH this is why I've never messed with SQLite. If I want to bother with a SQL database, I at least want the benefit of the physical layer compressing data to the declared types and PostgreSQL scales down surprisingly well to lower-resource (by 2025 standards) environments.

MobiusHorizons 1y ago
How exactly do you anticipate using Postgres on client? Or are you ignoring the problem statement and saying it’s better to run a backend?
- throwaway032023 1y ago
  https://pglite.dev/ https://pglite.dev/
  - felipeccastro 1y ago
    Not sure why this was downvoted, but I’d be very interested in learning how well does pglite compares to SQLite (pros and cons of each, maturity, etc)
  - MobiusHorizons 1y ago
    Interesting. TIL

dragonwriter 1y ago

A sibling comment posted a blind link whose contents address this, but (for the benefit of people who aren't likely to follow such links), recent versions of SQLite support STRICT tables which are rigidly typed, if you have a meed tor that instead of the default loose type affinity system.

fer 1y ago

> Just to be pedantic, SQLite is not really typed. I'd call them type-hints, like in Python Someone already chimed in for SQLite, so worth mentioning that Python is hard typed, just dynamic. Everyone has seen TypeError; you'll get that even without hints. It becomes particularly obvious when using Cython, the dynamic part is gone and you have to type your stuff manually. Type hints are indeed hints, but for your IDE, or mypy, or you (for clarity). It's a bit like saying C++ isn't typed because you can use "auto".