News for hackers. Stuff that matters.

A comment on Why SQLite succeeded as a database (2016). Parent comment

Re:Why SQLite succeeded as a database (2016) by marton78 on Wednesday February 19, 2020 @05:57PM (#22371006)
I don't know how it's done in the US, but in Europe financial calculations are done with four digits after the dot.
[ Parent | on HN ]
Re:Why SQLite succeeded as a database (2016) by catmanjan on Wednesday February 19, 2020 @07:24PM (#22371645)
So store the value as milli-cents? (haha)
[ Parent | on HN ]
Re:Why SQLite succeeded as a database (2016) by Loranubi on Wednesday February 19, 2020 @08:34PM (#22372004)
Shouldn't that be centi-cents? ^^
[ Parent | on HN ]
Re:Why SQLite succeeded as a database (2016) by inferiorhuman on Wednesday February 19, 2020 @08:44PM (#22372059)
Or in MySQL: innocents.
[ Parent | on HN ]
Re:Why SQLite succeeded as a database (2016) by Narkov on Wednesday February 19, 2020 @09:44PM (#22372282)
More likely: varchar(255)
[ Parent | on HN ]
Re:Why SQLite succeeded as a database (2016) by boshomi on Thursday February 20, 2020 @01:27AM (#22373118)
varchar(255) == varchar(2000000) in SQLite

The type system in SQLite is not as strict as it is in other RDBMS.

[ Parent | on HN ]