HNHacker News
TopNewBestAskShowJobs

pocket_cheese

151 karma · joined November 27, 2019

submissionscomments
pocket_cheese··on Do we live in a society without a counterculture?
There are peer reviewed studies on this subject and they confirm that trans people are significantly more likely to experience housing insecurity.
pocket_cheese··on Do we live in a society without a counterculture?
I've never had random people on the street threaten to beat my ass or make violent threats towards me before my transition, and now it happens a couple times a year. I also way to many trans friends that are homeless because their conservative parents disagreed.

Across every single metric, trans people, especially trans POC face disproportionate adversity. i.e. income, murder rate, housing insecurity, education etc...

pocket_cheese··on Contracts you should never sign
Non competes are becoming less and less enforceable in the US.

I left my old company and wanted to start a competing business in a different vertical in the e-commerce space. What actually stopped me was the privacy and inventions and non disclosure agreements.

Pretty much it prevented me from using any know how I learned while at my last company and disallowed me from using any of the same suppliers and marketplaces to buy and sell on (of which there are few in my business domain).

In my experience, these types of agreements can be the actual thing that stops you from doing your own thing.

pocket_cheese··on Ask HN: What would be your stack if you are building an MVP today?
For an MVP I'm building, I'm using retool as the frontend, Flask hosted on appengine as the backend, cloud functions for async task execution, and a managed CloudSql postgres instance for the data layer.

I suck at UI/UX design and don't want to write a bunch of JS for async webapp stuff, so retool is a force multiplier there and would highly recommend. I Don't want to manage any infra, so appengine handles that for me. After getting everything setup with terraform in a day or so, I spend all of my time developing core functionality and 0 time managing servers or getting a UI to do what I want it to do.

Total cost to host is < $100

pocket_cheese··on Google to reduce workforce by 12k
If the average cost of those employees is 150k usd, then it's 1.8 billion. I imagine it's probably much higher than 150k depending on how many were US based engineers. If they make 55ish billion this year, I think it makes a pretty decent impact.

I 100% support siphoning as much money as possible while doing as little work as possible (a.k.a coasting). However, from a capitalist perspective, it makes sense to try to weed those people out. Gone are the days of a 26 year old making as much as a neurosurgeon while working 20 hours a week.

pocket_cheese··on Google to reduce workforce by 12k
I like to categorize jobs into 3 tiers.

Tier 1: Outrageous comp and difficult interviews. Tier 2: Great comp and medium level difficulty interviews. Tier 3: Companies that pay at or below average for an engineer and sometimes don't even have a coding interview!

for the tier 1s I was outright rejected my application twice as often as before. I also noticed that they are more selective. I've passed "high bar" technical interviews before, so have some understanding of what it takes. This time around I thought I did pretty well, but didn't get an offer (coincidentally at Google). More candidates + focus on cost cutting has made things much more competitive for really high paying jobs.

For those tier 2/3 jobs they are exactly the same as before. Recruiters constantly messaging and got an offer after only being on the market for a couple of weeks.

pocket_cheese··on Ask HN: What weird technical scene are you fond/part of?
Web scraping. I love figuring out how to reverse engineer websites and defeat systems designed against web scrapers. It's also super interesting (concerning?) how much data websites leak. 4 out of the 5 bug bounties I've discovered have been while poking around in my scraping efforts.
pocket_cheese··on Crypto dominoes fall in the wake of FTX's collapse
There's companies like Paxos that are actually audited and have a token PAXG that is backed 1:1 with actual gold reserves. The tokens themselves actually have serial numbers that are linked to a physical gold bar.
pocket_cheese··on Facebook has a hidden tool to delete your phone number, email
There's actually a spec for this, but only like 20% of companies follow it

https://github.com/InteractiveAdvertisingBureau/USPrivacy/bl...

There's also a requirement that you have to delete data from downstream vendors that you've shared customer data with. That being said, I wouldn't trust for a minute that companies are complying with 3rd party deletions

pocket_cheese··on Granting Pardon for the Offense of Simple Possession of Marijuana
I dabble in adult content creation and could absolutely get fired for it. It's not exactly a vice though.
pocket_cheese··on Lessons learned from running Apache Airflow at scale
I've had the pleasure of working with a world class infra team that managed our Airflow setup on Kubernetes and this made working with it a wonderful experience. At the same time, early in my career, I used Airflow with a team that didn't understand the technology (myself included) and it was a nightmare.

I'm now at a tiny company without the infra to support Airflow, so I tested all the managed airflow providers (Composer, MWAA, and Astronomer) and ultimately settled on Astronomer. I also spent some time creating a framework that generates Dags from configuration and now 90% of my new etls just involve creating a config and a sql query. Pretty happy with my current setup and my only complaint is that Astronomer won't let you exec into a Task pod, which is actually kind of a big deal, but still better than having to manage a k8s cluster.

pocket_cheese··on Mark Zuckerberg on Messenger (2013)
I don't trust big tech to regulate truth, but let's not dismiss misinformation with such broad strokes.

There are deliberate attempts by politically and monetarily motivated groups to spread objectively false propaganda. FUD/HODL to mislead investors, conspiracy theories to sway public opinion, pseudoscience to peddle ineffective medical treatments... The people doing this effectively aren't individuals disagreeing with mainstream discourse, they know exactly what they're doing.

pocket_cheese··on Web Scraping with Python
A federated marketplace for scrapers is an idea I have thought considerably about. If you have time, I would love to chat to a) discuss being a paying user and b) to talk about the industry and see how we could submit some scrapers.

Let me know how I can reach out to you!

pocket_cheese··on Remote work will break the US monopoly on global talent
I have worked for FAANG without a diploma. While it is rare, you can definitely do it if you grind enough leet code :D
pocket_cheese··on I spent 5 years writing my own operating system
I think he was talking about the clusters of machines used in big data. Both in processing (Spark) and storage (SAP HANA). These use cases can need TBs of ram.
pocket_cheese··on Multitasking hurts performance and may even damage the brain (2018)
How dare you describe me so accurately. But all jokes aside, this is my current situation and so far I've been unsuccessful in finding motivation without subjecting myself to bone-crushing anxiety that comes with working with people I think are way smarter than me.
pocket_cheese··on Facebook wants to 'normalize' the mass scraping of personal data
Scraping facebook has been one of my dreams. I remember taking a cursory crack at it and giving up after seeing how much of time, money and effort it would involve. The cost of storing the data alone would be cost prohibitive, even if you have a fancy FAANG salary.

Scraping facebook is an operation. One I wish to make happen one day :D

pocket_cheese··on We Discovered Google’s Social Justice Blocklist for YouTube Ad Placements
There are a lot of terms they mentioned that aren't political though. Blocking terms like "Muslim Fashion" doesn't seem defensible.

> actually appreciate it that YouTube seems to suppress ads that target political topics

I think that youtube should be suppressing shitty adds, not potentially decisive content. The way they are currently handling the situation signals to creators from marginalized groups that they should not talk about substantive issues if they want to get paid.

This is disheartening as it is ironic because Google (and literally every other mega corporation) tries to posture themselves as being socially conscious, but as soon as people want to talk about injustice or inequality, they are essentially soft-deplatformed.

> even if the blocklist is still incomplete

I might be a little cynical, but I feel like it is complete because it's working the way they want it to. The one-sidedness of the blacklist doesn't tell me that google is discriminatory. It tells me that the companies buying ads are discriminatory, and google changes their policies to make them happy. Google's tacit acceptance of prejudice tells me everything I need to know about their principals.

pocket_cheese··on Programming is hard
Programming in isolation is simple to learn. Rudimentary understanding of control flow, syntax and how to use primitive data types are literally enough to write any program in the world. I feel like 80% of people could probably go from zero to fizzbuzz in a week if they had a good teacher and a modicum of interest.

But the real world is so much more complicated and that it is the real gatekeeper. I've taught several non-technical people how to code, and the biggest first hurdles usually are: setting up their dev environment, installing dependencies, understanding the command line.

I think it's interesting that explaining why you have to add things to your $PATH is harder than explaining how an if statment works.

pocket_cheese··on One woman's struggle to remove all traces of videotaped sexual assault
You are equating mean youtube comments to revenge porn. This is the whole "We should just ban cars" response when someone brings up gun control.

>It should be impossible to comment referencing someone else without a signed waver from the participants

If the comment is a nude picture of myself and I didn't give you permission to post it the law already agrees that this should be illegal. All I'm asking is to make it enforceable.

Porn is shady industry ripe with abuse and exploitation. How do you know the person you are watching is over 18? Let me answer that... You don't. Some industries should be given more regulatory scrutiny than others.

pocket_cheese··on One woman's struggle to remove all traces of videotaped sexual assault
Asking someone experiencing sexual trauma to 'let it be' is such a dismissive take.

Being a victim of revenge porn means that you can be blackmailed at anytime. Most people do not want to be sexualized, and it's humiliating to have to live with the fact that your coworkers will now have ammo to harass over you if they discover your videos. Don't get me started on what happens if you have kids, and their friends find out you were in porn.

Realistically, you can't scrub the internet of a video. I personally feel like the solution is that porn should be highly regulated. A formalized content upload process, licensing, required staff to deal with these types of complaints. It should be impossible to upload a video without a signed waver from the participants. Sure, this might remove pure anonymity, but you can still have mechanisms in place to protect your identity if you want to make amateur content without divulging your identity to the public.

pocket_cheese··on Web Scraping 101 with Python
As someone who has done a good bit of scraping, how a website is designed dictates how I scrape.

If it's a static website that has consistently structured HTML and is easy to enumerate through all the webpages I'm looking for, then simple python requests code will work.

The less clear case is when to use a headless browser vs reverse engineering JS/server side APIs. Typically, I will do like a 10 minute dive into the client side js and monitor ajax requests to see if it would be super easy to hit some API that returns JSON to get my data. If reverse engineering seems to hairy, then I will just do headless browser.

I have a really strong preference for hitting JSON apis directly because, well, you get JSON! Also you usually get more data then you even knew existed.

Then again, if I was creating a spider to recursively crawl a non-static website, then I think Headless is the path of least resistance. But usually, I'm trying to get data in the HTML, and not the whole document.

pocket_cheese··on We Replaced an SSD with Storage Class Memory
For anyone interested in how a database works underneath the hood, I could not recommend a better MOOC than Andy Pavlo's database courses. His intro to database course is so freaking good.
pocket_cheese··on Ask HN: How many of you are employed, self-taught SWEs?
>Why did you get into the field? What did you focus on at first?

It was an accident. I needed to accomplish an admin task which required modifying a SQL query someone else wrote. I just fully dove into SQL mainly for reporting purposes after that.

>What are you doing at your job? Is it everything you dreamed of and more?

I am a data engineer for a unicorn startup. It is really awesome! The pay is ridiculous, especially considering I live in a low cost of living area but have a standard tech SF salary. Also the talent is insane. I get to interact with some really smart folks.

> How did you break that first-job barrier?

I saw the opportunity to automate an admin problem with a SQL query. I asked a developer to pretty much be my senpai, and he gave me an SQL crash course. After that, I did SQL tutorial after SQL tutorial and eventually got promoted from call center agent to data analyst.

>What were you doing before this?

I was a call center agent and working at a car wash right before that. That was like 5 years ago :D

>Any tips for the rest of us?

Get in touch with your companies IT/engineering department if you can. Lots of software people love curiosity. Try to find someone like that where you currently work. Also, do a lot of projects and be prepared to feel really confused about how things work. I think I would not be where I am today if I didn't have some really good mentors. Secondly, programming tutorials will have you believe that the world is just a bunch of for loops and if statements. But then you look at a real life production system and it's wayyyyy more complicated than that. Just know that the minimum amount of knowledge you need to have a software job is probably a lot lower than it would seem. Don't be discouraged when you feel like you have no idea how something works because it will happen a lot.

pocket_cheese··on Advanced SQL and database books and resources
OMG yes! Andy Pavlo is such a good teacher. I watched his entire lecture series, and it really helped me prepare for an interview. I couldn't recommend his MOOC enough if you really want to know how a database works. I just wish that the homework assignments were available to the public.
pocket_cheese··on Chrome phasing out support for User-Agent
As a person who scrapes sites (ethically), I think it's impossible or pretty damn near impossible to prevent a motivated actor from scraping your website. However, I've avoided scraping websites because their anti scraping measures made it not worth the effort of figuring out their site. I think it's still worth for do minimal things like minify/obfuscate your client side JS and use some type of one time use request token to restrict replay-ability. The difference between knowing that I can figure it in 30 minutes vs 4 hours vs a few days is going to filter out a lot of people.

Of course, sometimes obfuscating how your website works can make it needlessly more complicated, so it's a trade off.

pocket_cheese··on Domain Logic and SQL (2003)
One way I get around this is having an append only version of the main table, and then a "most current record" version of the table. My append only table will be a running record of all the data I've loaded unmodified. Then I run a create table as select statement against my append only table to generate my new version of the final table. So in essence, I'm "deleting" the old version of the record by omitting it when I create my new version of the final table.
← PreviousPage 2 of 2