[JSR_FDED]

Small nit: uuid7 is 128 bits (16 bytes) by definition. So there’s no need to convert it to binary. It already is. Unless you’re working with a stringified version of the uuid7.

[yepyoukno]

Oh yes, I meant don’t store as an ID in its string format!

[dexterdog]

It's just s dumb as storing dates as strings, but people still do it.

[littlecranky67]

But SQLite does not have a native datetime type so you have to use strings

[voakbasda]

You can use an integer

[Volundr]

How do I know the time zone of an integer? Sure there are plenty of cases where one doesn't care, but there are also many cases where the original time zone is important.

[dexterdog]

The integer is a UTC time so it can be sorted. If you need the time zone you store than in a smaller field.

[littlecranky67]

other comment said it already, timezone information is not saved. Easiest is just to use a string.

[cenamus]

But also one of the recommended ways of doing it, as it has no native Datetime type.