Root Access

Boris_yo

2:05 PM

After recent Chrome update I see Google Docs, Sheets and Slides in extensions. Why would I need them?

How they are different from online versions?

I am doing extensions cleanup.

Burgi

they let you work on those documents when you are offline

Boris_yo

@Burgi Then why did it install "Google Docs Offline" extension?

Is it enough to work offline?

Burgi

i don't know

Oliver Salzburg

@HackToHell How about views?

HackToHell

@OliverSalzburg The data will be heavily read, I figured I would go for materialistic views but even that will suffer from old data

So I think I'll add a trigger that pushes to the aggregate table everytime a new order comes in

hashrocket.com/blog/posts/…

That's an excellent note on that

Oliver Salzburg

2:15 PM

@HackToHell If you're getting outdated data with a view, you're doing something wrong that won't be solved by triggers

I've never worked with materialized views though. So, maybe I'm just missing something about that

HackToHell

@OliverSalzburg Normal views will be too slow for our use case, hence I figured I'll use this postgresql.org/docs/9.3/static/rules-materializedviews.html

Oliver Salzburg

@HackToHell Too slow, wow

HackToHell

But that has the old data problem :( and it doesn't refresh just the new entries

Oliver Salzburg

Okay, but I doubt that doing it manually with a trigger would be faster

But if you go down that road, please let me know about the outcome :)

HackToHell

@OliverSalzburg thing will have ~1-2 million rows

Oliver Salzburg

2:18 PM

Oh, I see

HackToHell

haven't deployed it yet, but I filled it up with junk data and it was slow

Need to drive a dashboard from it

@OliverSalzburg sure I will

Maybe we could push off old data to redshift and deal with low volume

Damn I'll need to build multiple variations and check speed

Oliver Salzburg

We have a data management process through which we request all our data. That process will pull from Postgres and store results in Redis. We invalidate our Redis caches based on Postgres triggers and invalidate previous results based on pre-defined rule sets

That works great for us, but we're also dealing with far less data

But getting anything but the absolute latest data is essential for us, so I know the pain

HackToHell

Yeah the dash must have the new entries as soon as it comes in and updates will be happen for ~3 weeks after ingest.

@OliverSalzburg nice how do you trigger the redis cache invalidate from postgres ?

Oliver Salzburg

@HackToHell Just the regular Postgres LISTEN pubsub thing

We have triggers on all tables, for insert, update and delete

allquixotic

Excerpt from February Stardock newsletter:

> Handles: Your oldest enemy
If your computer is starting to run slowly, before rebooting it try checking for how many handles a given program is using.

To do this, bring up task manager (ctrl-shift-tab), go to Details and then add the Handles column. Anything over 10,000 handles should give you pause. The more handles a program uses, the slower it will make your PC no matter how much memory or how fast your CPU is.

Burgi

2:27 PM

lol!

allquixotic

sounds like Brad Wardell had trouble with Team Foundation Server

I wonder how many handles total is too much for the kernel? I have close to 100k open but any individual process is using less than 10k except for a svchost which is using exactly 10341

HackToHell

@OliverSalzburg cool

Journeyman Geek

Isn't handles referring to file system?

Oliver Salzburg

@HackToHell The biggest challenge was the rule sets that define which changes invalidate which caches and the performance problem that comes with regenerating the caches.

HackToHell

These live dashboards just mean a hell lot of problems man

Especially when there's a lot of data

DavidPostill

2:36 PM

@JourneymanGeek No.

16

A: What is a Process Handle?

A process handle is an integer value that identifies a process to Windows. The Win32 API calls them a HANDLE; handles to windows are called HWND and handles to modules HMODULE. Threads inside processes have a thread handle, and files and other resources (such as registry keys) have handles also...

HackToHell

@OliverSalzburg How much computes do you do ?

Journeyman Geek

ah.

DavidPostill

> The handle count you see in Task Manager is "the number of object handles in the process's object table". In effect, this is the sum of all handles that this process has open.

Oliver Salzburg

Well, for us this isn't like a dashboard, it's the core business data ;D

@HackToHell Well, we haven't launched into production yet ;D Ask me again in a month or two

HackToHell

Same thing here :D

Bob

2:38 PM

@allquixotic In the olden days you'd run out of kernel nonpaged pool

had a Server 2003 machine go down cause the backup (!!) software had a ton of handles open... it had a leak

Oliver Salzburg

@HackToHell We just started using CloudWatch more heavily to monitor this

Bob

blogs.technet.microsoft.com/askpfeplat/2014/03/09/…

Oliver Salzburg

As you can see, the overall load on the system is near 0

Bob

Think I went through that to troubleshoot :P

DavidPostill

Pushing the Limits of Windows: Handles

64 bit system

HackToHell

2:41 PM

@OliverSalzburg nice! yet to figure out a monitoring for this. Plan is to have this run in kubernetes and it's just another head ache. Might end up using prometheus.io or stackdriver.

DavidPostill

> The result doesn’t represent the total number of handles a process can create, however, because system DLLs open various objects during process initialization. You see a process’s total handle count by adding a handle count column to Task Manager or Process Explorer. The total shown for Testlimit in this case is 16,711,680:

Oliver Salzburg

@HackToHell We're running on AWS ECS. Some of the stuff in CloudWatch are custom metrics which we push from our application

DavidPostill

> In one of the rare cases where Windows sets a hard-coded upper limit on a resource, the Executive defines 16,777,216 (16*1024*1024) as the maximum number of handles a process can allocate.

Journeyman Geek

....

DavidPostill

@allquixotic ^^^

Journeyman Geek

2:43 PM

I just realised chat accounts has an about field

HackToHell

@OliverSalzburg cool, we are making ours cloud agnostic. Depends on the client on where it's deployed.

Oliver Salzburg

I see

HackToHell

Long way from it though

About a month's time would be proper

Thomas Ward

wow two SU mods heh

Oliver Salzburg

I can't wait to get this thing on the road. This last transformation has been in the works for like a year now

First field test starts on Friday

HackToHell

2:53 PM

@OliverSalzburg whoa that huge a product ? All the best !

Thomas Ward

@JourneymanGeek I'mma steal you to AUGR briefly.

Burgi

three mods in RA!

has something been flagged?

HackToHell

so who got flagged?

Thomas Ward

no, i'm just borrowing an SU mod for something :)

Oliver Salzburg

@HackToHell We used to set up a server for each client and event. Now we have one platform to rule them all ;D

Also, thanks :)

Burgi

2:54 PM

@ThomasWard will you put him back afterwards?

Thomas Ward

@Burgi perhaps.

Burgi

hmmm

Thomas Ward

@OliverSalzburg i could ask you the same question, since @JourneymanGeek might be away, mind if I ask you guys if you want a specific question or not on your side / if it would fit better here at SU?

only a little Ubuntu, mostly VBox-on-Win10 NAT config question

ooop Journeyman beat you :)

HackToHell

@OliverSalzburg nice, god platform ftw

Oliver Salzburg

@ThomasWard Sure, go ahead

Journeyman Geek

2:56 PM

@HackToHell I don't count

I'm ~~part of~~ under the furniture ;p

DavidPostill

Hmm. Anybody understand this?

-4

Q: I don't get the point of this place

I'm asking a Q. ~25 of responses are how bad what I offer. In 99% no one even cares about what I ask. 99.99% of Qs I see, are either auto voted or people who also where threw away by automated robots. No one reads what you write guys. Why now one cares? I don't to talk to a robot, if I would I ...

discussion

Thomas Ward

@OliverSalzburg @JourneymanGeek beat you to the "Sure we'll take it" over in Ask Ubuntu General Room, where I dark-magic poofed him to briefly, so it's migrated now :)

thanks though :)

Journeyman Geek

@DavidPostill spelling's too good to be drunk.

Troll?

DavidPostill

Maybe.

@JourneymanGeek He's a Java Dev at Intel so you would think he could write a clearer question :)

Journeyman Geek

@DavidPostill or so he claims

DavidPostill

3:02 PM

@JourneymanGeek He's upset about this stackoverflow.com/questions/42249284/…

Journeyman Geek

ah

HackToHell

@JourneymanGeek shows some bone

Burgi

would it be worth having a hindi language version of SO like the Portuguese one?

Journeyman Geek

@Burgi eh. Maybe

Boris_yo

GoPro - So that's how they made FPS!

Normal day in Russia (1st person version).

►

Journeyman Geek

3:08 PM

I'd feel really sorry for the CM/mod who is running the place though

DavidPostill

@Burgi Are you serious?

Journeyman Geek

I don't quite grok the non english SOs too

Burgi

@DavidPostill iirc there was a recent blog saying india provided the 2nd most traffic to SO

Journeyman Geek

@Burgi most indians speak something at least a little similar to english tho

Bob

@JourneymanGeek lol

Journeyman Geek

3:11 PM

actually that's not really fair

DavidPostill

@Burgi It would rapidly be overrun by Microsoft Support and blog spammers ...

Journeyman Geek

Most of our indian regulars are fine...

@DavidPostill the same filters we use would catch em

Burgi

i was mostly thinking about the language barrier issue

Bob

@JourneymanGeek Regulars, yea. But... I think I've commented before on the tendency to request/provide code-only answers.

Journeyman Geek

I'm more worried about the bags of meat

@Burgi also, a good chunk of indians don't speak hindi natively

Bob

3:12 PM

There's a certain "get the thing done and screw learning/understanding" thing going on :\

Journeyman Geek

(actually I don't think most of the regulars do. HackToHell, jokerdino and I speak tamil. I'm pretty sure sathya speaks something else southern mainly but I can't remember)

Burgi

@JourneymanGeek wiki said it was the official language which is why i picked that one

Bob

Hm. Actually. Might be good if that's isolated on a site explicitly catering for it?

DavidPostill

@JourneymanGeek And if they don't Smokey is now down to 15s to deletion. We had permission from Pops to autoflag 3 times on each spam :)

Bob

@Burgi "official"

Journeyman Geek

3:13 PM

@DavidPostill shakes paw

@DavidPostill smokey gets to most spam before I can click on it

@DavidPostill at this point I consider smokey a "standard" anti spam tool

sorry for all the @ ts ;p

@Burgi only cause of a quirk of history

Thomas Ward

:P

Journeyman Geek

List of languages by number of native speakers in India

India is home to several hundred languages. Most Indians speak a language belonging to the families of the Indo-Aryan branch of Indo-European (c. 74%), the Dravidian (c. 24%), the Austroasiatic (Munda) (c. 1.2%), or the Sino-Tibetan (c. 0.6%), with some languages of the Himalayas still unclassified. The SIL Ethnologue lists 415 living languages for India. == Overview == India has 23 constitutionally recognized official languages. Hindi and English are the official languages used by the Central Government. State governments use respective official languages. Hindi is the most widely spoken language...

> Hindi is the most widely spoken language in northern parts of India.

Burgi

41%!

the largest language by a country mile

Journeyman Geek

Only cause they lump together a load of local dialects

DavidPostill

@JourneymanGeek Guess when we got the approval?

Journeyman Geek

3:19 PM

@DavidPostill very recently?

DavidPostill

Journeyman Geek

I heard mentions of it in places

DavidPostill

@JourneymanGeek Have a bone :)

Journeyman Geek

At this point I'm going to have a large pile of em

stalks a wheel of cheese instead

Burgi

btw my suggestion came from the fact i review loads of first posts that appear to be from the sub-continent area and the one thing they have in common is terrible english (sometimes to the point the question is just nonsense) and i wonder if they would have better luck posting in their first language.

that is also further backed up by that guy on MSE...

Bob

3:20 PM

@JourneymanGeek careful there, those are dangerous!

Cooper's Hill Cheese-Rolling and Wake

The Cooper's Hill Cheese-Rolling and Wake is an annual event held on the Spring Bank Holiday at Cooper's Hill, near Gloucester in England. It is traditionally done by and for the people who live in the local village of Brockworth, but now people from all over the world take part. The Guardian called it a "world-famous event", and indeed, in 2013, a 27-year-old American man and a 39-year-old Japanese man each won one of the four races. The event takes its name from the hill on which it occurs. The event is traditional. Until recent years, it was managed in a quasi-official manner, but since 2010...

Thomas Ward

wat

Journeyman Geek

@Burgi which guy? ;p

DavidPostill

@Bob I was just about to post that ;)

Bob

> Cooper's Hill Cheese Rolling has been summarised as "twenty young men chasing a cheese off a cliff and tumbling 200 yards to the bottom, where they are scraped up by paramedics and packed off to hospital."

Burgi

they banned that a few years ago after someone fell and broke their neck

Journeyman Geek

3:21 PM

@Bob I said stalk, not chase. ;p

Burgi

@JourneymanGeek this one: meta.stackexchange.com/questions/291075/…

Journeyman Geek

@Burgi I think he's east european

@Burgi I've been to india. Its entirely likely they're just as bad in their first language

Burgi

it was just a suggestion and idle curiosity, offence was not intended or implied

Journeyman Geek

and there's the possibility the ones you see are bottom of the barrel

DavidPostill

@JourneymanGeek He's Russian. Living in Israel. linkedin.com/in/vitalipom

I'm one link away from him on LinkedIn ...

Journeyman Geek

3:25 PM

ah

Burgi

ok i made an incorrect connection but my suggestion still stands

Journeyman Geek

@Burgi the issue I see is english is still the language of IT in india

the customers are american or british or singaporean

or wherever

its not like russia or china

(portugese... baffles me a bit)

DavidPostill

@Burgi Hmm. His LinkedIn profile says "English Native or bilingual proficiency"

That Brazilian Guy

@JourneymanGeek What do you mean? The language itself or the existence of so.pt?

Journeyman Geek

@ThatBrazilianGuy the latter

unless there's a ton of development in the language

I mean, isn't the big ~~spanish~~ Portuguese speaking place your neck of the woods? portugal is rather small

That Brazilian Guy

3:37 PM

@JourneymanGeek I think it was once mentioned brazilians are the 2nd most active community in SO, or the most something

Journeyman Geek

ah

then it makes sense

lots of localised software?

That Brazilian Guy

We have a rather... extensive history of ~~blossoming like the plague~~ being attracted and active in online communities

Journeyman Geek

ah

lol

That Brazilian Guy

And not confirming to the rules and speking our own language and complaining of the original communities and mods

Journeyman Geek

ah

@ThatBrazilianGuy funny thing is?

Some indian folk do that

That Brazilian Guy

3:39 PM

Originally orkut was an english-only social network, then suddenly BRAZILIANS EVERYWHERE

Yeah, Brazilians are the Indians of South America.

And, from what I head, Italians are the Brazilians of Europe

Journeyman Geek

s/indians/desis

gets flagged for being racist

That Brazilian Guy

The rampant corruption and... Well... This:

Italy vs Europe

►

You can pretty much sed s/italy/brazil/g

CaffeineAddiction

I have a feeling Americans do this too ... but when we join a community in mass ... its called progress

double standard much?

That Brazilian Guy

OH GOD THE BUS ONE!!!!! THAT'S BRAZIL!!!!!!!

Journeyman Geek

@CaffeineAddiction you lot tend to start communities too

and you're actually pretty good at it

That Brazilian Guy

3:45 PM

OH GOD THE BUREAUCRACY PART @ 2:57

I'M LAUGHING WITH SADNESSSSSSS

Journeyman Geek

oh

allquixotic

@Bob didn't you have a handle leak on your system recently?

That Brazilian Guy

@JourneymanGeek What's his lot?

Journeyman Geek

americans I assume

he said we

allquixotic

> HUAHUE

Is that pronounced like "Huawei" the Chinese electronics firm?

That Brazilian Guy

3:56 PM

@JourneymanGeek Oh I missed that

HackToHell

Laser vs "1000 Degree" Sharp Metal Used for Cutting

►

This guy is crazy

That Brazilian Guy

@allquixotic No idea, no one laughs like that.

There's even worse, some people here "laugh online" like that:

> askpoapksadopakdpoadkapo

Or something like that

To me it sounds like someone having a stroke. Or a cat in a keyboard.

Journeyman Geek

or a cat having a stroke on a keyboard

allquixotic

That's speciesist! Any species having a stroke on a keyboard would do that.

hiss

licks lips Ggggggrrrrrrrrmmmmggmgmgmgmgmmmgggg.....

Journeyman Geek

@allquixotic almost any...

snails...

Burgi

4:08 PM

@JourneymanGeek the rest of the continent is spanish as well

Journeyman Geek

yup

Blog bot

How Do Students Use Stack Overflow?

David Robinson on February 15, 2017

Since Stack Overflow was founded, we've described it as "a question and answer site for professional and enthusiast programmers." It supports both experienced developers who code as part of their work, and people who are learning as part of a university curriculum.

Burgi

@JourneymanGeek snails prefer touchscreens

DavidPostill

@Burgi eeeew!

Boris_yo

4:25 PM

@Bob I can't think of reason why would sellers sell it internationally...

@bwDraco How do you identify spam follower?

Burgi

4:45 PM

@Blogbot what is the difference between "public and private universities"?

> Note that Australia had only 7 universities with at least 200 askers excluding questions tagged about sheep-dips

;)

bwDraco

@Boris_yo It was the first follower on my account. I try to vet every account that interacts with my account or content; followers get extra attention. In this case, it was blatant spam.

Remember that I come from a long history of spam-fighting right here on Stack Exchange, and I've dealt with my share of spam on Twitter.

9 hours ago, by bwDraco

So... my first post on Instagram is proving popular, but I got followed by this spammer: https://www.instagram.com/millionaire.luxury.dream/

instagram.com/p/BQg12RGhcXM

djsmiley2k

yesssssssssssssss

everything at work is broken

55 minutes late to lunch \o\

CaffeineAddiction

apparently not your internet though

djsmiley2k

\o/ \o/

;)

@Burgi you moved off those crappy hosts yet?

Rahul2001

5:01 PM

@bwDraco spammers follow all the time on insta, no big deal

Burgi

@djsmiley2k nope

Burgi

5:12 PM

wtf....

//   - Old Imperial English Sizes
case 'EN_ELEPHANT'

DavidPostill

@Burgi Ignoramus :)

It's a paper size: Elephant 28 × 23

Burgi

o.O

djsmiley2k

:O

Burgi

did you know that or did you google it?

DavidPostill

Paper measures & sizes

@Burgi I know everything :)

I googled it of course ;p

Double Elephant 26.5 x 40.0 in

djsmiley2k

5:26 PM

hah

just had alaugh about that at work

how weird.

Mokubai

Hola!

djsmiley2k

o/

DavidPostill

5:41 PM

\o (I'm left handed)

Burgi

how very sinister

home time

CausingUnderflowsEverywhere

Verbose mode: Enabled

It supports both experienced developers who code as part of their work, and people who are learning as part of a university curriculum.

whaaat no I dont have a university T.T

djsmiley2k

are you an experienced developer?

one thing i found it doesn't help with, is people new to programming

every question is deep

far too deep for me to comprehend

instantly put me off :/

Rahul2001

@CausingUnderflowsEverywhere what are we talking about here?

CausingUnderflowsEverywhere

6:08 PM

uhhhh

I dont know what to consider myself. i've always fascinated programming so it always came easily to me

I dont think the questions are too complex especially ones in a language I already looked at

Type a username (For example, John)

hmmmmmm what to pick the possibilites are endless until I encounter a buffer overflow

@Rahul2001 we are talking about that link with the pretty graph picture

djsmiley2k

2 hours ago, by Blog bot

How Do Students Use Stack Overflow?

David Robinson on February 15, 2017

Since Stack Overflow was founded, we've described it as "a question and answer site for professional and enthusiast programmers." It supports both experienced developers who code as part of their work, and people who are learning as part of a university curriculum.

This ^^

Rahul2001

6:25 PM

Ah, right

Burgi

i think you have misunderstood

they aren't saying you must have a university education

they are just providing data on a known demographic

Rahul2001

Damnit, last two days of grade 10... I'm going to miss these guys a lot

Burgi

@Rahul2001 its only february. what are you doing for the rest of the year?

Rahul2001

@Burgi exams in march. New academic session starts from April in India.

Hm, goodnight all

DavidPostill

6:42 PM

@Rahul2001 nn

CausingUnderflowsEverywhere

that guy says he doesnt support me because Im niether in uni or experienced

unless I am experienced

Burgi

@Rahul2001 so the school year runs April - March?

user4851164

hi

Burgi

in the UK its Sept - June

CausingUnderflowsEverywhere

I need a doc

Burgi

6:47 PM

right i am going to lie down for 20 mins to prevent my sinuses exploding out of my face

CausingUnderflowsEverywhere

is JMG sleeping because I need to tell him the reason I came on root access this morning

Burgi

@CausingUnderflowsEverywhere yes

CausingUnderflowsEverywhere

okay drink some extra warm lemonade with honey @Burgi !

Burgi

you can leave a message for him in the moderator chat room

CausingUnderflowsEverywhere

the reason was as I declared by turning verbose mode on.. was to echo the progress of my installation of an operating system! because I know how often you guys have seen that

Rahul2001

6:48 PM

@Burgi yep

CausingUnderflowsEverywhere

but then I felt restless so I decided not to

Burgi

@Rahul2001 BED

CausingUnderflowsEverywhere

what time is it for Rahul India huh? sounds like.....

nearing 10pm?

Burgi

or i'll tell your mum and she'll go nuclear on you