The Official Status Thread
-
Status: just discovered my phone's new default ringtone is a whimsical-as-fuck honky tonk jungle. What the bitch!
Edit: it's this one:
-
Status: 68% of this post in the status thread is not an actual status update.
-
@Tsaukpaetra said in The Official Status Thread:
@Gribnit said in The Official Status Thread:
@Tsaukpaetra you won't use that frequently unless you want to show mod history a lot
That's literally what I'm going to be doing. And why I'm considering adding that index.
Continuing my evaluation of this, this means that the Computed column of
Resolved AS CASE WHEN ModActionsID is NULL then 0 else 1 END
will no longer work.Considering if I should attempt a UDF and making the column PERSISTED (I don't think that will work very well) or rewriting all the scripts that need to know (73 percent of them) to
OUTER APPLY
the new table (which I think will be equally inefficient) to the output...Fuck it. I'm going to instead make Resolved an int column and add a After Insert trigger on that many-to-many table to just update the value. It's going to make the result counter thingy a little screwy (probably) but it's less complicated than what I've been trying to make work for the past three hours...
-
@Tsaukpaetra Why even have resolution logic be implemented at the database level? This seems like an application-realm thing that belongs at the opposite end of N-tier.
-
Status: Arguing with someone who wants to ban words like "cucumber" or "shim" from their whole codebase and API because that could lead to innuendo.
-
@Rhywden said in The Official Status Thread:
Status: Arguing with someone who wants to ban words like "cucumber" or "shim" from their whole codebase and API because that could lead to innuendo.
why are you using the word cucumber at all?
are you writing some kind of dwarf fortress farming robot?
-
@ben_lubar behavioral testing framework. So there's money in repackaging that?
-
@Gribnit said in The Official Status Thread:
@Tsaukpaetra Why even have resolution logic be implemented at the database level? This seems like an application-realm thing that belongs at the opposite end of N-tier.
I don't understand your question. A complaint is resolved if at least one mod action has been added in response to that complaint. The point in storing this status in the database is that the application doesn't need to keep all the mod actions in memory to compare against complaints they've been acted for in response to.
In other words: Make a single lookup of complaint data (i.e. table) when asking if a user has any complaints made on them, which data includes whether or not they have been resolved (ideally, so the ones that don't need addressing can be easily filtered out). Ideally without calculating data using another table for each row retrieved.
And in theory, the same for said mod actions (a single action could potentially be in response to multiple complaints, and vice-versa, and we want to know at a glance what that is, probably).
-
@anotherusername said in The Official Status Thread:
Status: 68% of this post in the status thread is not an actual status update.
Status now it's 67.976883485% thanks to me.
-
@Lorne-Kates Nope, needs fixed, fixing, almost done.
-
@Gribnit Damnit!
-
Status: editing in a proper salutation on a bunch of posts.
-
@Gribnit said in The Official Status Thread:
Status: editing in a proper salutation on a bunch of posts.
-
@dkf said in The Official Status Thread:
My least favourite is “Can I ask you a question?” as an opener. I'm always tempted to respond “You just did exactly that, you wazzock.”
I have. Well the first 3 words...
-
Status: End of day problem I've put off til tomorrow, trying to look into why, on our ASP.NET site, some Android devices are treating
<input type=number>
as<input type=tel>
despite the spec saying that unsupported types should fall back to text.I'm not ruling out .NET fuckery, thinking the Android devices don't support number, but the question in that case, if that is the case, is "why the fuck do you think 'telephone' is an acceptable fallback?"
-
@ChaosTheEternal said in The Official Status Thread:
Status: End of day problem I've put off til tomorrow, trying to look into why, on our ASP.NET site, some Android devices are treating
<input type=number>
as<input type=tel>
despite the spec saying that unsupported types should fall back to text.I'm not ruling out .NET fuckery, thinking the Android devices don't support number, but the question in that case, if that is the case, is "why the fuck do you think 'telephone' is an acceptable fallback?"
Due to the above posts, I read that as
<input type=cucumber>
-
@ChaosTheEternal 'cos it's numeric.
-
Status: Oh noes, Something Bad happened and I need to be interrupted with a popup window about...
Go away Steam! If I wasn't connected intentionally to Steam Friends or whatever (and the fact that the window was not existent before should be a good indicator that I don't want to be), you shouldn't be telling me I'm not connected...
-
@TwelveBaud @Tsaukpaetra IME discussion, R screenshot I just got:
-
@ChaosTheEternal said in The Official Status Thread:
Status: End of day problem I've put off til tomorrow, trying to look into why, on our ASP.NET site, some Android devices are treating
<input type=number>
as<input type=tel>
despite the spec saying that unsupported types should fall back to text.I'm not ruling out .NET fuckery, thinking the Android devices don't support number, but the question in that case, if that is the case, is "why the fuck do you think 'telephone' is an acceptable fallback?"
Chrome's developer tools have (or had) a thing where it would suggest autocomplete types for fields without autocomplete defined, and it frequently suggested "telephone", "credit card", and "organization" on a form that I don't think asked for any numbers or real world information at all.
-
@hungrier said in The Official Status Thread:
WildTangent
Wow, I haven't heard that name in forever.
-
@dcon said in The Official Status Thread:
@dkf said in The Official Status Thread:
My least favourite is “Can I ask you a question?” as an opener. I'm always tempted to respond “You just did exactly that, you wazzock.”
I have. Well the first 3 words...
Yesterday, someone entered #dfhack and this was the first thing they said:
Hey, is it okay to ask about [name of DFHack command] in here?
What channel did they think we were going to send them to if the answer was no?
What did they think we would do if they had asked the question and it wasn't okay to ask a question?
-
@ben_lubar the most fucking annoying thing in help channels is when people ask if they can ask a question
-
@pie_flavor would have thought it would be when people are going on about something, that if they had just looked, they would have seen was literally just covered. that would be maddening.
-
@Gribnit said in The Official Status Thread:
@pie_flavor would have thought it would be when people are going on about something, that if they had just looked, they would have seen was literally just covered. that would be maddening.
Oh, that too. The number of people who join the Sponge channel, ignore the message 'This channel is for discussion of the SpongePowered server software', ignore the message 'Do NOT ask us about Essentials/EssentialsX!', and start asking how they can get Essentials on their Spigot server, is simply baffling.
-
status Damn designers. We have a standard Windows dialog. With standard Windows buttons. Looks like all Windows users expect dialogs to look like. Good enough? (Would I be posting if it was?)
- Must change the background color
- All text color has to change (static and edit controls)
- Buttons? Yeah, them too. Some are custom (2 different ones). The disabled button also has custom text and background.
Someone is going to die.
-
@dcon Do the designers know that the users will see that dialog as "weird, maybe broken" in response to their loving ministrations?
-
@pie_flavor said in The Official Status Thread:
@hungrier said in The Official Status Thread:
WildTangent
Wow, I haven't heard that name in forever.
I'm not sure I've ever heard of it, but the name certainly fits most threads on this forum.
-
@HardwareGeek They made a couple of old Windows bloatware games, like Blasterball and Polar Bowler.
-
@Gribnit said in The Official Status Thread:
@pie_flavor would have thought it would be when people are going on about something, that if they had just looked, they would have seen was literally just covered. that would be maddening.
The concept of "what people were talking about before I got here" is not a thing IRC servers are set up to tell you.
-
@ben_lubar This thing is hooked to IRC? Neat!
-
@Gribnit said in The Official Status Thread:
@ben_lubar This thing is hooked to IRC? Neat!
Yeah! irc://chat.freenode.net/thedailywtf
-
@Gribnit said in The Official Status Thread:
@ben_lubar This thing is hooked to IRC? Neat!
With Node.js, I'd guess it's most likely rather messy.
-
Status: Someone is on a speaker phone in a conference room near me, having a conversation in a language (Mandarin?) I don't understand. Loudly enough that I can hear both sides of the conversation. The woman on the other end sounds rather agitated, possibly angry and/or hysterical.
-
@gribnit said in The Official Status Thread:
@dcon Do the designers know that the users will see that dialog as "weird, maybe broken" in response to their loving ministrations?
They don't care.
ALL UI MUST MEET NEW THEMING COLORS!!1!!! We KNOW WHAT COLORS ARE BEST FOR THE USER!!!
(I try to use standard windows colors, I lost)
-
@dcon Can you hit them with an accessibility bat? It's kinda left field but overriding the user's display preferences can completely override their ability to use the app.
-
Status: I am being serious right, exactly, now and for a tiny amount of time before and after.
-
@gribnit said in The Official Status Thread:
@dcon Can you hit them with an accessibility bat? It's kinda left field but overriding the user's display preferences can completely override their ability to use the app.
Not really. Cause we're already really bad on that front! Keyboard navigation? Ha! (Yeah, our designers all work on Macs - how'd you guess?)
-
@dcon Fuck. I'm out of legal ideas here.
-
@gribnit said in The Official Status Thread:
@dcon Fuck. I'm out of legal ideas here
Meh. Next up is the conversion to Electron. I figure I have about a year before I need to bail and find another company...
-
@Tsaukpaetra said in The Official Status Thread:
Ideally without calculating data using another table for each row retrieved.
Done. My stupid joiner table thing now updates the other two tables when something happens to it. It looks like this:
teh codez
BEGIN TRANSACTION CREATE TABLE dbo.CHAR_ComplaintsModActionsResolution ( ComplaintID int NOT NULL, ModActionsID int NOT NULL ) ON [PRIMARY] GO ALTER TABLE dbo.CHAR_ComplaintsModActionsResolution ADD CONSTRAINT PK_CHAR_ComplaintsModActionsResolution PRIMARY KEY CLUSTERED ( ComplaintID, ModActionsID ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ALTER TABLE dbo.CHAR_ComplaintsModActionsResolution ADD CONSTRAINT FK_CHAR_ComplaintsModActionsResolution_CHAR_Complaints FOREIGN KEY ( ComplaintID ) REFERENCES dbo.CHAR_Complaints ( ID ) ON UPDATE NO ACTION ON DELETE NO ACTION ALTER TABLE dbo.CHAR_ComplaintsModActionsResolution ADD CONSTRAINT FK_CHAR_ComplaintsModActionsResolution_CHAR_ModActions FOREIGN KEY ( ModActionsID ) REFERENCES dbo.CHAR_ModActions ( ID ) ON UPDATE NO ACTION ON DELETE NO ACTION IF EXISTS( SELECT * FROM sys.triggers WHERE name = N'CHAR_ComplaintsModActionsResolution_AfterInsert' AND parent_class_desc = N'OBJECT_OR_COLUMN') DROP TRIGGER dbo.CHAR_ComplaintsModActionsResolution_AfterInsert GO CREATE TRIGGER dbo.CHAR_ComplaintsModActionsResolution_AfterInsert ON dbo.CHAR_ComplaintsModActionsResolution AFTER INSERT,DELETE,UPDATE AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; --Update any complaints affected by this with Complaints as( select distinct ComplaintID from inserted union select distinct ComplaintID from deleted ) update CHAR_Complaints SET ModActions = b.ModActions FROM CHAR_Complaints c join Complaints cv on c.ID = cv.ComplaintID CROSS APPLY (select COUNT(ComplaintID) ModActions from CHAR_ComplaintsModActionsResolution where ComplaintID = cv.ComplaintID) b WHERE ID = c.ID ; --Update any ModActions affected by this with ModActions as( select distinct ModActionsID from inserted union select distinct ModActionsID from deleted ) update CHAR_ModActions SET Complaints = b.Complaints FROM CHAR_ModActions c join ModActions cv on c.Id = cv.ModActionsID CROSS APPLY (select COUNT(ModActionsID) Complaints from CHAR_ComplaintsModActionsResolution where ModActionsID = cv.ModActionsID) b WHERE ID = c.Id ; END GO Commit
It appears to work, and in theory this should satisfy all my needs. Adding/removing should be doozies for when there are many complaints/actions, but in general it's expected to be mostly 1-1 unless many people report the same complaint or many actions are performed in response to a complaint. We'll see...
Pretty sure that it's not handling updates to that table properly, but since that should never happen (should only be adding and very occasionally removing entries) I'm not going to bother fixing that.
-
@ben_lubar Yeah, the problem I have to look into isn't that. It's Android showing the wrong keyboard (phone keyboard vs. number keyboard), and I have to troubleshoot it without access to a device that exhibits the problem (my personal phone and the dev/test device we have shows the right keyboard).
-
@ChaosTheEternal fun. Anything let you check for support and provide some kind of js garbage if no support?
-
status: now that I've updated and my phone isn't starving for megabytes, I'm trying Apps again.
I try Pokemon go.
No!
Why the fuck do you need to read my contacts, fuckers?!?
-
@Tsaukpaetra To look for potential friends. It doesn't need to; that's why it's asking.
-
@pie_flavor said in The Official Status Thread:
@Tsaukpaetra To look for potential friends. It doesn't need to; that's why it's asking.
Potential friends? Oh that's easy. "hey bob, you do that Pokemon thing? Yeah? Sweet!" there we go. No need to steal my contact information for that.
And it wasn't asking, it just went and tried to access my contacts (before even logging in WTF!) with no explanation or anything.
-
@Tsaukpaetra That window was the asking. If you push deny, then you've said no. If you push allow, then you've said yes.
-
@pie_flavor said in The Official Status Thread:
@Tsaukpaetra That window was the asking. If you push deny, then you've said no. If you push allow, then you've said yes.
No, that window was Google's answer to apps running willy nilly with permissions their users never glanced at and complained about when abused. It indicates that the app assumed it was fine to access contacts and just did it.
I might possibly be understanding if, after logging in and completing some kind of tutorial, it had a screen (or button, Apps are all about them buttons!) for adding friends, upon which clicking it would display something to the effect of "Sifting through your contacts to see if we know any of them!" and then that dialog window would pop up.
Instead, what I got was a two logos, some music, then BAM! Contacts rape. No explanation, no warning, and on earlier Androids it would have silently let Niantic gobble all my contacts, ripe for the selling.
No. Thanks.
-
@Tsaukpaetra said in The Official Status Thread:
@pie_flavor said in The Official Status Thread:
@Tsaukpaetra That window was the asking. If you push deny, then you've said no. If you push allow, then you've said yes.
No, that window was Google's answer to apps running willy nilly with permissions their users never glanced at and complained about when abused. It indicates that the app assumed it was fine to access contacts and just did it.
False. Requesting the permission is a separate action from using the permission.
I might possibly be understanding if, after logging in and completing some kind of tutorial, it had a screen (or button, Apps are all about them buttons!) for adding friends, upon which clicking it would display something to the effect of "Sifting through your contacts to see if we know any of them!" and then that dialog window would pop up.
So it should notify you that it's about to notify you? That's as dumb as the NodeBB toaster asking you whether it's okay to ask you whether it's okay to show notifications.
Instead, what I got was a two logos, some music, then BAM! Contacts rape. No explanation, no warning,
It's very obvious what it's for. You learn these things after a while. And you know what you can just as easily do if your answer is 'no'?
Click deny.
Boom, done, easy. I don't know why you're so annoyed by this.and on earlier Androids it would have silently let Niantic gobble all my contacts, ripe for the selling.
Incorrect. An app for older Android versions tells you what permissions it requires when you install it.
-
@pie_flavor said in The Official Status Thread:
False. Requesting the permission is a separate action from using the permission.
Android provides several methods you can use to request a permission, such as
requestPermissions()
, as shown in the code snippet below. Calling these methods brings up a standard Android dialog, which you cannot customize.