this post was submitted on 24 Dec 2023
97 points (96.2% liked)

Today I learned

7870 readers
1 users here now

founded 4 years ago
MODERATORS
 

Learned this from a friend. The types are null, integer, real, text, and blob. My friend describes them thusly:

  • Null stores nothing, but like, actively nothing, as opposed to the absence of a thing.
  • Integer is a signed integer, up to 8 bytes.
  • Real is always an 8-byte float.
  • Text is an arbitrary-length UTF-8 or UTF-16.
  • Blob is an arbitrary-length anything-else. But I hope you remembered what you put there. Because it sure isn't gonna tell you. Oh, and it doesn't have strong typing, so if you ask for it back as an integer, it'll quite happily give you it back as an integer, especially if that doesn't make sense!
you are viewing a single comment's thread
view the rest of the comments
[–] incogtino@lemmy.zip 18 points 10 months ago (1 children)

Lol I just make sure they're formatted as ISO dates or timestamps and store them as text, you can do good enough date operations on them

[–] hangukdise@lemmy.ml 7 points 10 months ago* (last edited 10 months ago) (1 children)

This. Lexical sort works on dates stored as text in ISO format. For times, better standardize in storing in UTC and converting to and from local time. Although storage will suffer as this consumes way more data than storing as number.