I wish SQLite would add a bool type and proper date/time types. Is there really no plan to add them?
For bool, it could just be an alias of a numeric type.
Something equivalent to number check(col = 0 or col = 1) would be perfectly fine.
Date/time handling is pretty weak.
Having to store values as GMT text is just inconvenient.
When retrieving values in Node.js, I ended up using new Date(val), which caused the classic bug where a GMT-stored value gets interpreted in the local timezone.
The correct approach was new Date(val + ".Z"), but I really don’t want to deal with that kind of hassle anymore.
I’m not sure whether this applies globally, but in Japan, around 2015, some mobile carriers deployed a “traffic optimization” feature that would lossily compress images in transit.
On the platforms of NTT Docomo and KDDI (au), users could opt out of this behavior. However, with SoftBank, it could not be disabled, which led to controversy.
As you might expect, this caused issues—since the image data was modified, the hash values changed. As a result, some game apps detected downloaded image files as corrupted and failed to load them properly.
Needless to say, this was effectively a man-in-the-middle attack, so it did not work over HTTPS.
Within a couple of years, the feature seems to have been quietly discontinued.
There were also concerns that this might violate the secrecy of communications, but at least the government authorities responsible for telecommunications did not take any concrete action against it.
Then, out of respect for your view that children’s safety must be the absolute top priority and that false positives must never, ever be tolerated, let’s require people to personally visit Discord’s office in the United States with a government-issued ID, have it inspected, and formally swear an oath.
Of course, Discord will retain the ID and the person’s facial photograph for a semi-permanent period.
Naturally, that’s perfectly acceptable—after all, it’s for the safety of the children, right?
I just want to display the last updated time in the corner of a blog post. Overwriting local innerText with JavaScript for that is nonsense.
Displaying relative time like “1 day ago” is especially foolish. Does that mean between 0s–23:59:59? Or 24:00:00–47:59:59? Or perhaps 24:00:00–6d 23:59:59?
When you have multiple browser tabs open and switch between them, and you see “just now” — is it really just now? You last looked at that tab an hour ago. Maybe two hours? Maybe it’s been open since yesterday.
Sometimes I wonder why the Accept-Timezone header doesn’t exist in web browser requests. Using Accept-Language to switch webpage language based on the same URL is now commonplace.
There would likely be demand for a feature where the <html> contains a Unix timestamp, and the browser renders it using the client’s local time zone:
Just write it into static HTML and you’re done. No need for the server to compute relative times, and no need to rewrite it dynamically with JavaScript.
What happened to the movement to abolish daylight saving time? A few years ago, I kept hearing that the US and EU were moving toward ending it.
Yet here we are, still observing DST this year.
As is obvious in the case of a company, it is illegal to disclose a trade secret, even if it is true,
If it is judged by a court to have a positive impact on society, such as by leaking information about illegal activities, it becomes legal.
I don't think this is particularly strange in Japan, but is it different in the U.S. or the West?
However, in recent years, it has become routine in Japan to identify and punish employees who have leaked wrongdoings.
In the evening news this evening, a government employee leaked information about a fraud, and the elected governor identified and pressured the employee, and the employee committed suicide.
Public opinion is overwhelmingly blaming the governor, but the police and other authorities show no signs of acting.
Despite this current situation, anyway, it is legally true that “even the truth can be sued,” and is this different in the US or in the West?
I would like to know about the laws of the United States,
We all have secrets that we don't want people to know.
Is it illegal in the U.S. or in the West to outing someone else if you have the logic that it is a fact?
I am Japanese, but I am very surprised.
Of course, accusations of public value to society are not libel in Japan. Everything is judged on a case by case basis.
For bool, it could just be an alias of a numeric type. Something equivalent to number check(col = 0 or col = 1) would be perfectly fine.
Date/time handling is pretty weak. Having to store values as GMT text is just inconvenient.
When retrieving values in Node.js, I ended up using new Date(val), which caused the classic bug where a GMT-stored value gets interpreted in the local timezone.
The correct approach was new Date(val + ".Z"), but I really don’t want to deal with that kind of hassle anymore.