yes, that’s a start
- 0 Posts
- 106 Comments
But, you totally can? When you store all your dates as an ISO 8601 string (UTC, so with Z at the end), you can simply compare the strings themselves with no further complications, if the strings match, the dates match, if one string is less than the other, the date therein is before the other. Their lexical order is equal to their chronological order
I agree that it’s a massive and unnecessary overhead that you should definitely avoid if possible, but for anything where this overhead is negligible it’s a very viable and safe way of storing date and time
edit: I forgot, there’s also a format that’s output by functions like toUTCstring that’s totally different and doesn’t have any logical order, but I honestly forgot about that format because nobody in their right mind would use it
why not? assuming you’re saving them all in UTC they should be perfectly sortable and comparable (before, equal, after) as strings, even with varying amounts of precision when you compare substrings. You can’t really do math with them of course, but that’s what I meant about how DBs interpret dates and time: if you use it do to math and then you also use your application’s date library to do math, you’ll likely run into situations where the two come to different answers due to timezone settings, environments, DB drivers and the like. Of course if I could rely on the DB to do the math exactly the way I’d expect it to, then having that ability is awesome, however that requires more knowledge about databases and their environments than I currently have
Personally, I would probably just store them as text, because I’m objectively a terrible programmer.
I don’t know man, I’d far prefer storing a string and have whatever date library I’m using figure it out than have to deal with whatever the database thinks about dates and timestamps
deleted by creator
you know what will solve those problems though? blame them on someone else. “oh yeah that bug, yeah sorry the package we’re using messed it up, there’s a PR for that”
fiah@discuss.tchncs.deto Technology@beehaw.org•HP executive boasts that its controversial ink subscription model is "locking" in customers14·1 year agoyeah well HP, fuck you too
fiah@discuss.tchncs.deto Technology@lemmy.ml•Why Mozilla is betting on a decentralized social networking future6·2 years agoit’s very useful to follow subject matter experts, when you’ve identified them
boring work stuff, they entered wrong data and made a ticket to fix it several months after the fact. That data they enter is the input for a bunch of calculations, so cleaning up that mess is a lot of work and I’m the only one equipped to do it. They should be well aware of the importance of being exact with what they enter and only signing off on it when they’re 100% sure it’s correct, yet they keep messing it up. They made a stupid excuse about having to sign off on it even though they knew it wasn’t 100% done, when it’s been made perfectly clear that this is unacceptable regardless of circumstances because of legal ($$$$) ramifications
edit: I should add that those ramifications are potentially severe enough to bankrupt us. That particular administrative body does not fuck around and will tear us a new one if they smell blood
today, I used the word negligent in a work email. They done fucked up and I’m tired of their shit
fiah@discuss.tchncs.deto Linux@lemmy.ml•This week in KDE: colorblindness correction filters15·2 years agooh it would for simple graphics like graphs/charts, but it’d be worse than useless for everything else like pictures / photos / video. That’s why I mentioned Overwatch as the example, which was the most egregious offender of this. If you turned on the colorblind mode in that game back when it was first introduced, it just
chromahue shifted all colors making it look like this:how anyone with a functioning eye and brain ever thought that was the solution is beyond me
fiah@discuss.tchncs.deto Linux@lemmy.ml•This week in KDE: colorblindness correction filters9·2 years agobest they can do for those, is to offer such filters
well I’m sure some people will find it useful, but in my experience global filters make a global mess of everything without doing much of anything to alleviate the problem. Lucky for people like me, many games already have better options, and in other applications it usually isn’t much of a problem
fiah@discuss.tchncs.deto Linux@lemmy.ml•This week in KDE: colorblindness correction filters4·2 years agoyeah those ones, they completely mess up all colors and still don’t help
fiah@discuss.tchncs.deto Linux@lemmy.ml•This week in KDE: colorblindness correction filters34·2 years agoif this changes all colors with a global filter the way that some games like Overwatch (used to) do, then it’s really not going to help anyone. I’m red-green colorblind, so when something is highlighted in red it isn’t as obvious to me as it is to people with normal vision. However, the fix isn’t too globally mess with all the colors, the fix is to let me pick the highlight color so that I can choose what works best for me. Many games have figured this out long ago (thank you game devs!).
catch(error) { // todo }
fiah@discuss.tchncs.deto Gaming@beehaw.org•Weekly “What are you playing” Thread || Week of September 24th1·2 years agoI’ve been getting back into simracing again with Assetto Corsa Competizione, and I’m still deep into Baldur’s Gate 3
I’m not arguing that, it’s definitely very debatable if it’s ever going to have some practical use outside of its current speculative one. That doesn’t make it a scam tho
many are yes, but not all. Bitcoin and Ethereum (among others) are legit, and there are a few NFT projects out there that actually try to do the right thing even if they’re not worth much at all. Many other NFTs are nothing but pictures that have no meaningful value except what you assign it to, but they never pretended to be anything else so that’s still not a scam in my book
which adds latency btw, no bueno