News for hackers. Stuff that matters.
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)
Re:Why SQLite succeeded as a database (2016) by Loranubi on Wednesday February 19, 2020 @08:34PM (#22372004)
Shouldn't that be centi-cents? ^^
Re:Why SQLite succeeded as a database (2016) by inferiorhuman on Wednesday February 19, 2020 @08:44PM (#22372059)
Or in MySQL: innocents.
Re:Why SQLite succeeded as a database (2016) by Narkov on Wednesday February 19, 2020 @09:44PM (#22372282)
More likely: varchar(255)
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.