Many small queries are efficient in SQLite

Re:Many small queries are efficient in SQLite by foepys on Tuesday February 16, 2021 @05:49AM (#26152759)

SQLite just does what JavaScript and other weakly typed languages do. The developer is responsible for what they input. If type checks are a must, SQLite is just not for you, easy as that.

[ Parent | on HN ]

Re:Many small queries are efficient in SQLite by LunaSea on Tuesday February 16, 2021 @07:33AM (#26153276)

But event JavaScript will reject data if it's considered not valid for a type.

It won't throw but it will set an "invalid" / "NaN" / etc. value.

[ Parent | on HN ]

Re:Many small queries are efficient in SQLite by foepys on Tuesday February 16, 2021 @08:04AM (#26153457)

I don't see how having "NaN" or "undefined" in a number field makes any difference to just putting the value there. If you are using a strongly typed language, this will not be a problem.

SQLite made a design choice in favor of simplicity. It's also missing basic date functions all together. The only way to compare dates is by using Unix Epoch.

[ Parent | on HN ]

Re:Many small queries are efficient in SQLite by samatman on Tuesday February 16, 2021 @05:19PM (#26159473)

I use ISO 8601 full timestamps in UTC.

They were carefully designed so that collation order is identical to temporal order. Which is convenient!

If you need interval logic, though, SQLite won't help you, and epoch is the better choice. It's possible to solve some queries with a regex, but you won't love it.

[ Parent | on HN ]