UI Bites
-
@Applied-Mediocrity said in UI Bites:
@Tsaukpaetra said in UI Bites:
Idgi plz eli6
Remaining time 2:60.
It showed 3:00 before that, too.Leap seconds?
According to some of my pupils, that's a perfectly cromulent amount of time.
The pupils "educated" by your apprentice?
-
@Applied-Mediocrity said in UI Bites:
Remaining time 2:60.
It showed 3:00 before that, too.Doing time calculations in
mysql
.
The sum of 0:51 and 0:52 results in 1:03.
Posted such an example some where in the long forgotten past...Edit:
Yeah, long ago....In a MySQL table, the start and en time of using a service are recorded. I tried to get the sum of usage per user and day:
SELECT OriginationName, Date(StartTime), count(*), sum(timediff(endtime,starttime)) as duration FROM ippbxcdr Group by OriginationName, Date(StartTime) order by OriginationName, Date(StartTime)
With a start time of '2012-08-21 15:02:29' and an end time of '2012-08-21 15:03:59', that duration of 1 minute 30 seconds was shown as 130.0000.
No, no, no: thou shalt not use sum with timediff!
The Lord of MySQL giveth no error message, he punisheth with a wrong result.....
Yes, I found a solution:SEC_TO_TIME( sum( time_to_sec(endtime)-time_to_sec(starttime))) as Duration
Looks complicated, but it works.
-
@BernieTheBernie said in UI Bites:
FROM ippbxcdr
You seem to have sane, descriptive column names, so how comes you have such cryptic table names?
@BernieTheBernie said in UI Bites:
SEC_TO_TIME( sum( time_to_sec(endtime)-time_to_sec(starttime))) as Duration
Still better than SQLite:
Compute the time since the unix epoch in seconds with millisecond precision:
SELECT (julianday('now') - 2440587.5)*86400.0;
⌠because for some reason
The unixepoch() always returns an integer, even if the input time-value has millisecond precision.
But then, SQLite at least has some excuse in not actually having a datetime type. MySQL/MariaDB should have one.
-
@Bulb Use unix epoch seconds, julian day numbers, or full ISO timestamps with a defined timezone. Don't mix.
-
You seem to have sane, descriptive column names, so how comes you have such cryptic table names?
That's obviously a table containing IP PBX CDRs.
It's not @BernieTheBernie's fault we don't know what those are.
-
That's obviously a table containing IP PBX CDRs.
That actually makes sense with those column names.
-
@Bulb Use unix epoch seconds, julian day numbers, or full ISO timestamps with a defined timezone.
Don't mixSwitch at each tier.
-
@Bulb Use unix epoch seconds, julian day numbers, or full ISO timestamps with a defined timezone.
Don't mixSwitch at each tier.Whatever you do, don't switch on a per-row basis.
(There was a question on this topic on the SQLite forum recently; the collected wisdom was " Don't mix things like that!" Unsurprisingly, collating such datasets is a bit tricky when you don't have the central concept of a DATETIME column.)
-
@dkf In general, you'll get better performance if you minimize the amount of per-record work. Even more so for records you are going to end up discarding.
-
@dkf That's ⌠a proper .
Though⌠it's fixable. You can obviously tell a string from a number, so picking out which are iso-8601 times should be easy. And then, Julian days reasonably far into future, when interpreted as Unix timestamps, all fall towards the end of January 1970, so if you know you don't have any dates from January 1970 nor dates in really far future, you can reasonably distinguish which numbers are Julian days and which are Unix timestamps. And concoct an update statement to bring it all to a common format.
-
And concoct an update statement to bring it all to a common format.
Apply, and... weep, for something has Gone Wrong.
-
@Bulb Use unix epoch seconds, julian day numbers, or full ISO timestamps with a defined timezone.
Don't mixSwitch at each tier.Whatever you do, don't switch on a per-row basis.
(There was a question on this topic on the SQLite forum recently; the collected wisdom was " Don't mix things like that!" Unsurprisingly, collating such datasets is a bit tricky when you don't have the central concept of a DATETIME column.)
That reminds me of a previous job in which I had to parse errors from log files of (simulated) chip tests and find the first error (because other reported errors may be side effects of the first one). Chips run at speeds in GHz, which means events in the chip (and thus in the log files) may be separated by <1 ns. There was no common timestamp format among the various log files I had to parse. Some logs contained timestamps printed in ps, some in ns (with or without digits to the right of the decimal point), and some in Îźs. In addition to the varying formats, varying precision meant that a time stamp of, say, 100 ns in one file might actually have occurred later than 100.1 ns in another file, because the first one simply truncated what should have been 100.2 (or something; who knows? The information was discarded).
-
And concoct an update statement to bring it all to a common format.
Apply, and... weep, for something has Gone Wrong.
something?
You mean:
the backup.
-
@BernieTheBernie said in UI Bites:
And concoct an update statement to bring it all to a common format.
Apply, and... weep, for something has Gone Wrong.
something?
You mean:
the backup.That too, then. Escalate to drinking.
-
Status: This application has Ctrl+X as the Exit shortcut.
What kind of moron... Oh wait, the author proudly put his name in the About box.
Good thing he's not here.
-
@Tsaukpaetra Way back in the DOS era {Ctrl,Alt}+[QZX] where the first key combinations to try to exit an application. But yeah, not anymore ď
-
@Tsaukpaetra Way back in the DOS era {Ctrl,Alt}+[QZX] where the first key combinations to try to exit an application. But yeah, not anymore ď
I could understand Ctrl-Q. I might excuse Alt-X. Maybe even Ctrl-Shift-Z. But stealing a very popular shortcut for no fuckin' reason is capricious!
I mean, really, how often are you really in such a hurry to exit this application that you even need a shortcut to do so?
-
@Tsaukpaetra said in UI Bites:
@Tsaukpaetra Way back in the DOS era {Ctrl,Alt}+[QZX] where the first key combinations to try to exit an application. But yeah, not anymore ď
I could understand Ctrl-Q. I might excuse Alt-X. Maybe even Ctrl-Shift-Z. But stealing a very popular shortcut for no fuckin' reason is capricious!
I mean, really, how often are you really in such a hurry to exit this application that you even need a shortcut to do so?
I mean, how else are you going to hide your video watching habits when your boss shows up?
-
@Tsaukpaetra said in UI Bites:
@Tsaukpaetra Way back in the DOS era {Ctrl,Alt}+[QZX] where the first key combinations to try to exit an application. But yeah, not anymore ď
I could understand Ctrl-Q. I might excuse Alt-X. Maybe even Ctrl-Shift-Z. But stealing a very popular shortcut for no fuckin' reason is capricious!
I mean, really, how often are you really in such a hurry to exit this application that you even need a shortcut to do so?
I mean, how else are you going to hide your video watching habits when your boss shows up?
By... continuing to use the "Secure Password Share" application and not watching videos?
-
@Tsaukpaetra said in UI Bites:
Status: This application has Ctrl+X as the Exit shortcut.
Filed under:
nano
-
@Tsaukpaetra said in UI Bites:
I mean, really, how often are you really in such a hurry to exit this application that you even need a shortcut to do so?
All macOS apps use the same shortcut to exit (Cmd+Q). Almost all of them also use the same shortcut for close this window (Cmd+W) too, where it makes sense. Consistency is important.
-
@Tsaukpaetra said in UI Bites:
I could understand Ctrl-Q. I might excuse Alt-X. Maybe even Ctrl-Shift-Z. But stealing a very popular shortcut for no fuckin' reason is capricious!
Yup, that was dumb. Especially if it has any text input controls.
I mean, really, how often are you really in such a hurry to exit this application that you even need a shortcut to do so?
I don't know for your specific application, but I find it very handy that Alt-F4 is Quit for almost all applications.
-
-
Especially if it has any text input controls.
GUESS HOW I FOUND OUT?
I seriously thought it was crashing when I was trying to cut some text from it. In fact, that's what I was going to post, before I dug around the menus just in case.
-
I just booked a rental car for a trip this summer, and got this email today:
That sounds about right, your email is indeed just a pretext to spam me.
-
Forking from my lounge rant about Outlook Web App:
I now clicked the calendar thing for the first time. It takes 3 seconds to display the Outlook icon loading animation, then about 15 seconds until it loads all events. And that's not just the first time, when you refresh the page it takes just as long again.
Among the first things it tells me (somewhere in the "notifications area"? I don't remember) is that they've added new colors to the calendars. Good to know that Microsoft Research spends their time inventing new colors, will be happy. And look, it's randomly assigned different colors to coworkers' calendars and mine, and picked bright yellow for mine. Which it uses as theme color for random shit:
Amazing readability.
Fortunately, after I changed the display language, it also rolled the dice again on all the colors. Because those are related, obviously.
-
Fortunately, after I changed the display language, it also rolled the dice again on all the colors. Because those are related, obviously.
Makes you want to use colourful language, does it?
-
Status: This checkbox!
It does NOTHING!
-
@Tsaukpaetra
My employer's (3rd-party; I've used exactly the same website for a couple of employers) timekeeping/payroll website:
Also does nothing.
-
@HardwareGeek said in UI Bites:
@Tsaukpaetra
My employer's (3rd-party; I've used exactly the same website for a couple of employers) timekeeping/payroll website:
Also does nothing.you never specified how long they should remember you for.
-
@izzion As long as the idle timeout lasts. As soon as the idle timer logs you out, it forgets everything.
-
There are some poking browser plugins that refresh the page now and then to prevent idle timeouts.
-
@Tsaukpaetra said in UI Bites:
Status: This checkbox!
It does NOTHING!
It keeps you signed in.
For as long as they know it's you, anyway.
-
you never specified how long they should remember you for.
They remember it's him. They just don't care.
-
@Tsaukpaetra Are you sure you haven't blocked cookies, or set them to be auto-removed on close?
-
@Medinoc Are you insinuating @Tsaukpaetra broke something?
-
@Tsaukpaetra said in UI Bites:
It does NOTHING!
It might set a persistent cookie. Or maybe it won't. And maybe the tightened up security these days won't actually let the shitty code access that cookie, depending on how they've done it.
What it won't do is make the session last any longer.
-
@Medinoc Are you insinuating @Tsaukpaetra broke something?
-
I have 2FA enabled on my Google account. Google apparently isn't aware of this.
-
@Tsaukpaetra said in UI Bites:
Status: This checkbox!
It does NOTHING!
They're just following the industry's Best Practices , as exemplified by Microsoft.
Not only does it not really stay signed in (given how often I get this dialog), but clearly "don't show this again" works exactly like your checkbox (i.e. it does not).
-
@remi
worst thing is that if you are on O397 and running teams, outlook, onedrive, etc ... it will literally bombard you with messages because all apps want you to sign in again ... also if you do sign in again all other apps have 50% of working correctly ... sometimes you can get away with just closing the 'sign in' pop-up ... the app will notice you signed in already and continue, often you need to restart the app or sign in twice to get everything to play cool again. Just pray the message to the MS Authenicator app works or you're stuck in a loop where it needs you to sign in but you need the 2FA app the acknowledge there is a request to approve.
Fun times.
-
@loopback0 said in UI Bites:
I have 2FA enabled on my Google account. Google apparently isn't aware of this.
But they seem to be aware of the possibility of it being turned on <!--â->already.
-
@Tsaukpaetra Are you sure you haven't blocked cookies, or set them to be auto-removed on close?
I read the code.
-
@HardwareGeek said in UI Bites:
As soon as the idle timer logs you out, it forgets everything.
-
@Luhmann My company
uses all thathas been swallowed byMolochMicrosoft, and things are set up so that it doesn't require authentification if we are on the company network (i.e. physically in the office) or connected to it through VPN. Which is pretty nice when it works, but of course sometimes it doesn't.So when I'm at home and turns my computer on, I sometimes get all of these messages popping up, before I have time to turn the VPN on. Then it's basically random, some dialogs I can just close, some even disappear by themselves, some keep popping up again so I need to type my password (but no 2FA required even though if I'm not using the VPN it would require 2FA!)...
Even -ier, sometimes a chunk of this synchronisation breaks down. So I might no longer get access to my emails, but Teams might still work. When that happens, sometimes closing down all stuff and reopening it works (but you have to truly quit applications, of course, not just close-means-minimising-to-tray). Sometimes it needs a logout/login (i.e. re-entering credentials, I guess). But recently when that happened the official solution from IT is to go into whatever settings where your Windows account is associated with a Microsoft account, de-associate and re-associate again.
As always, I'm so glad computers are deterministic devices.
:sarkmark:
Fun times.
Indeed.
-
you never specified how long they should remember you for.
Also, I've found that every time FireFox has a major number update, I'm forgotten everywhere. Which since that's about the frequency I log into some accounts, means remember me works that same. At least FF didn't forget the password.
-
worst thing is that if you are on O397 and running teams, outlook, onedrive, etc
...then someone conned you into buying counterfeit software.
-
@boomzilla said in UI Bites:
worst thing is that if you are on O397 and running teams, outlook, onedrive, etc
...then someone conned you into buying counterfeit software.
: But the Russian I bought it from said it was safe!
-
Not only does it not really stay signed in (given how often I get this dialog), but clearly "don't show this again" works exactly like your checkbox (i.e. it does not).
My mileage clearly varies. a) it does not keep asking me and b) it keeps me logged in basically all the time until the password expires in half a year everywhere.
-
Not only does it not really stay signed in (given how often I get this dialog), but clearly "don't show this again" works exactly like your checkbox (i.e. it does not).
My mileage clearly varies. a) it does not keep asking me and b) it keeps me logged in basically all the time until the password expires in half a year everywhere.
Just wait till you update to the new VS 2022 (17.2). That made me log in again.