Charcoal HQ

10:00 PM

@ArtOfCode Yeah, cuz now we have better timing data

So graphs of average db/view time over time

tpu- feedback received

[ SmokeDetector | MS ] Potentially bad keyword in body, potentially bad keyword in title (2): Help! What is wrong with this Coleus? Overwatered? Underwatered? by M Clarke on gardening.SE

ArtOfCode

@thesecretmaster Oh, gotcha

SmokeDetector

[ SmokeDetector | MS ] Link at end of answer (60): Polygons for postcodes in Spain by Alonso V on gis.SE

[ SmokeDetector | MS ] Potentially bad keyword in body (1): Toy problem: How much should I rationally be willing to pay for this hypothetical and simplified insurance? by cpotter on math.SE (@FrenzyLi)

[ SmokeDetector | MS ] Potentially bad keyword in body (1): Rational risk-assessment decision framework: Should I buy health insurance? ✏️ by cpotter on money.SE

ArtOfCode

[
  { name: 'series-name', data: [ [x0, y0], [x1, y1], ... ] },
  ...
]

@thesecretmaster ^ that's the format that routes need to return to go into a graph

as JSON

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in body (97): Some help on Bayes Statistics/probability problem by dumbboi on math.SE (@FrenzyLi)

[ SmokeDetector | MS ] Potentially bad keyword in body (1): Hybris 30 days license expired by JuanDroid on stackoverflow.com

thesecretmaster

10:19 PM

@ArtOfCode So... I need to deal with i.e. averaging data per-hour server-side?

ArtOfCode

yup

Not difficult, use group_by_hour_of_day and SQL AVG

look at graphs_controller for examples

SmokeDetector

naa feedback received on How to stop Windows Form program execution until text box input is given? [MS]

naa feedback received on How can I run Warcraft 3 on Ubuntu 18.04? [MS]

fp feedback received on Help! What is wrong with this Coleus? Overwatered? Underwatered? [MS]

angussidney

!!/pull

SmokeDetector

[ SmokeDetector ] SmokeDetector started at rev 98ad1b7 (angussidney: Prevent reply commands from lowercasing comments (fixes #2637)) (running on teward/Lunar Eclipse, Python 3.6.7)

fp feedback received on Polygons for postcodes in Spain [MS]

Restart: API quota is 7017.

fp feedback received on Toy problem: How much should I rationally be willing to pay for this hypothetical and simplified insurance? [MS]

fp feedback received on Rational risk-assessment decision framework: Should I buy health insurance? [MS]

[ SmokeDetector | MS ] Potentially bad keyword in answer (1): How to stop Windows Form program execution until text box input is given? by Darnold on stackoverflow.com

angussidney

@SmokeDetector n testing SILLY cOmmeNT capitalisation

SmokeDetector

10:23 PM

@angussidney That report was a question; questions cannot be marked as NAAs.

fp feedback received on Some help on Bayes Statistics/probability problem [MS]

angussidney

@SmokeDetector f testing SILLY cOmmeNT capitalisation

\o/

SmokeDetector

naa feedback received

thesecretmaster

@ArtOfCode Except the data is in redis

ArtOfCode

oh, bugger

well I have approximately zero idea how you do that, then

thesecretmaster

Maybe the graphing lib has magic?

ArtOfCode

10:29 PM

Chartkick doesn't

It's aimed straight at doing it with SQL

Highcharts... we'll see

thesecretmaster

I mean, it's easy to get x,y pairs from redis, I just want to be able to smooth it.

ArtOfCode

Might be able to do it in JS

thesecretmaster

I can also write a redis module to round timestamps to the nearest n, but that seems like overkill.

ArtOfCode

...just a little

thesecretmaster

I think this should happen client side though

Maybe there's a ruby lib for it?

Also, you know that the specific time incriment I'm rounding to doesn't matter, I just want some neat graphical representation of page load speed over time?

SmokeDetector

10:37 PM

[ SmokeDetector | MS ] Link at end of answer (60): Polygons for postcodes in Spain by Alonso V on gis.SE

thesecretmaster

Maybe there's a better way to do this?

SmokeDetector

fp feedback received

ArtOfCode

Okay, I've had a look at doing it in JS... let's not

given how disgusting that code would be, ruby it is

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in body (1): Toy problem: How much should I rationally be willing to pay for this hypothetical and simplified insurance? ✏️ by cpotter on math.SE (@FrenzyLi)

ArtOfCode

@thesecretmaster how'd you get (x, y) pairs from redis?

thesecretmaster

10:44 PM

@ArtOfCode zrange

ArtOfCode

If you can give me an array of pairs, I can probably figure out a decent way to stick a moving average on them in ruby

thesecretmaster

Oh sure, 1 sec

zrevrange request_timings/total/by_action/<controller>#<action> 0 -1 WITHSCORES

@ArtOfCode ^^

ArtOfCode

right

having realised that I'm dumb, JS might also work

thesecretmaster

:P

Um...

Something is broken

ArtOfCode

nope, no, I was right, it won't

thesecretmaster

10:49 PM

AIM is deeply unhappy

ArtOfCode

usually is

thesecretmaster

Oh yes that again

Ssssh nothing happened

Ehm... something happened

Okey, 1 sec

@Undo Around?

Alrighty, purging a lot of requests

SmokeDetector

iBug/EC2 received failover signal.

fp feedback received

Restart: API quota is 19960.

fp feedback received

thesecretmaster

MS back alive, sorry y'all

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in body (1): Where can I find an aviation headset to mini-jack adapter? ✏️ by user9943887 on aviation.SE (@TetsuyaYamamoto)

[ SmokeDetector | MS ] Potentially bad keyword in body, potentially bad keyword in title (2): Help! What is wrong with this Coleus? Overwatered? Underwatered? by M Clarke on gardening.SE

[ SmokeDetector | MS ] Blacklisted website in answer (92): Why won't my files import into garageband? ✏️ by New Beginningboy on apple.SE

ArtOfCode

11:06 PM

def moving_avg(pts)
  yv = pts.map(&:last)
  ad = yv.map.with_index { |v, i| yv[([0, i-3].max)..([i+3, yv.size].min)].sum / (([0, i-3].max)..([i+3, yv.size].min)).size.to_f }
  pts.map.with_index { |e, i| [e[0], ad[i]] }
end

@thesecretmaster ^

thesecretmaster

Will it be expensive?

ArtOfCode

Shouldn't be, but lemme benchmark it

What kinda size of dataset am I expecting?

thesecretmaster

What's action/controller on status-update.json?

ArtOfCode

status#status_update

SmokeDetector

[ SmokeDetector | MS ] Body starts with title and ends in url (98): compare 2 stl files by Marcin on blender.SE

thesecretmaster

11:10 PM

About 100k, if you want full history. Stopping it at about a month gives us a couple thousand I think.

SmokeDetector

[ SmokeDetector | MS ] Body starts with title and ends in url (98): compare 2 stl files by Marcin on blender.SE

ArtOfCode

@thesecretmaster 100k pairs?

thesecretmaster

Yep

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in answer (1): How fix AndroidManifest.xml ✏️ by Dana Dahlstrom on stackoverflow.com

ArtOfCode

okey doke

SmokeDetector

11:11 PM

[ SmokeDetector | MS ] Potentially bad keyword in answer (1): How fix AndroidManifest.xml ✏️ by Dana Dahlstrom on stackoverflow.com

thesecretmaster

1 for each time the route gets hit

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in answer (1): Android Studio Auto Generated public final class R file ✏️ by Dana Dahlstrom on stackoverflow.com

Erik the Outgolfer

!!/location

SmokeDetector

@EriktheOutgolfer teward/Lunar Eclipse

@EriktheOutgolfer iBug/EC2

Erik the Outgolfer

!!/standby ec2

SmokeDetector

11:11 PM

[ SmokeDetector ] SmokeDetector started in standby mode at rev 5b304a1 (SmokeDetector: Auto watch of datatrained\.com by Shree) (running on iBug/EC2)

Undo

@thesecretmaster Still need me? 40% here, 60% fighting 3D printer

thesecretmaster

Nah, thanks for checking though

SmokeDetector

fp feedback received on Why won't my files import into garageband? [MS]

Undo

k, thanks for handling whatever it was

SmokeDetector

fp feedback received on compare 2 stl files [MS]

thesecretmaster

11:13 PM

@Undo Well, I asked a SO question...

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in answer (1): Android studio: XML document structures must start and end within the same entity by Dana Dahlstrom on stackoverflow.com

thesecretmaster

0

Q: After loading from RDB dump, no keys have TTL set

I have a redis database which is configured to persist with RDB. It grows very quickly, but has maxmemory 80mb and maxmemory-policy volatile-ttl. The reason I need volatile ttl is because there are certain keys which absolutely cannot be evicted without breaking the application. The vast majority...

redis

ArtOfCode

@thesecretmaster 70ms

thesecretmaster

Nice

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in answer (1): How long does caulk need to dry in a 1" gap? by Answer the question on diy.SE

ArtOfCode

11:15 PM

I set it to benchmark 10 times to average it and fully expected it to take a few seconds for a million pairs... nope, under a second

SmokeDetector

[ SmokeDetector | MS ] Bad keyword with email in answer, pattern-matching email in answer, potentially bad keyword in answer (185): MySQL sum amounts for transactions related to loans, in reverse order by Norisa Waye on stackoverflow.com

[ SmokeDetector | MS ] Potentially bad keyword in answer (1): After Windows crashed custom classes converted into the R class by Dana Dahlstrom on stackoverflow.com

ArtOfCode

to be fair, it is only O(n)

thesecretmaster

I won't use it unless it runs in O(1) :P

SmokeDetector

fp feedback received on How fix AndroidManifest.xml [MS]

ArtOfCode

Good luck with that one ;)

SmokeDetector

11:17 PM

fp feedback received on Android Studio Auto Generated public final class R file [MS]

fp feedback received on Android studio: XML document structures must start and end within the same entity [MS]

[ SmokeDetector | MS ] Few unique characters in answer, mostly dots in answer (120): Solving a system of equations using matrix form by job on mathematica.SE

[ SmokeDetector | MS ] Potentially bad keyword in answer (1): Android Studio 3.2.1 keeps corrupting Java files on weird XML by Dana Dahlstrom on stackoverflow.com

fp feedback received on How long does caulk need to dry in a 1" gap? [MS]

tp feedback received on MySQL sum amounts for transactions related to loans, in reverse order [MS]

Erik the Outgolfer

@thesecretmaster yeeeeah... soooo, this is how a friend of a cousin of an uncle of mine got fired... he shouted at everything above O(1)... obviously, his coworkers weren't too happy... ;)

SmokeDetector

fp feedback received on After Windows crashed custom classes converted into the R class [MS]

tp feedback received on Solving a system of equations using matrix form [MS]

fp feedback received

[ SmokeDetector | MS ] Potentially bad keyword in answer (1): java and xml files corrupted by weird XML in Android Studio(3.2.1) by Dana Dahlstrom on stackoverflow.com

thesecretmaster

GOSH DARN TYPOS

SmokeDetector

fp feedback received

[ SmokeDetector | MS ] Bad keyword with email in answer (85): Issue symfony 4.2 and postgresql by Emmanuel Beranger on stackoverflow.com

thesecretmaster

Welp, now I need to purge every single request from our logs

That's fun

SmokeDetector

11:27 PM

naa feedback received

[ metasmoke-deploy ] deploy started by thesecretmaster

[ metasmoke ] ci/circleci: js failure on e01eb94: Your tests failed on CircleCI

[ SmokeDetector | MS ] Potentially bad keyword in answer (1): My Activity Class turn into an xml file by Dana Dahlstrom on stackoverflow.com

thesecretmaster

@ArtOfCode Any objection s to me purging all the redis logs ever?

SmokeDetector

[ metasmoke ] ci/circleci: rubocop failure on e01eb94: Your tests failed on CircleCI

ArtOfCode

nope

thesecretmaster

Say bye :'(

SmokeDetector

fp feedback received

tp feedback received on Android studio: XML document structures must start and end within the same entity [MS]

tpu- feedback received on Android Studio 3.2.1 keeps corrupting Java files on weird XML [MS]

Makyen

11:38 PM

@SmokeDetector 7 answers saying the same thing is way too many. I'm calling it TP, as we'd would want to block this.

SmokeDetector

tpu- feedback received

[ metasmoke ] ci/circleci: rails-tests failure on e01eb94: Your tests failed on CircleCI

tpu- feedback received on java and xml files corrupted by weird XML in Android Studio(3.2.1) [MS]

tpu- feedback received on After Windows crashed custom classes converted into the R class [MS]

tpu- feedback received on Android Studio Auto Generated public final class R file [MS]

tpu- feedback received on How fix AndroidManifest.xml [MS]

thesecretmaster

What is status_update.json?

It gets hit so frequently

SmokeDetector

11:53 PM

[ SmokeDetector | MS ] Potentially bad keyword in body (1): How to remove nodes based on duplicate attributes on a xml? by Steven on stackoverflow.com

[ SmokeDetector | MS ] Bad keyword with email in body (64): Intermittent errors: java.io.IOException: Failed to advance reader of source: BigtableSource{config=BigtableConfig{projectId= by Katie Lee on stackoverflow.com

Transcript for