ot1-perplexing-regexing

[rugged owl]

Well, took 55 mins to run this query for 1 table. I have like 20 tables.

[high haven]

super rip

transactional systems

write-optimized

[rugged owl]

I posted it in #databases but I don't think there's really a solution.

[high haven]

unless you do something like a star schema

[rugged owl]

Literally just trying to pull null counts

[high haven]

and have fact and dimension tables

[foggy jungle]

welp I think I'm done with that whole shindig

[high haven]

read-optimized analytical systems could probably do it under 10 minutes, maybe even 5

depending on the way the data is modeled

maybe even 1

[rugged owl]

I'm an end user. Things just need to work duh

I'll need to refactor so I'm just doing 2 queries, not 1 + # of columns.

[high haven]

eh youre using presto

no idea how the sql engine for that works

could be anything

[rugged owl]

I have hive & presto

And I'm accessing via ODBC driver or HUE GUI

w/e the hell that means

[foggy jungle]

Robin complains when I nullify malicious webhooks before he gets a chance to look at them but is always busy playing Minecraft when I find them.

[rugged owl]

W/e, I'm on vacation next week so

[high haven]

i spy an aboo

[dense pewter]

does anyone known how to create a nitro token generator? i keep seeing these nitro boosting bots? or a video where i can watch and learn??

[rugged owl]

Had to look up aboo

[high haven]

pretty sure thats against discord tos

[dense pewter]

oh

but

its for uhhh

educational purposes

anyone know tho?

[high haven]

[rugged owl]

So is spamming that across multiple channels.

[dense pewter]

no

[high haven]

thats whats going on?

tsk tsk

[dense pewter]

its a bot/tokens that boosts a discord server

[foggy jungle]

Stop it.

[dense pewter]

?

js askin

[foggy jungle]

Most of my time is spent killing malware from these stupid token generators.

And it's definitely against terms of service, and this Discord's rules.

[dense pewter]

oh

[high haven]

oh wait ive never done this one

!rule 2

[royal lake]

Rules

2. Follow the Discord Community Guidelines and Terms Of Service.

[foggy jungle]

!rule 5

[royal lake]

Rules

5. Do not provide or request help on projects that may break laws, breach terms of services, or are malicious or inappropriate.

[dense pewter]

mb

[high haven]

oh man i have to get renters insurance

for this new place

hmm anyone heard of this one

https://www.lemonade.com/

[rugged owl]

Whenever I hear: "Forget everything you know about X", I walk the other way.

Just bundle it with the car insurance

[high haven]

"Forget everything."

Ok

[rugged owl]

Speaking of insurance, I realized the other day I've been trying to get a car since October.

[high haven]

oof

[rugged owl]

One dealer gave a quote that added 2k of extra BS.

[high haven]

bruh wtf

computers arent covered?

thats like the only thing i want covered

what am i freakin paying for

i dont got "jewelry and furs"

man insurance broken

[rugged owl]

Computers are probably a different category?

[high haven]

theyre not

theyre not covered

[rugged owl]

Wtf?

Is that from the lemonade site?

[high haven]

oh wait youre right

i just cant read

[rugged owl]

lol

Reminds me I probably should back up my data from my server.

Car prices rn are absurd. This is for a XSE camry at my nearest toyota dealership.

[high haven]

wild

think theyll go down in a few months?

[rugged owl]

At this point, I'm waiting till 2024

Not getting a camry though, looking at the Lexus (although still part of lexus/toyota). Still, production issues left and right.

[foggy jungle]

My moostang has probably appreciated in value

[rugged owl]

This was the quote I got.

[young shoal]

i passed a phone screen

[foggy jungle]

If you report market adjustments to Toyota they'll yoink the dealer's stock next cycle.

[rugged owl]

And this.

[foggy jungle]

mendatory

[young shoal]

tf is Nitro Air

[vale raven]

mendatory

[vale raven]

dammit

[foggy jungle]

it's nitrogen filled tires

[young shoal]

maybe they should mend their spelling

[vale raven]

Hi @foggy jungle

[young shoal]

what's the point of that

[vale raven]

How are you enjoying my OTN?

[rugged owl]

AND, they signed off the email with: "Have a blessed day!"

[foggy jungle]

Less sensitive to pressure changes due to temperature

[young shoal]

are you in a place where that matters 🤔. also, how does having nitrogen rather than air do anything

[rugged owl]

It's selling you air at a premium

[foggy jungle]

Patiently waiting for my weaponized-list-comp to come around

[foggy jungle]

It's kind of a big scam because the truth is it really doen't matter.

[young shoal]

that's dumb as fuck

[vale raven]

I wonder if as devops I can hijack the ordering

[rugged owl]

"GetNitrogen.org"

[high haven]

get out of here

700 dollar doc fee

[foggy jungle]

The pressure variance does change with a nitrogen/oxygen mix for tire filling, but it's not... anything remarkable.

[young shoal]

how?

[rugged owl]

Resistall & Apex protection are like paint protection & leather protection for 3 years

[high haven]

this is great

who made this

[rugged owl]

But only covers regular wear

[rugged owl]

Yea, it's more or less free money for the dealership

[foggy jungle]

Nitrogen effuses less rapidly and doesn't produce water vapor is the tl;dr of it.

[young shoal]

i see

[rugged owl]

Buying a car right now sucks. Majority of interiors are giant touch screens. I feel like a boomer.

[foggy jungle]

I like my car's interior.

Plenty of knobs and shit to fiddle with, nothing locked behind a touch screen that's inconvenient.

[young shoal]

microsoft teams is malware, on god

[rugged owl]

Yea, too bad Lexus went to the giant tablet route in 2023.

[vale raven]

Military surplus humvee?

[rugged owl]

And modern toyotas feel they are built cheap af.

[foggy jungle]

Might as well be.

stock image

[rugged owl]

How's that 10 MPG?

[vale raven]

ferrari???

[foggy jungle]

I got 26mpg on a 20 hour trip from NM to... where I am now.

[vale raven]

Some rich ahh syrup

be honest

[foggy jungle]

[vale raven]

What're you putting in the syrup?

[foggy jungle]

Mom the dog's drunk again.

[young shoal]

leaked

[young shoal]

the logo is right there lol

[vale raven]

(Is that not Ferrari? That's embarassing )

Mustang?

[young shoal]

actually leaked

oh, those are not yours

[foggy jungle]

Unironically leaked

They are mine.

[rugged owl]

Those are 2 different cars though?

[young shoal]

bruh?

[foggy jungle]

I sold the ST for the Mustang.

[rugged owl]

I don't like the new flat logo on cars now

[foggy jungle]

That ST made like 450 hp when the new owner dyno'd it

Basically rebuilt everything in that dumb engine bay

[rugged owl]

Like this just looks lazy af in terms of design

"oh shit, we forgot to add the logo"

[foggy jungle]

I debadge my cars as much as possible

I'd prefer it if they were flat so I can scrape it off.

[rugged owl]

Reminds me, I need to email another dealer for a quote.

[young shoal]

cars sound so stressful ngl

[rugged owl]

Well, it's mainly covid ffffed up everything. Before, it was buyers market. Now it's seller's market.

[young shoal]

gonna walk everywhere

[rugged owl]

[young shoal]

the interviewer last week said it'd take up to 2 weeks for a response but they responded in only 3 days lol

[rugged owl]

Small company? Or slow week.

[young shoal]

i'm just that exceptional~

uh, what's "mid size"?

well they're at 17k employees

[rugged owl]

Hmm, large enough. Guess you are exceptional

[young shoal]

definitely putting the "thank you for the quick response!"

i wasn't expecting anything for another week and a half lol

[high haven]

[young shoal]

hmm. this other company said they wanted to send offers by april, which is pretty soon..

[high haven]

i ended up doing this btw. thanks for the tip

hmm if everything works out

guess im moving this weekend

[young shoal]

oh?

[high haven]

welp

that was quicker than expected

[high haven]

yes.

25th

[young shoal]

where are you going

oh maybe not that personal

why are you going

oof

[high haven]

and why?

hmm

multiple reasons

[young shoal]

job?

visit robin?

[high haven]

ill still have the same job

bc its remote

||but if i need to look for a new one...||

theres also a lot of conferences/meetups down there

hoping to go to some more

[high haven]

honestly robin should just go to another state for college. can always come back later imo

[young shoal]

you can't just move the college lmao

[high haven]

transfer

come back for grad school or work

its whatever

[foggy jungle]

It's very nice for mental health to work with your hands on something productive. Similar mindset to coding.

When I had just moved and didn't really know anyone, tinkering with my car was my outlet.

[rugged owl]

Car has always been: "Wtf is going to break next" for me.

[foggy jungle]

It's nice to be able to fix shit yourself too

[rugged owl]

Oh, just get the null counts for these tables.
ME WHO HAS BEEN TRYING FOR THE PAST 3 HOURS TO AUTOMATE THIS SO I DON"T HAVE TO TYPE OUT 10000 COLUMN NAMES.

[young shoal]

that doesn't sound that hard

[rugged owl]

Idk if this 150 line query is even going to run

[high haven]

does whatever youre using not have a scheduler

honestly just ask chatgpt to optimize your query lol

[young shoal]

wtf

[high haven]

then laugh while it breaks

[rugged owl]

There's no way to optimize it

[high haven]

did you ever end up fetching the columns of each table?

[rugged owl]

SQL doesn't have something like df.info() that just aggregates stuff

[sly spire]

those are pretty common I think I’ve seen some well over 500 lines

[high haven]

having that should make it faster regardless of whatever sql engine its using

[high haven]

my coworker's sql queries

but tbf our data systems are a hot mess

theres like 14 linked databases or something

i dont remember

[rugged owl]

It's literally:
SELECT
sum(case when table.column1 is null then 1 else 0 end) column1_null_count,
count(table.column1) as not_nulls,
Repeat for 100 columns
FROM db.table

[high haven]

and like 3-5 are unlinked

[rugged owl]

I honestly wonder if it's faster just to pull the entire table

[high haven]

yeah and then process it afterwards

why dont you

[young shoal]

bruh?

[rugged owl]

SQL sucks, I hate SQL

[young shoal]

that would almost certainly be slower. the database is smarter than you

[high haven]

do not underestimate the power of the sql engine

[rugged owl]

[high haven]

[young shoal]

wait what are you trying to count? this looks overly complicated

[high haven]

is there not a count null function

[rugged owl]

"Oh yea, why don't I join a large company to work with SQL so I can get more experience. " - Me 1.6 years ago.

NO THERE IS NOT

[young shoal]

there's IS NULL

[rugged owl]

IS NULL is a filter

[young shoal]

well yeah, then you use COUNT

[high haven]

man what is this thing youre using lol

[rugged owl]

I need that on multipel columns

SELECT count(column1)
WHERE column1 IS NULL
FROM db.table
Would require a query for each column

Hmmm, this db has 4mill rows

[young shoal]

do you just need to find how many nulls there are for all columns for all rows?

[rugged owl]

Well, that's the start lol

[young shoal]

then what 😔

[rugged owl]

Well, this is EDA. So probably like top 5 common values of interesting columns, etc.

MY QUERY WORKED

[young shoal]

😤

[rugged owl]

150 line of sql here we go

lmao, it's a 1x300 matrix

[young shoal]

😔

column vector moment

[high haven]

congrats

[rugged owl]

Well, better get this done before this "Your computer is about to restart in X remaining time" resets me to the stone age.

[young shoal]

what is that, google chrome?

[rugged owl]

No, company IT bs.

[young shoal]

lmao

[rugged owl]

We automatically added/removed software, now we need to restart

[young shoal]

Thank you for the quick response!

I'm available for an interview on: 23 May from 9:00am to 10:00am and 1:00pm to 5:00pm, 24 May from 2:30pm to 4:30pm, 28 May from 9:00am to 10:30am, and 29 May from 9:00am to 10:30am.

If these times do not work, I would be happy to provide more times when I am available.

Sincerely,
what do we think about this one 😬

school schedule leaked 😳

[rugged owl]

I normally bullet point the times for easier reading

[young shoal]

good idea tbh

wait shit they previously said "Thanks for the quick response"

[rugged owl]

"You too"

Oh wait it's

[young shoal]

no like 3 emails ago

[rugged owl]

"Thanks, you too"

I'm just kidding lol (For the "you too", not bullet points)

[young shoal]

ugh. it's probably fine

[high haven]

yeah bullet points wouldve been nice

[rugged owl]

Yea, don't sweat it.

[high haven]

but its casual

[young shoal]

well i have bullets now

[high haven]

ayy

[young shoal]

definitely not my first choice for a summer internship, but it's something

[high haven]

i think its fine

youre still a freshman

once you already have an internship on your resume, itll be much easier to get more

[rugged owl]

Me as a freshman:

[high haven]

since youve proven to companies, you can show up at least lol

[young shoal]

that's what the fast food job is for 😤

[high haven]

well, show up in a corporate setting

[young shoal]

corporate schmorporate

[high haven]

oh wait

theres this one too

[young shoal]

what

[high haven]

just another emoji

[rugged owl]

That looks like potatoes

[high haven]

why would potatoes be colored

though

[rugged owl]

[high haven]

[young shoal]

potatoes aren't all the same color lol

i swear, getting emails absolutely kills my productivity. i need to bikeshed for like 30 minutes on how to respond

i haven't worked in like an hour from just 2 emails

[high haven]

30 minutes bruh

why you stressing

[rugged owl]

Because if you screw up you're ending up on twitter or something

[young shoal]

idfk? my email soft skills are not on point

[high haven]

isnt twitter dead now

or something

[young shoal]

also like, how do people usually set up grafana. i know pydis has theirs private, but how do they access it?

[high haven]

hmm i think as long as youre not rude then youre usually okay

[young shoal]

like, i currently just have it running in a container in the same network as the rest of my stuff

[rugged owl]

What's grafana

[young shoal]

it's for monitoring things

[high haven]

are you making your own monitoring dashboard

for your site

lmk. i am also wanting to learn how to be a devops

[young shoal]

well grafana basically lets you make dashboards. you link it with data sources and you can display the things

[high haven]

different or similar to datadog?

[thick osprey]

Grafana makes good dashboards.

[high haven]

[thick osprey]

Datadog is an entire monitoring solution. Grafana needs a database and aggregator behind it to work.

[high haven]

oh yeah? are they one of the best?

ah i see

makes sense

datadog can charge for that storage and whatnot

[thick osprey]

A common stack, I think, would be a telegraph agent recording metrics sent to a influxDB for storage/agg and displayed on a Grafana instance.

[high haven]

i see, i see

[thick osprey]

Though OpenTelemetry is the way to go if you can.

[young shoal]

i'm currently using prometheus

[thick osprey]

prometheus works too ifaik.

Just need someplace to shove all your time series.

[young shoal]

yeah, it's the grafana people's thing

just trying to figure out a good place to put grafana. i don't really want to ssh into my vps every time i want to see yk. i could put it as a subdomain for my site? but then i'd need authentication

[thick osprey]

Grafana should handle login/auth.

[young shoal]

yeah. but it looks annoying

[thick osprey]

Well, no debate there. haha

[young shoal]

maybe i just use their github oauth thing they have 🤔

[high haven]

[young shoal]

https://grafana.com/docs/grafana/latest/setup-grafana/configure-security/configure-authentication/github/

[thick osprey]

I'm slacking on setting up a RunDeck instance because I don't want to deal with authentication. haha

[young shoal]

what's rundeck

[thick osprey]

https://www.rundeck.com/ Run book automation.
An event listener than kicks off scripted actions.

[young shoal]

huh

[thick osprey]

I'm using it as an excuse to learn some more things I don't understand such as authentication. But it's an amazing tool for incident management, deployment, testing, and all sorts of things.

[young shoal]

so it's sort of like aws lambdas?

[thick osprey]

Sort of, if you think of the scripts as an ephemeral runner.

[high haven]

oh hey this kinda made it click for me

[young shoal]

i c i c

(not really, though)

[high haven]

[thick osprey]

More like... what is the AWS service... ummm....flow? box? one moment

[young shoal]

they're like uh... callbacks

[thick osprey]

AWS Step Functions

https://aws.amazon.com/getting-started/hands-on/create-a-serverless-workflow-step-functions-lambda/

These things are neat!

[high haven]

ah step functions

my friend is working with a team

thats using that as a sort of data orchestration tool

i think

honestly theres already so many of those lol

[thick osprey]

There are a lot of the same solutions because it's a good solution.

Script out what is done in a repeatable, low-code solution that can be kicked off automatically or by someone who doesn't code but does support.

I'll slow down... I just reached for my incident management soapbox

[young shoal]

lmao

[high haven]

hey

i dig it

[thick osprey]

The old joke is "turn it off and back on again". The truth is this actually fixes a good majority of technology incidents. Restart the service, or kick the box, or cycle the clusters, and so on.

script that shit so we don't need to wait on an incident call for 20 minutes just to have Jake log in and push a few console buttons.

Instead of having a call run for 20 minutes until we find the person with the keys to the box... automation goes

• I see a problem
• Attempting a service restart
• that fixed the problem
• alerting on-call with low urgency for awareness
• goodbye

[young shoal]

does kubernetes deal with secrets

[thick osprey]

Like environment secrets? Absolutely.

[high haven]

i think thats a good process for most things

[thick osprey]

That said: for clarity are you talking about run-time secrets or just environment setup secrets?

[thick osprey]

it shocks me how hard it is to sell this idea to the company I work with.

[high haven]

wdym

[young shoal]

setup. i need to have a client token for auth. honestly 🤔. i can just throw that in a .env and use them in the docker compose for the grafana container

[high haven]

like they just dont think thats a good idea or

[thick osprey]

They have all the objections and more to why it "just won't work for all cases". haha

[high haven]

lmao

[thick osprey]

Yeah, you'd feed it into the helm (?) at deployment.

[high haven]

why cant we just have 24/7 support for all cases

no matter their urgency

[young shoal]

that's called "on call" 😩

[thick osprey]

Until your on call mutes the alerts because they are burned out and fatigued. :(

[wraith hound]

doesn't half the cases, even, save time/money for the company?

[high haven]

alert fatigue

[young shoal]

just fire them, duh. get another one. human capital is replaceable yk

[thick osprey]

I have an entire power point with $$ values on how much we'd save. Loose example: We had an incident three months ago that lasted 40 minutes. It cost us, roughly, $16,000 in payroll and an estimated $1.4 million in revenue.

It was solved by restarting the service boxes in a staggered sequence. Automation could have done that in the first 5 minutes.

Rundeck (the solution I'm pushing for) would have been paid for at an enterprise license cost in one incident.

[young shoal]

rofl

[thick osprey]

[wraith hound]

what the

[high haven]

theres a "but" here

[wraith hound]

people are against this??

[thick osprey]

It's not that people are against it. It's getting people to support it. There is a subtle and devilish difference.

[young shoal]

16k is what, like 20 devs for a few hours?

[thick osprey]

I forget the count but it was a critical service that failed and we had several dozen on the call.

[wraith hound]

ah. fun.

[high haven]

🥴

[thick osprey]

I've been on Sev 0 calls with 200+ team members on the call all listening as we take servers out of rotation and put new one in at the F5 layer.

#WhatCost

[young shoal]

rofl

devoops moment

[thick osprey]

My favorite incidents are the ones I jump on that are low severity but sound bad. I join and get told "Yeah, the entire us-east-2 cluster is down. Don't worry, the routes automatically failed over to us-west-2, we're rebuilding, and validating tests should be done in an hour. Business felt maybe a minute of impact."

Teams doing it right

brings a tear to my eye.

So... Grafana 👀

@young shoal why not just use Grafana Cloud? Practice?

[young shoal]

doesn't that cost money

[thick osprey]

it happened to me, it can happen to you

[high haven]

aww i cant use the us-east-1 joke

[thick osprey]

If you are going to throw more than 10k metrics at them.

You can use Grafana Cloud to avoid installing, maintaining, and scaling your own instance of Grafana. Create a free account to get started, which includes free forever access to 10k metrics, 50GB logs, 50GB traces, 500VUh k6 testing & more.

[young shoal]

oh

[high haven]

oh hey

thats nice

[young shoal]

well

yeah it's for practice (😬)

[thick osprey]

Oh that's right, Grafana does traces now. Neat!

[high haven]

hey then you can put it on your resume

[thick osprey]

Figured. haha

[young shoal]

definitely knew i could use grafana cloud 👍

[thick osprey]

hahahaha pygen: "sqlite3 isn't for scale"

Grafana supports the following databases:

SQLite 3
MySQL 5.7+
PostgreSQL 10+

[young shoal]

well, more like sqlite isn't for apps where you need to do lots of concurrent writing

[thick osprey]

to be fair:

Note: SQLite works well if your environment is small, but is not recommended when your environment starts growing.

It is limited in how much it can grow.

[high haven]

which logs dont fall under right?

theyre pretty transactional

[young shoal]

well idk if you'd be putting logs in sqlite

[high haven]

lolol

im sure its been done

[young shoal]

i suppose you could

[thick osprey]

Having dev logs with metrics is so good. But you need tight control on those logs and the logging pattern. Devs will log the wildest things.

[high haven]

oh yeah?

[young shoal]

i currently only have metrics for how many people are visiting the site

[thick osprey]

For sure. I've seen info level logs that just include the entire trace stack. Just all of it.

1.2 meg log line? Yeah, I've seen that too.

[young shoal]

😩

[thick osprey]

client ppi and pifi in logs? Sure, why not right?

[high haven]

my brain broke a bit imagining the storage of all this

[thick osprey]

oh... oh ....

[high haven]

[young shoal]

hey that's cool. grafana censors secrets when logging

[tardy rain]

But have you ever seen production logs that only log "Request received" and "Response sent"?

[high haven]

lol

[tardy rain]

Welcome to my sprint

[high haven]

so helpful

[young shoal]

mariosis outsource your job to me. i'll work for 15/hr

[high haven]

not even http status codes

[thick osprey]

I think someone mentioned 1-2Tb of data storage. I've seen the ingest rates of the security logs collected where I work. One server (of five) does that in an hour or less.

[tardy rain]

I tried to add logging and force push to skip code review and shit like that, it wasnt built

Turns out last successful build was 3 years ago

[high haven]

bruh. and let me guess it isnt cold storage either...

[tardy rain]

Welcome to my sprint

[thick osprey]

I don't know where it goes. I know the cost of the splunk contract we have though. Makes things I want the company to buy an easy purchase, honestly.

[tardy rain]

I make 23

[young shoal]

oh

what's your COL

[thick osprey]

2023-03-06 15:34:27.32866 - INFO - Here :)

[tardy rain]

Dont ask sad questions

[young shoal]

tbh i'd do dev work for min wage

[tardy rain]

I would tell you the cost of a dozen eggs but i havent seen eggs in ages

[thick osprey]

booo. Don't cheapen the craft.

[high haven]

youre about to get an internship lmao

[young shoal]

well if it was livable, i mean. it's less than half what i make at chipotle, lol

[foggy jungle]

[young shoal]

well, you jinxed it

[high haven]

did i though

[young shoal]

indeed

[thick osprey]

Having jumped from retail making a whooping 10.45 an hour to an internship in technology at a staggering 15.00 an hour... I feel you there.

[young shoal]

retail sounds so bad. i know it's like the fast food calling the retail black but, it really does sound terrible

[high haven]

[thick osprey]

10.45 an hour, six year team member/trainer/leader btw.

[foggy jungle]

They've started leaving me messages in their packages

[thick osprey]

My fallback if technology ever fails me is a barista at Starbucks if that tells you anything about my opinion of working in a retail store again.

[young shoal]

hey at least i know how to fold a burrito

[foggy jungle]

I know someone else in this server that was a barista at one point, I wonder if they have similar plans.

[young shoal]

stelercus

[foggy jungle]

How do all you people know this?

[young shoal]

i talked to him lol

[thick osprey]

Y'all in food services and retail will and are able to work freaking circles around technology teams. You will literally scare them if you bring your average day work mentality from service jobs with you.

They will be frightened at your drive and inability to just stop.

[high haven]

you use any canary tokens for your email? just curious

[high haven]

💀

[rugged owl]

Retail depends. Walmart would absolutely suck.

[young shoal]

😔 just gotta focus on the current bowl. then the next. then the next 😔. eventually the people go away 😔

[thick osprey]

25 year retail professional here. I know my view is jaded. I've held more than 22 jobs and seen the behind-the-scenes of more than a hundred retail stores. Retail sucks.

[foggy jungle]

Ouf.

I have utmost respect for fast food/retail workers, I did 2 weeks at Burger King and quit, couldn't do it.
Would rather do another 8 year enlistment.

[high haven]

psvm when you use emojis like this. it always reminds me of bing chat ngl

[rugged owl]

I meant more of comparing retail to like, grocery store cashier or starbucks etc.

[young shoal]

tf

[young shoal]

😔

[thick osprey]

I'm not being silly when I say that line. You put someone who did work in retail (not just showing up but a worker) into a technology world and you literally cause discomfort because you work.

[high haven]

sorry. you havent seen bing chat have you?

[young shoal]

no lol

[high haven]

you dont want to lol

[rugged owl]

Bing chat is better

[young shoal]

i think chipotle is supposed to be like, slightly higher quality than fast food

it definitely costs way more

[rugged owl]

I worked a year ish in retail during my university days. Def learned some lessons there.

[thick osprey]

100%. The common tune is "unskilled jobs" but heck that noise! You learn a lot and it takes a lot to do it.

[young shoal]

eh. a monkey could do my job

[thick osprey]

Strangely though.... I don't see them training monkeys to do it.

[thick osprey]

Funny.

[young shoal]

would be animal abuse

[rugged owl]

More like, don't say anything to the manager. And how much they drag their feet on a 50 cent raise.

[thick osprey]

[young shoal]

why is it so zoomed in

[thick osprey]

I forget why I made these...

[young shoal]

huh

[rugged owl]

Finally relevant

[young shoal]

😔

[grave cove]

damn Ben got destroyed

[young shoal]

is rex ben

[high haven]

you havent seen this either? oh man you missed the good stuff

[gritty zinc]

not as good as the "You have not been a good user. I have been a good Bing." one

[thick osprey]

Honestly though. A monkey would have a difficult time dealing with all of the things you handle in a shift that are easy to overlook. Task management, time management, communication, adaptation, improvisation, just to name a few.

[high haven]

you forgot the emoji

[rugged owl]

Yea but, you don't have to pay a monkey.

[gritty zinc]

how much sleep deprivation does it take to make a human equivalent to a monkey at that? 🥴

[gritty zinc]

they give them a cracked coconut per bunch of coconuts, iirc
since they can't crack coconuts themselves

[young shoal]

probably only like, 30ish hours

[young shoal]

well yeah. i wasn't actually being literal

[high haven]

this is why microsoft shut this down

[rugged owl]

How do I get out of full screen mode in vs code, wtf

[thick osprey]

A significant amount, staring around the pre-K schooling period and slowly ramped up into the post-high school period. Combined with social pressures of success defined by material possessions with a market of late stage capitalism powering it all.

[high haven]

you still working huh?

[thick osprey]

oops... bit much there.

[young shoal]

nvim

[rugged owl]

no, I hit like f11 or some bs button

now I"m stuck with this stupid yellow line too

I think it's the debugger thing. urgh

[thick osprey]

ctrl-k then z ?

Are you in zen mode?

[young shoal]

great ui design grafana

[high haven]

oh yeah zen mode is neat

i honestly like that feature

[thick osprey]

I used it all the time until I finally just switched to vim. haha

[rugged owl]

I think it' sjust full screen mode

[high haven]

[grave cove]

Wild

[rugged owl]

wait, it might be zen mode? f11?

[high haven]

i would show you the first half but its even more inappropriate i think lol

[rugged owl]

ctrl k then z did nothing

[young shoal]

preeeooocts. how do i disable username and password auth in grafana. i only want github oauth to be possible

[high haven]

try all the buttons lol

[rugged owl]

WELL, ctrl K then Z zoomed it in even more

now I lost the side bar

[high haven]

💀💀

[rugged owl]

BRUH

[vale raven]

Someone said Grafana? What oops is going on here?

[high haven]

just shut down the whole thing

lol

[young shoal]

my blog

[rugged owl]

I don't want to force quit vs code, I have like 10 windows open

NOOOOOOOOOOOOO

[high haven]

didnt you save?

rip

[rugged owl]

Oh, i'm back to where I was

[high haven]

woo

[rugged owl]

no like, the problem before I got stuck even further...

[gritty zinc]

here's the full version, also paging @grave cove

[high haven]

oh yeah i have that one

[rugged owl]

https://www.youtube.com/watch?v=E6mfJZWRVIo this to the rescue. Jesus this is cancer.

[high haven]

but the emoji at the end gives it the extra oomph

yknow?

🙂

[gritty zinc]

that was caused by a question about avatar 2 btw

[young shoal]

oof

what no testing does to a megacorp

[gritty zinc]

bing has an identity crisis:

[grave cove]

Lmao

[young shoal]

i think i just caused a mutual recursion between my nginx and grafana. lol

they redirected to each other for some reason

[high haven]

haha yeah the verge released some great ones too in an article they did

[young shoal]

hm. now someone is spamming my vps with requests for /.env

[gritty zinc]

i wouldn't have read that

[high haven]

i dont usually read articles like that either but i listen to the vergecast

and ofc they covered when bing was imploding lol

[young shoal]

blog-blog-1        | [2023-03-21T22:53:41Z ERROR _] No matching routes for GET /.env.
blog-nginx-1       | 169.150.236.163 - - [21/Mar/2023:22:53:41 +0000] "GET /.env HTTP/1.1" 404 383 "-" "python-requests/2.28.2"
```😔

[rugged owl]

Oh no, the request is coming from inside the house! Dun dun DUNNNNN!!

[young shoal]

ddos that IP (in minecraft)

[high haven]

bruh what are they doing

[young shoal]

i assume this actually works. i guess people have a file server that just mounts the project root or something, including .envs

[gritty zinc]

oh and there was also this one 😈

[young shoal]

were you aware lettuce is a member of the sunflower family

[high haven]

i think theres a name for that type of attack too. we covered it in my cybersec class but ive already forgotten

syru would probably know

[young shoal]

@foggy jungle 🥞 🥺

[foggy jungle]

Wat

[high haven]

jk

[rugged owl]

K, my query is now running. It'll be tomorrow's problem

[high haven]

[high haven]

noice

[foggy jungle]

I don't think there's a name for directory enumeration tbh. The attack would be based on what you actually do in the terminal.
You can do something like XSS (Cross-site Scripting) but that's more remote access if it's trying to manipulate or spawn a Python terminal.

[high haven]

i see

[gritty zinc]

what was the site that allowed one to look at a pypi package without downloading it?

[foggy jungle]

https://owasp.org/www-project-top-ten/

[foggy jungle]

https://inspector.pypi.io/

[gritty zinc]

ah, I remembered "explorer", thanks

[foggy jungle]

I live on that website now lol

[high haven]

oh interesting

[foggy jungle]

If you find some fishy code, send it to me

[gritty zinc]

lol, for a completely innoculous package, https://pypi.org/project/tasksio/ almost couldn't be more suspicious

[foggy jungle]

Oh I looked at that one earlier, and chuckled as well.

oop found one

[young shoal]

i got oath working it seems

@vale raven can i disable the admin account in grafana. or change the password

oh i found it

nevermind~

[vale raven]

Oh good because I don't actually have any idea

[young shoal]

lol

https://grafana.com/docs/grafana/latest/setup-grafana/configure-grafana/#security it's like the second field

[gritty zinc]

wow, just found a really interesting plot about gpt-4

[young shoal]

oof

[gritty zinc]

gpt-4 before RLHF is actually really, really well calibrated. Its estimate of how likely a certain answer is closely matches how accurate it actually is.

Until RLHF is done at it, at which point it becomes tainted by human examiners' intuitive (and really bad) understanding of probability, and gets that plateau.

this plateau mostly results in it being too confident (below diagonal line) in answers it is actually pretty unsure about

[high haven]

interesting

on the other hand

[rugged owl]

something something, spotify random isn't actually random because people suck at noticing actual randomness.

[high haven]

i only have a meme about data engineering

inevitable acceptance

[rugged owl]

Someone from some team emailed me to check tables to make sure the model scores are the same...

[high haven]

it can wait

[rugged owl]

Idk why tf my name ended up being the main point of contact.

[high haven]

👏

until tomorrow

👏

[high haven]

wdym you are the human data dictionary now

[rugged owl]

It can wait until the next version of the model is in production.

[high haven]

[rugged owl]

Open resume intensifies
Open linkedin job tab intensifies

nvm,

[high haven]

oh hey i saw that one. then i skipped over it

eww sap

[tardy rain]

SAP
declined

[high haven]

get out of here

haha mar we the same bro

[young shoal]

I interviewed at SAP for their STAR program

[tardy rain]

Lmao

You'd be a SAP star

[high haven]

bc you know if they have SAP theyll want you to ETL data out of it so its actually useful

[young shoal]

what's etl

[rugged owl]

Me who's no idea SAP even is

[young shoal]

they're business analytics

[rugged owl]

EXTRACT, TRANSFORM, Loooooooooad

[high haven]

data term. what sky said with less emotion lol

[tardy rain]

Sucks Ass, Probably

[high haven]

most probably

imagine insurance data

then imagine health insurance data

[tardy rain]

I heard salesforce is worse

[high haven]

bro dont even start with SF

[rugged owl]

Imagine garbage

[high haven]

they have a whole division trying to wrangle stuff from SF

its called "metering" on that side of the business

are you overcharged? probably

are you undercharged? also probably

thats the reality

[foggy jungle]

ARE WE WRANGLING

[high haven]

you know it

[tardy rain]

🤠

Need a :sadyeehaw: emoji

[rugged owl]

[tardy rain]

Lol i must be in a rich part of town

There is such a thing as a salesforce dev

But also a dev at Salesforce, wonder which one is worse

At SF you could get to work on slack, so thats a plus i imagine

[thick osprey]

oops. Well.... alert triggers work.

[foggy jungle]

Neat

[high haven]

oh one of my friends was one of those "salesforce devs"

he said it was god awful

they have a platform on SF and you "can build apps" on there

[tardy rain]

Yea can imagine

What about the other kind

We dont use slack at qork

Work

Everyone's singing praises about it

[foggy jungle]

qork

[high haven]

hmm dunno

also havent heard too much about it from podcasts

oh wait

[foggy jungle]

I like Slack 🤷‍♂️

[high haven]

on the finops podcast i listen to

slack is one of the few companies

[foggy jungle]

Frankly any real time communication service is decently useful so long as it doesn't become a task distribution center.

[high haven]

where being multicloud makes sense

it is also a nightmare to finagle lol

[foggy jungle]

I'd rather pop open Teams and hit someone with a question than call them. That way they can get to it when they need to.

People tend to respond faster if you respect their time too.

[high haven]

but i hate teams though

slack is better

but i feel you

[young shoal]

teams is dog shit

[foggy jungle]

I mean Teams as a software is awful, but Teams as a concept of just live communication is fine.

[high haven]

yeah you just gotta respects peoples time

[foggy jungle]

I had most of my workflow automated through Teams/Sharepoint

[high haven]

if only others would also respect your time

🙃

[foggy jungle]

I just won't answer my phone if I'm working on something.

I'm used to having my own office, where a closed door meant literally do not walk in this office or I will end you.

[high haven]

[thick osprey]

That's what I dig about remote work. I can walk away from my desk and not be immediately shoulder tapped into a side hustle.

[foggy jungle]

I dream of remote work someday.

[clever lichen]

How clean is the Photoshop on that?

(dog picture is what was added)

[foggy jungle]

I don't think the reflection is correct. And the saturation is too high on the picture.

[clever lichen]

Like the distance?

[foggy jungle]

the lines you see here aren't just from the bottom holes.

[clever lichen]

Actually those are part of the original image

[foggy jungle]

The picture occludes some of those holes.

[clever lichen]

So those are authentic

Oh

I misunderstood sorry

I don't speak a second language unless you count stupid.

[foggy jungle]

I'm fluent in stupid, don't worry.

[clever lichen]

Actually it doesn't, that just the backboard being screwed/camera glitch

[foggy jungle]

I don't... think we're on the same page here. The reflection from those lines is actually a result of the light passing through the holes on the back of the toolbox.

Some of those lines would disappear if you placed an actual picture there.

[clever lichen]

Oh

I'm dumb, how should I fix it?

Don't make me resort to gpt4 lmao

[foggy jungle]

Buhh. Is that your actual toolbox?

[clever lichen]

Not atm

Going to buy a triple bank soon

Was thinking of this one though

But it was too small

[foggy jungle]

Modeling reflections is really hard without something directly in front of you to experiment with in my experience.

[clever lichen]

Just liked the colors lol

Well I suppose I could probably get rid of all the lines right

And make it seem like there's a light shining directly at it

[foggy jungle]

No, because they don't project directly linearly either.

[clever lichen]

So the light wouldn't be as visible from the back and it could get overlooked

Right

Well this is certainly a pleasant learning experience either way

Always wanted to learn a bit of photoshop

[foggy jungle]

Excuse my shitty paint skills. I'd start about there and dump out the lines, then reduce the saturation of the reflection, get rid of the hard line at the 'top' of the reflection.

And then maybe reduce the brightness of the actual picture itself as well as the saturation

[clever lichen]

Actually that's an older one

Already tinkered with that

Mb

Did a gradient overlay

So it gets darker further from the shop light

(line in the middle)

[foggy jungle]

Still looks a little uncanny, but without manipulating it myself, I'm not sure I'd have any good suggestions. (And I don't have Photoshop installed at the moment.)

[clever lichen]

I'll get rid of that hard line

Maybe use the smudge tool?

Stretch it out in some spots?

Also thanks for the help

[foggy jungle]

Another thing I would do before doing any of that is add some noise to your picture.

[clever lichen]

The whole thing?

Or the dog one

[robust plaza]

why are dimes smaller than nickles?

[clever lichen]

https://www.infoplease.com/askeds/why-nickels-are-bigger-dimes ?

That's actually interesting

[robust plaza]

eh disagree, kind of disappointed that there isn't silver in my money anymore

[foggy jungle]

the doggo.

[clever lichen]

And reflection

[foggy jungle]

your goal being to simulate the noise artifacting from jpg compression on the actual dog photo too

err from the camera itself even

[clever lichen]

Ignore the fact I had to take an actual picture

Reset PC of programs the other day

Because audacity sucks

Apparently it doesn't open files in ram

[foggy jungle]

That makes it very hard to determine. And I should clarify I'm not a designer, there's probably communities that have better advice than I'm able to give.

[clever lichen]

It slowly opens on your drive

[clever lichen]

More advice than I had, your doing great

[clever lichen]

I should note I was only opening a 4+ gig audio file

[clever lichen]

I think I found a bit of a solution

@foggy jungle

that seems to look pretty good

ignore the background change

[foggy jungle]

Turn down the saturation a bit on the noise filter for the doggo picture and I agree, it looks better

this is a little funky

[clever lichen]

Gotcha

That is funky

Maybe I tried erasing something and it did that lol

[lament cairn]

this looks good. Is the final image meant to be absolutely, 100% perfect? otherwise you might be overdetailing

[clever lichen]

Over detailing definitely but it's good to learn this

[lament cairn]

👍

[clever lichen]

how about that

turned down the saturation more on the reflection

given it is "reflecting" off metal

Definitely need to blur/blend the bottom of the reflection

It's sticking out like a sore thumb

[foggy jungle]

better

[clever lichen]

turn the saturation down more?

there we go

did a bit of smothing

Smoothing

I don't know why I'm excreting this much energy into this

But apparently I'm all for it

[clever lichen]

this is the final iteration

i am satisfied with it

[foggy jungle]

Looks decent, now switch the picture to a nice otter.

[clever lichen]

Hmmm
Am I sending a request

If so

Idk anymore

If you want the project file

You can have it

[foggy jungle]

I'm good, I was memeing.

[clever lichen]

Lol

My brains fried man

So is my heart(random stress)

Just gotta buy another toolbox to alleviate the stress

[dapper dew]

Math is so cool

[thick osprey]

Math is cool

[crystal spruce]

math is very cool indeed

[grave cove]

i dont like numbers

[crystal spruce]

relatable

integrals much better

[timber jackal]

Math is always cool

[dapper dew]

Just keep taking math classes, the numbers go away after some time

[crystal spruce]

unless you do number theory

[dapper dew]

(I don't have super advanced math, I've got a mech engineering degree)

Calc 3 and diff eq were enough

[thick osprey]

The numbers also go away after a decade or two post classes.

[dapper dew]

Lol

[wraith hound]

i want to learn more higher math because it seems to come up so often in type theory but i don't want to go through all the effort of learning all the foundations of discrete math

i should uh. figure out what i actually need to learn about.

i have no idea what's generally learned after what i have taken in school (what's apparently the equivalent of calc 2)

[crystal spruce]

I'm just some kid that likes doing math

[thick osprey]

discrete math... I owe my name to it!

[crystal spruce]

do you guys prefer pure math or applied math tho

[carmine apex]

wait what how

[wraith hound]

what do people learn after calc 2 usually, actually?

[dapper dew]

I'm biased to applied math

[thick osprey]

There was a book on my desk the day I changed my name. "Discrete Mathematic Projects". I read once that really good names come from typing the first word you see.
I saw Projects and slapped the keyboard.

Preocts

[dapper dew]

Statistics, linear algebra, differential equations, multivariable calculus (calc 3)

After that I have no idea

[carmine apex]

i've been told that calc 3 has a great focus on proofs as well

[dapper dew]

TIL, very cool

[wraith hound]

i'm doing stats next year.. perhaps i shall look into linalg

ooh? proofs? i like the sound of that.

[dapper dew]

The visualization of the problems is more fun

[wraith hound]

proofs are fun, but i haven't done much in the way of formal proofs

[dapper dew]

"what is the global max Z value for this surface" type of stuff

[crystal spruce]

I like rigorous proofs

epsilon delta is cool

[dapper dew]

Proof it

(Joking)

[thick osprey]

At least the book provided me something. I never used it. haha That was the year I decided school just wasn't my thing.

[carmine apex]

discrete does proofs as well, being logic and graph theory mostly

[crystal spruce]

linalg is my current favourite since it has a good balance between cool concepts and rigorous proofs

because linalg has a lot of proofs

[dapper dew]

Well it's my bedtime, catch yall later

[acoustic moss]

origin story

[grave cove]

Why don't you tell us your origin story dear hsp

[acoustic moss]

haha stinky poop was the description on a michael reeves twitch stream

[distant hazel]

ew math

[acoustic moss]

math 😎 👍

[grave cove]

uh huh sure

[distant hazel]

was it actually?

[acoustic moss]

yeah lol

[grave cove]

lies and deception

[distant hazel]

i watched a clip of him describing his lack of knowledge in adulting

[acoustic moss]

god i love michael reeves

[grave cove]

pretty cool guy

[rough sapphire]

Analysis on Manifolds, ODEs (existence of solutions, systems of linear odes, continueability), Introductory Abstract Algebra, Numerical Analysis, Measure Theory

[crystal spruce]

manifolds my beloved

[clear acorn]

Woah math

[jaunty wraith]

https://github.com/typst/typst
looks interesting 👀

[rare wing]

How do inte how

[high haven]

lol thought they would never

guess i should sign up for their waitlist

ig

[tardy rain]

🤙🤙

[high haven]

oh hey

also accurate

[young shoal]

what's poc

point of contact?

[high haven]

proof of concept

[young shoal]

o

[high haven]

if youre trying to convince others, you usually start with a poc

at least thats what ive been told

[young shoal]

seems reasonable enough

[jaunty wraith]

mvp/poc

[tardy rain]

Theres a poc being deved, im not allowed near it

[jaunty wraith]

because…?

[tardy rain]

If i told you i'd have to kill you

I guess I'm too junior

[young shoal]

oof

[tardy rain]

Ok now that you know im gonna need an address pls 🥺 @jaunty wraith

[young shoal]

wait what

[jaunty wraith]

what

[tardy rain]

^

[young shoal]

oh

[jaunty wraith]

but you didn't tell me

[young shoal]

you can't just say you have to kill them if you told them and then tell them

[tardy rain]

I dont see the problem here

[jaunty wraith]

counter point: I can't read, so I can never know

[tardy rain]

Sad but i'll accept it as extenuating circumstances

[high haven]

time to make your own poc

[solar drift]

guys

[signal scroll]

?

[rugged owl]

When it hasn't been a day, and you get an email that starts with: "Gentle reminder on the request below". inhale

[rugged owl]

Also, did everyone somehow hear I"m leaving next week on vacation? Where tf all these random sheot requests come from?

[young shoal]

lul

[high haven]

insert meme about business stakeholders

"i would like this done yesterday"

[young shoal]

no u

[high haven]

no me

wait i forgot

i dont like math

😛

[young shoal]

says the DS

[high haven]

just bc i use it

doesnt mean i have to like it

[young shoal]

do dev

[high haven]

honestly

im heavily considering it

[young shoal]

oh?

[high haven]

less dealing with bs from the business

well jk

i know devs still deal with it

but they usually have a filter person lol

[tardy rain]

What kind of dev

Dont say web dev

[young shoal]

do something cool

[high haven]

i mean ideally it would be MLE but i dont think i have the skills for it

[young shoal]

😔

[high haven]

bro i was going to ask you to teach me web dev

[tardy rain]

Lmao

Hold up gotta find someone to teach me first

[young shoal]

😔

[high haven]

i will wait

psvm teach me web dev

[tardy rain]

All i know rn is Array.map and npm create vite@latest

[high haven]

bro my friends were talking about vite lol

and i was like

[young shoal]

why me

[high haven]

nod head

why not you

[young shoal]

I'm not really a web dev per se

[high haven]

more than me

[grave cove]

I gotchu

[high haven]

thats for sure

oh?

[grave cove]

Web dev extraordinaire

💪

[high haven]

ooo

[young shoal]

rofl

[high haven]

lmao "NO REMOTE"

lmao theres all these obscure bioinformatics tools no ones ever heard

of

in that world, theres a lot of bespoke tooling

[tardy rain]

Aww sweetie, you'll get there some day

[high haven]

lmao

im assuming it was made

due to google playing catchup

with bard

[tardy rain]

I wonder why bard and not some edgy acronym