News for hackers. Stuff that matters.

A comment on SQLite Release 3.37.0. Parent comment

Re:SQLite Release 3.37.0 by littlecranky67 on Sunday November 28, 2021 @05:15AM (#29367731)
SQLite is not postgres. Often sqlite dbs span only a couple of MB, ie when used in an App, and performance might not be as important as readability during debugging/development.
[ Parent | on HN ]
Re:SQLite Release 3.37.0 by hnarn on Sunday November 28, 2021 @06:07AM (#29367971)
The argument "this doesn't matter because all SQLite databases are small anyway" does not hold water. There are many large SQLite databases out there. And even if there wasn't, storing timestamps as text is simply and fundamentally A Bad Idea(tm).
[ Parent | on HN ]
Re:SQLite Release 3.37.0 by littlecranky67 on Tuesday November 30, 2021 @04:10AM (#29390327)
True, but I think SQLite has a design goal of being an embedded DB.

As for your argument to store timestamps as text, look at DynamoDB who only allows storing dates as text, and it is designed to handle petabytes of data.

[ Parent | on HN ]