OMG, I’m dealing with a developer right now that is dealing with patient collected samples in several timezones, allowing the patients to either enter the time they collected, or use current time, and storing it in UTC time.

We do not receive any timezone data, patient collection data is showing different days than the patient could write on their samples depending on the time of day, and the developer said ‘just subtract X hours’ (our timezone)… for which not all patients would live in.

I suppose I could, if they’d provide the patient’s timezone, but they don’t even collect that. Can you just admit your solution is bad? It’s fine to store a timestamp in UTC, but not user provided data… don’t expect average users to calculate their time (and date) in UTC please.

This only makes me favor copyright reform more. Should really cut that down to 25 years or less; anything from before the 21st century should be public domain by now.

I project I keep up on uses Discord for chat, help, and announcements, but…

They maintain a full website for documentation, and use github for bug reports, issue tracking, project discussion, other project management.

I like discord being a part of the community, but I can cant imagine people making it the project management, or documentation tool.

I get people’s argument for results not coming up from the #help discord channel when searching Google, but I’m fine with how active the help channel is, and how searchable discord is in this case.

For those having trouble filtering to a specific channel:

In the past I would get full server (or multi-server) search. Its not happening now, but how I got it to focus:

Click inside the message input box like you are typing a message, then hit Ctrl+F. That would send me to the search box with “in #channel-name” to filter for only said channel.

That SELECT and WHERE are all caps, but from is not is bugging me.

I don’t care if you choose to uppercase keywords or lowercase, but consistency please.

Also, great, love it.