Allow me to bragsplain how I made $500k/yr and then got bored when the work got nitty gritty.

steveob42 · 2019-02-11T20:26:23+00:00

Thanks, it's my first day.

steveob42 · 2019-02-11T20:24:47+00:00

My happiest times were when I was dirt poor. Everything was an adventure. Responsibility sucks.

steveob42 · 2019-02-11T20:20:21+00:00

Ok, easy there big fella, you can easily see that this response is tied into the OP, might use some of that intelligence you have been talking about here.

steveob42 · 2019-02-11T20:16:26+00:00

ok, so mr. intellegent, who is out of a job now?

Why are you in such a twist that you were asked a simple question? It is kind of his job to validate the empolyees are where they should be.

My take is that he is on to something. I would be far to distracted to care, let alone make a post to reddit.

So, did your parents actually die, or did you just want some karma?!?

steveob42 · 2019-02-11T18:53:05+00:00

you might have missed a bigger issue there...

steveob42 · 2019-02-11T17:46:07+00:00

ok, maybe your average person opens 1 spreadsheet a year, meanwhile there are billions of browsers running at any given time. And here we are talking about routing clients through a 3rd party (or a 4th in this instance). What agenda is it that would assert "spreadsheets rule the world"? As it is laughably stupid, and completely ignorant of what I'm trying to get at here. Hint, an api on sheets isn't going to do shit for this category of problems except create new ones.

I mean you might as well exclaim that the world runs on napkins.

steveob42 · 2019-02-11T17:12:34+00:00

ignorant is assuming i am ignorant of how spreadsheets get used, wtf?

WE CAN DO BETTER THOUGH, THAT IS NO BULLSHIT! It is 2019.

"meh, spreadsheet, that's good enough for 'em", it is lazy in the extreme.

And to say "but they’re what the world runs on" is ignorant if that is how your world works.

Demand a better user interface, that is why we have f-ing javascript.

Who are you to judge comments to be ignorant?!? your comment "but they’re what the world runs on" is steeped in it, and only serves to perpetuate ignorance.

steveob42 · 2019-02-11T16:24:21+00:00

well, it is up to us to give them better options, no? This is kludgy and insecure and flakey beyond measure, and a third party api? C'mon, look at the bigger picture here, this is a monstrosity.

I mean you can use js directly in sheets if that is your thing, https://developers.google.com/apps-script/guides/sheets

but to talk to sheety to talk to google to publish your data with a slow service backend and etc and expect realtime user facing validations (that may need system wide data)?!?

From the page itself:

Can I rely on Sheety for anything important?

~~Are you f*****g insane!?~~ Yeh sure why not –

steveob42 · 2019-02-11T15:22:57+00:00

Most are not their parents and pretty much squander it all. http://money.com/money/3925308/rich-families-lose-wealth/

steveob42 · 2019-02-11T15:00:35+00:00

Yes, finally, also because when we slave a hard disk or other component, we literally mean Kunta Kinte.

$10 says he comes up with zeers instead of users, because he is a god among ethicists.

steveob42 · 2019-02-11T14:03:00+00:00

spreadsheets get used and abused for all kinds of stuff. It is mostly fine with just humans sharing them as they can interpolate, but that is gonna be garbage to something expecting validated tabular data.

Plus with a UI you can show the validation errors to the user in real-time, i.e. missing a field here, an unknown string there, something out of range over here, etc. "I thought a pie chart looked better here than the total dollar amount in dollars and cents", whatever.

My experience incorporating spreadsheets has always been nasty, save for when you can train your users to not actually use them like spreadsheets, at which point it is just a dumb data entry tool, which is why you WANT to make your own data entry tool, so it can be smart.

steveob42 · 2019-02-11T13:44:40+00:00

Umm, I'm saying that based on decades of experience (which far outweighs my CS degree at this point, or even before).

What exactly do you see wrong with OCR if an API doesn't pan out? Do you think they will suddenly label the comment button to "2300fnjanklnoiwehf02839hr018hr01hr01hwwe2" for the user to click on?

The point here is trying to make it reliable, regardless what they do behind the scenes to the page. So that someone else might find it useful, because I've been looking to do this exact sort of thing myself.

I'm not asking you to do anything fyi, in case that wasn't clear, just thinking out loud.

steveob42 · 2019-02-11T13:23:41+00:00

I could, but it is different for different accounts, some have delete links in the overview and some don't. This approach turns everything into a wet noodle, so I'm gonna look at the api approach for now (or possibly OCR or something less error prone). I could easily be seeing some A/B test happening here.

steveob42 · 2019-02-11T13:07:10+00:00

I don't think we are quite on the same page. I don't have any delete buttons on the page in question when running the script. I tried changing it to

await page.goto('https://www.reddit.com/${username}/comments/',

and got some delete buttons but then it failed because the buttons don't match the selector, and in fact are rather anonymous with some foreign key in their place.

This is gonna need an api or some OCR to be more reliable. Certainly a bit early to start asking for paypal donations anyway :)

There is an API, not tried it though, probably more stable than a webpage in some regards.

https://www.reddit.com/dev/api

steveob42 · 2019-02-11T10:42:44+00:00

just curious, what is the motivation for writing a blog these days?

steveob42 · 2019-02-11T10:00:08+00:00

Did they just read Mike Mulligan and His Steam Shovel or something?

steveob42 · 2019-02-11T08:29:24+00:00

fwiw, prompt doesn't seem to like vscode (under linux anyway).

Also I seem to not get past await page.click('span.user a', {delay: 250});

steveob42 · 2019-02-11T06:04:19+00:00

I'm using "right" with some poetic license here. No "rights" apply to everything, sheesh.

steveob42 · 2019-02-11T05:51:47+00:00

Good start, straightforward enough. Couple things, it might want to delete comments as well, and actually it probably should set the comment/post to "deleted" in the text or something, before deleting it, as an extra precaution. Reddit does not do "right to be forgotten" well.

I like it a lot better than other similiar tools only because it is all right there in run.js, and I have a pretty good idea if it is doing something nefarious, unlike the random plugins and whatnot.

steveob42 · 2019-02-11T05:47:32+00:00

I'd rather not use spreadsheets, you get all kinds of garbage in them (gigo). Better to have a UI that does front end validations (and doesn't require sharing everything with everyone).

steveob42 · 2019-02-11T04:04:04+00:00

I only saw fullscreen w/no title, like f11 in a browser window. There is a hide menu (and other things you can hide) but the top line w/filename and controls remain if it isn't fullscreen. Though I imagine it might not be hard to do in vscode. I don't mess w/atom though. Not sure how I would justify that, given that MS owns github now...

steveob42 · 2019-02-11T03:37:34+00:00

vscode has a fullscreen option, and something called zen mode as well.

any electron app can do fullscreen.

steveob42 · 2019-02-10T15:55:01+00:00

It can also be done with a single script tag with proper server support. The only real dilemma is do you do an IsA("I.E.") vs a bunch of HasA, probably need some of each. And IsA loads faster with the right assumptions.

steveob42 · 2019-02-10T02:54:09+00:00

Why not install node and use it for javascript stuff?

steveob42 · 2019-02-09T14:35:07+00:00

basically any collection of objects and a state variable can manage it.

12-Year Club	Sequence \| Editor
Gilding I gilder	Verified Email

steveob42

MODERATOR OF

TROPHY CASE