Today I learned

7844 readers

1 users here now

founded 4 years ago

MODERATORS

sonder@lemmy.ml

TIL that SQLite has only five data types (lemmy.dbzer0.com)

submitted 10 months ago by baitsmithy@lemmy.dbzer0.com to c/todayilearned@lemmy.ml

24 comments fedilink hide all child comments

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

[–] CosmicTurtle@lemmy.world 3 points 10 months ago (1 children)

because I'm objectively a terrible programmer.

This comment made me chuckle at 6am. I was expecting some sort of profound reason to store them at text.

I've gotten used to storing dates as numbers and then just using some sort of library to convert them back to human readable text.

Dates are much easier to work with when they are numbers.

[–] baitsmithy@lemmy.dbzer0.com 3 points 10 months ago

Oh I'm fully aware that I'm bad at coding, but I don't do any more than simple scripting. Functional Python is the closest I get to full-on programming in earnest.