Slightly off-topic: I get so confused with age conventions. I’m self-taught and do some ad-hoc work for the organization I work for (where no one else has any interest).
To get users between 25 and 30, wouldn’t you want strictly less than 30? And greater than or equal to 25? Or for age is it inclusive?
By the by, as someone who have used both NoSQL and SQL extensively (once in the same project), the trick of NoSQL is that you shouldn’t use FNF and compute that at write time. The idea is that it’s faster to MapReduce pre calculated values since that’s the operation you want to optimize in a NoSQL world. A lot of people get that wrong and just replace MySQL with Mongo without rethinking usage and schemas.
But even in a NoSQL context I’d rather use a Postgres jsonb column over MongoDB.
I guess you could argue that people we refer to as “25 years old” are actually 25 years and some days/hours/minutes/whatever old, therefore more than 25. People referred to as 30 are, in the same vein, more than 30
Unrelated question but why can’t one have a cake and eat it? Presumably that’s why you’d own a cake in the first place. Or is world filled with people eating other people’s cakes but no owner is ever allowed to. Such a mysterious saying…
The easiest way to parse the meaning is to reverse the statement order, i.e. “Can’t eat your cake and have it too.” If you ate it, you wouldn’t have it. If you have it, you haven’t eaten it. The two states are mutually exclusive.
That phrase is about fancy cakes, like wedding cake art. You can’t keep the art and eat the cake. Like the food network cake competitions, some of those things are super creative, but you can’t have the art and eat the cake.
It’s like painting custom wrapping paper, or printing on toilet paper. If the purpose of something is to be consumed or destroyed, it can’t do that and look good at the same time. You have to choose between having pretty mocha art and drinking a mocha.
Okay, since you’re starting to throw insults via this angle, let’s try to make my case via a different route
Do you think the db is storing your age as an int or as a float? We know from the given information that it is stored as a singular number
So, I’m assuming it’s as an int, which means that until you’re 26, you’re still 25. If you’re 25 and 11 months, that’s still 25 years old, and stored as such. The strict inequality should therefore not put it in the range 25 < X < 30
Slightly off-topic: I get so confused with age conventions. I’m self-taught and do some ad-hoc work for the organization I work for (where no one else has any interest).
To get users between 25 and 30, wouldn’t you want strictly less than 30? And greater than or equal to 25? Or for age is it inclusive?
Realistically you wouldn’t store age, you’d store birthdate or possibly a datetime value, and calculate it from there
First Normal Form users unite!
By the by, as someone who have used both NoSQL and SQL extensively (once in the same project), the trick of NoSQL is that you shouldn’t use FNF and compute that at write time. The idea is that it’s faster to MapReduce pre calculated values since that’s the operation you want to optimize in a NoSQL world. A lot of people get that wrong and just replace MySQL with Mongo without rethinking usage and schemas.
But even in a NoSQL context I’d rather use a Postgres jsonb column over MongoDB.
Why strictly less than 30 and greater or equal 25? (25 ≤ X < 30)
Shouldnt it be strictly less and strictly more (25 < X < 30)?
I guess you could argue that people we refer to as “25 years old” are actually 25 years and some days/hours/minutes/whatever old, therefore more than 25. People referred to as 30 are, in the same vein, more than 30
And here comes the most annoying error, the off by one error
deleted by creator
Even if you’re 25 and 11 months, you should still be counted as 25. Same way it should be for other age based restrictions
deleted by creator
Unrelated question but why can’t one have a cake and eat it? Presumably that’s why you’d own a cake in the first place. Or is world filled with people eating other people’s cakes but no owner is ever allowed to. Such a mysterious saying…
deleted by creator
I don’t know but it doesn’t make sense. The saying, that is.
deleted by creator
The easiest way to parse the meaning is to reverse the statement order, i.e. “Can’t eat your cake and have it too.” If you ate it, you wouldn’t have it. If you have it, you haven’t eaten it. The two states are mutually exclusive.
Okay, that makes sense, just weird choice of words.
Totally agree. I’ve never been a fan of the saying and it only clicked properly for me when I heard it explained with the statement reversal.
That phrase is about fancy cakes, like wedding cake art. You can’t keep the art and eat the cake. Like the food network cake competitions, some of those things are super creative, but you can’t have the art and eat the cake.
It’s like painting custom wrapping paper, or printing on toilet paper. If the purpose of something is to be consumed or destroyed, it can’t do that and look good at the same time. You have to choose between having pretty mocha art and drinking a mocha.
I’m not contradicting anything. I think someone who’s 25 years and 11 months should not be returned from the query. Hence, the strict inequality
deleted by creator
Okay, since you’re starting to throw insults via this angle, let’s try to make my case via a different route
Do you think the db is storing your age as an int or as a float? We know from the given information that it is stored as a singular number
So, I’m assuming it’s as an int, which means that until you’re 26, you’re still 25. If you’re 25 and 11 months, that’s still 25 years old, and stored as such. The strict inequality should therefore not put it in the range 25 < X < 30
deleted by creator
deleted by creator
deleted by creator
This is a question for story refinement.
“Between 25 and 30” would tell me 25 birthday (since even at 12:00:01 you are over 25 by a second) to one second before 30th birthday.
So ages 25, 26, 27, 28, and 29.