Hacker News Reader

Because nodejs kubernetes modern cloud.

meritton Things I hate about PostgreSQL (2020)

That's only for MyISAM which sees very little use today. The InnoDB engine on MySQL does a full row count and is also relatively slow.

meritton Speeding up SQL queries by orders of magnitude using UNION

Your understanding is flawed, these aren’t cross joins.

meritton Money Creation: 344% in the Last 12mo (Fed, M1, $)

https://fred.stlouisfed.org/graph/?g=BlKq

M1 vs M2. The creation is still quite significant ($3T) but nothing whatsoever like the M1 chart implies.

meritton I believe US could see rolling series of “Ireland events” over next 2 months

https://www.google.com/search?q=ireland+covid+cases

Same graph. Happy?

meritton Simple Anomaly Detection Using Plain SQL

That's what you took from that? They gave an example of using SQL to do anomaly detection that happened to use httpd logs as an example.

The strategies within could be applied to virtually any time-series data.

meritton Parler CEO Says Service Dropped by “Every Vendor” and Could End His Business

The fact that the overwhelming color of every comment on this thread is light-grey tells you there's no middle ground until everything is burned down.

meritton Taking PHP Seriously (2016)

fyi on swoole, this book [1] just came out (I cannot comment on the quality, haven't read yet) which hopefully will help bridge the English documentation gap. I've been using swoole for a couple of years and google-translating my way through the Chinese wiki and git issues/comments/etc.

[1] https://www.amazon.com/dp/B0881B227S

meritton Taking PHP Seriously (2016)

Swoole (module) is extremely performant in anything networking, including as a websocket server. There are other php-only options (amphp/websocket-server, ratchetphp/Ratchet) but if performance is your need, stick with swoole.

meritton In-App Purchase Rules

I'm not talking about the quantity, I'm talking about a list of who upvoted and downvoted a specific comment/post.

Also what you've described happens anyway. The fact that a number isn't displayed doesn't really matter when comments are ultimately ordered by score. When someone writes a comment that doesn't adhere to the current groupthink, they get downvoted. When people are downvoted too much they delete their comments, stop commenting, or through pavlovian reinforcement change their opinions until they get positive points.

meritton In-App Purchase Rules

> It would be good to get a little more awareness into this process.

Make upvotes and downvotes public, and do something to reduce the constant flood of throwaway accounts who do nothing more than constant trolling on contentious topics.

meritton In-App Purchase Rules

I'm glad Marco finally stepped up to set the HN groupthink tone because you guys have been salivating to defend Apple the past month in every goddamn thread about Epic Games.

meritton Rideshare operations are being suspended in California

That's interesting since Craigslist has operated a rideshare marketplace for 20+ years and runs at an 80% profit margin. They've also never ran afoul of contractor vs. employee scrutiny.

Could it be that perhaps Uber and Lyft are simply poorly ran organizations who only excel at burning VC money?

meritton Rideshare operations are being suspended in California

When Tesla/Waymo/Uber/Lyft roll out actual self-driving technology in the future and people complain "robots are taking our jobs!" we can point to this legislation and say "actually, no, it was the politicians"

meritton I Quit My Job. Here’s How I Planned the Start as an Entrepreneur

He quit his job at a consultancy to become a solo consultant. Groundbreaking.

meritton Epic will mock Apple’s most iconic ad as possible revenge for App Store ban

> In an actual court of law (rather than court of public opinion) there is no way Epic will win especially since Google took the same stance.

Apple is being investigated by numerous governments around the world [1][2] for antitrust regarding their app store, and just lost an antitrust case in Russia [3]. Epic Games simply adds a big name to the list.

[1] https://ec.europa.eu/commission/presscorner/detail/en/ip_20_...

[2] https://www.cnbc.com/2019/05/13/supreme-court-rules-against-...

[3] https://www.engadget.com/apple-russia-fas-rulling-203806171....

meritton Ask HN: Self-taught webdev with lots of free time. What should I learn?

> It's impossible to study topics you've never heard of

If only there was some way for people to communicate these linked topics in some sort of portable written format!

meritton We Can Do Better Than SQL

Make sure you understand what optimization fences are and how they affect your performance. CTEs are nice to read but routinely destroy the performance.

[1] https://thoughtbot.com/blog/advanced-postgres-performance-ti...

meritton People work longer and different hours under lockdown

Sorry, this doesn't work for the many people who simply aren't equipped to WFH and are learning to work remotely. They lack the dedicated workspace at home, they have children/family/roommates who don't respect the "im at work" mentality, or they simply need a mid-afternoon nap, and as a result they have frequent and often lengthy periods of not working.

Would be fair to the employer if those people still adhere to a strict 9-5 schedule despite the lowered productivity? I think most reasonable people simply adapt and that's why we have articles like this pointing out longer and different work hours. It's not unreasonable at all.

meritton IAM is hard – Thoughts on $80M fine from the Capital One Breach

The point I am trying to make is "microservice" does nothing whatsoever to solve the problem of people incorrectly provisioning IAM permissions.

meritton IAM is hard – Thoughts on $80M fine from the Capital One Breach

You can just as easily give overly permissive IAM credentials to a microservice. That's what happened here. Some tiny little web service was breached, and that service was provisioned a full-access IAM credential.

meritton Is Hacker News Bullshit?

> Discussion about Trump or US politics in general

What HN do you visit? Any time anything remotely touching politics shows up here it gets immediately flagged, removed from the front page, and the level-headed comments you speak of get downvoted into oblivion.

meritton Instacart shoppers besieged by bots that snatch lucrative orders

No clue what Instacart shoppers do. What makes the orders lucrative/better? Is it high dollar orders, or multiple orders at the same grocery store, or is the tip pre-published, or what's the criteria when looking for orders to fulfill?

meritton Show HN: Odin – The Observable and Distributed Workflow System

This looks like a really complex crontab that requires mongoDB of all things.

meritton The code I’m still ashamed of (2016)

Yeah, imagine a world where each employee had a team of highly trained specialists ensuring they had absolutely everything they need to do their job, and if they became sick at 2am on a Saturday, multiple people get woken up to take care of them. When the CEO parades investors around on the assembly floor, those employees are shined up, their capabilities are demonstrated, and they are showcased as the pinnacle of why their company is the best.

Low level employees would be lucky to be treated like robots.

meritton Twilio: Someone broke into our AWS S3 silo, added 'non-malicious' code to JS SDK

I have external partners who provide their own principal and I provision a subset of bucket access at the bucket policy level. Is there a better way to do this that's more manageable? The end users are using software or python code where they need to gain access via [access, secret, bucket, prefix/key].

meritton Where $521B in U.S. Small-Business Aid Went

> it pays out 100k in salary.

Then the maximum loan you would have qualified for would have been $20,833 and you'd be able to get about 80% (plus applicable utility/rent/mortgages up to potentially 100%) forgiven.

So, $16-21k of free money with currently unclear tax implications. Nothing to sneeze at but it's nothing insane either.

meritton US online grocery sales hit record $7.2B in June

It's not the mask, it's the hassle of going to the grocery store and locating the items and waiting in line and dealing with those temperamental self-checkouts.

Today though it's amazing. I put together a grocery order at my convenience and place and pay via the app, and it just magically shows up at my door within a convenient time-frame. I don't have to answer the door, I don't have to talk to anyone, I don't have to sign a receipt. It just shows up.

meritton Tesla becomes most valuable automaker in latest stock rally

Sir, you're in the church of Elon, and you know blasphemy is not allowed.

meritton DHH: The HEY stack Vanilla Ruby on Rails, MySQL, redis, stimulus, elastic search

Not that I'm aware of no. While the end product is released open-source, the development cycle itself is very much closed-source and there are very valid concerns about MySQL being owned by Oracle. MariaDB is a fully open-source alternative though I'd argue MySQL8 has surpassed MariaDB in terms of quality and features.