It contains values for fiscal years before the year 1000 AD. Fiscal year 0900 is stored with the leading zero, so I don’t want any issues to crop-up by not including the apostrophes around the varchar value. Extra CPU is worth not having to go back and fix every query that references it as an integer when someone enters a non-integer value into a varchar field.
I just can’t seem to get 7 days straight, but I don’t know if I’m close or if I keep missing day 2. I wish I could at least see the calendar in my profile. Also, why do I care so much about this?
This reminds me of a discussion I had a long time ago about software development and a warning about adding new features. Once you add one, if you ever take it away, there will be some size of user population that is very annoyed and vocal that you took it away.
SELECT * FROM mehusers WHERE username=‘amehzinggrace’ AND opinion_matters = 1;
0 results returned
@lichme
update mehbudget
set adopted_budget = 2000000
where program_desc = ‘Online Community Engagement’
and fiscal_year = ‘2020’;
–1 row updated
@medz Why are you querying an integer as a string? You’re wasting precious CPU.
@lichme fiscal year is stored as a varchar
It contains values for fiscal years before the year 1000 AD. Fiscal year 0900 is stored with the leading zero, so I don’t want any issues to crop-up by not including the apostrophes around the varchar value. Extra CPU is worth not having to go back and fix every query that references it as an integer when someone enters a non-integer value into a varchar field.
@medz
@medz would you say this is the opposite of “forward-looking” database schema planning?
@canuk I don’t think that is something I would ever actually say.
@medz the more jargon you can fit into your sentences, the funnier life becomes.
It matters to me and Goldilocks there DAGNABBIT!!!
Yes please
/image please sir i want some more
I clicked on this topic because I thought you were summoning aspirational (or at least recreational) alcoholics.
What a letdown this turned out to be.
/giphy disappointment
@shahnm Do you want to be goated again…cause thats how you get goated again…
I just can’t seem to get 7 days straight, but I don’t know if I’m close or if I keep missing day 2. I wish I could at least see the calendar in my profile. Also, why do I care so much about this?
@canuk BECAUSE ITS REAL!
sorry for yelling…I’m beyond annoyed now
@amehzinggrace @canuk THAT’S THE SPIRIT! YOU GO GOLDILOCKS!
(╯°□°）╯︵ ┻━┻
This reminds me of a discussion I had a long time ago about software development and a warning about adding new features. Once you add one, if you ever take it away, there will be some size of user population that is very annoyed and vocal that you took it away.
@canuk same if you add a new one.
/Me looks at the Add Topic button
I was so excited… only two more days until “Calendar Time” … and then I realized today is Thursday and I once again maxed out at my 4-day streak