HNHacker News
TopNewBestAskShowJobs

momothereal

678 karma · joined November 24, 2017

submissionscomments
momothereal··on Canada, April: Under-65 excess mortality exceeds under-65 Covid-19 deaths
The problem here is mostly the lack of available nurses and doctors, who have to pull insane shifts to compensate. Hospitals are also very concentrated in urban areas. Canada has 30% less nurses per capita than the US.
momothereal··on The Future of discord.py
> Discord is forcing bots that are in over 75 servers to make use of slash commands, because Discord will no longer send raw messages starting April 2022

Can someone explain why that is? My understanding is that adding bots to a server requires Admin/Owner access, who are already at liberty to read all messages. If you don't trust bots scraping your messages in a server, don't you implicitely distrust the owners? Just leave the server?

momothereal··on Youtube-dl is possibly dead
Seriously. I've seen core/lead maintainers on projects I worked on go awol for months and years at a time, and come back guns blazing.
momothereal··on Ask HN: How aware are you about building decentralised software on blockchain?
There's a significant amount of software that is ran by the developer (hosting) at a cost to the developer. The idea here is that the user pays for the hosting directly instead.
momothereal··on Jim Whitehurst to step down as IBM President
Not trying to downplay that one either, but Pheonix put thousands of people in major financial risk and/or ruin, and at least 1 suicide was attributed to it.
momothereal··on Jim Whitehurst to step down as IBM President
By far the biggest software fuckup in Canada's history.
momothereal··on New GitHub Issues Beta
It's for people that want to find issues to work on in random repos, I suppose.
momothereal··on A framework for building Open Graph images
So half the blog is about optimizing Pupeteer and about how it's launching an entire Chrome browser to take a screenshot.

But why? Are there no Node.js equivalents to PIL??

momothereal··on Tour of the server room in the Airbus 350
I think you can see that the shots in the server room were done on the tarmac
momothereal··on I wrote a children's book / illustrated guide to Apache Kafka
https://azure.microsoft.com/en-ca/resources/videos/the-illus... :)
momothereal··on Only 6 of the 50 largest companies are in Europe. LVMH is highest at #18
? Adobe has over 100 software products: https://www.adobe.com/products/catalog.html
momothereal··on Show HN: I made a community sourced fitness routine database
This is really cool! Well done
momothereal··on File Permissions: A painful side of Docker (2019)
If you have to build it on each machine, I would not consider that easily/universally distributable. One of the key points of Docker is you can build once (in your CI or someone else's) and run it on any machine. I think that was GP's point.
momothereal··on ClickHouse: An open-source column-oriented database management system
Alright, here is an example. My data is a stream of events, each row has the values (event_id, person_id, date). This is the table with 40M rows, with inserts between 2/s and 10/s.

person_id is a foreign ID for a "person table" that fits well in the relational model. A "person" has various attributes (name, DOB, email) as well as a one-to-many relation to "groups". Groups are a collection of users with additional attributes (e.g. group name).

Now, what if I want to answer questions like:

   - how many total events for all persons in group X
   - who are the top 10 users in number of events in group X
   - which are the top 10 groups in number of events
In this case, the person/group tables are part of the core business logic, they aren't specific to the events table. It doesn't make sense to store it in Clickhouse. Also, this person/group data gets updated sparsely, but "freshness" should be kept at a minimum (< 30secs).

The simple approach to the first question would be

   - Get all the user IDs in group X
   - Filter events by those user IDs
But what if there are tens of thousands of users in group X? And hundreds of groups? Are megabyte-long queries supported in Clickhouse?
momothereal··on ClickHouse: An open-source column-oriented database management system
People who've used Clickhouse or other OLAP databases in production & at scale, how do you "interconnect" it with relational data?

I'm currently experimenting with Clickhouse, because my dataflow is increasing in size (40M rows right now, doubling every month or so) and my current setup (MongoDB) is at its limits. I would like to migrate the 40M rows to CH, but I also need the metadata for the rows to be in something more robust like Postgres or Mongo. Would you have a microservice that does the queries between the OLAP and relational DBs and does the join manually, exposing that as some low-level API? Or is using the various FDW options (remote tables in Clickhouse, Postgres clickhouse_fdw, etc.) realistic in production?

Sorry for the ramble, it's late here. But I can clarify if necessary.

momothereal··on Four years after a man was executed, someone else’s DNA found on murder weapon
If the country in question has a good track record of punishing judges, prosecutors, and LEA, then it would be abolishing the death penalty _de facto_, as no-one would take that sort of risk over just imprisoning the person for life.

If the country does not have a good track record, it doesn't really change anything.

momothereal··on Ask HN: How does performance appraisals happen in your organisation?
Public service, in Canada :)

AFAIK every department follows this structure for performance[1], so that's about 200k employees.

The promotion system is a bit special for my department, since it's tailored for software engineers (about 40% of the department). The rest of the public service has a more competitive system, more similar to the private sector.

[1] https://www.canada.ca/en/treasury-board-secretariat/services...

momothereal··on Ask HN: How does performance appraisals happen in your organisation?
You write down some goals and discuss with direct supervisor. After 1 year, another meeting to see how well you did, and you get a rating like "Succeeded", "Succeeded+" or even "Excelled". Set some new goals for the next year, rinse and repeat.

For promotions, you give a 1-2hr presentation on the work you've done to a group of other developers and managers not directly working with you. Work done needs to match 51% of the competencies to go to the next level. Usually the pay increase is 10% per level (promotion).

It's practically impossible to get fired. Only way is up.

momothereal··on The Oncoming Ransomware Storm
What's the punishment for paying? A fine? Then you might as well add that to the ransom and pay...

Snark aside, there's just no simple, hand-waving solution to this. Even if you held the company owners criminally liable for paying a ransom, pretty much any small company will shut down for not being able to afford top-notch security.

It also opens the door to blackmail:

> We've encrypted your files. Pay us $AMOUNT BTC by tomorrow, or your files are gone. And with a recurring payment of $AMOUNT BTC per month, I promise not to report you to the FBI for paying!

momothereal··on I mailed an AirTag and tracked its progress
Sort of; if you find a lost AirTag, you can get the contact info from an Android device via NFC: https://youtu.be/ehv3zQAa9zM?t=528
momothereal··on I Hacked Google App Engine: Anatomy of a Java Bytecode Exploit
What's the link between WebSphere and the Olympic games?
momothereal··on FFmpeg Cheat Sheet
My favorite part of FFmpeg is playing around with the "complex" filters. It works like a pipeline format, applying filters to different streams and merging them together.

For example, in a previous hackaton I used it to combine randomly-generated TTS, music, and video with varying filters: https://github.com/aramperes/code-jam-2/blob/a00e73ec7a912f6...

momothereal··on Argentine version of Google falls into “wrong” hands
They own https://www.google.com.gi/ though.
momothereal··on Ubuntu 21.04
I've learned not to hold my breath on Ubuntu + Nvidia cards ever working out of the box. I've been using Pop_OS as a daily driver (distro over Ubuntu) and it works 95% of the time.
momothereal··on IBM employee forced to stop kernel work under personal email address
The fact that the entire entry was removed, as opposed to simply changing the address, combined with the tone of the message, makes me think otherwise. However, I'm basing this off the exact same information as you (presumably), so it's a bit of a moot point until someone wants to pitch in with more authority.
momothereal··on IBM employee forced to stop kernel work under personal email address
The included message is probably lacking a lot of both written and unwritten context.
momothereal··on IBM employee forced to stop kernel work under personal email address
The way I'm interpreting this, it's not _because_ they used a personal address, but rather that they weren't allowed to contribute to VNIC [for contractual reasons], and using a personal email address does not magically bypass that restriction.

(The current title is "IBM employee forced to stop kernel work for using personal email address", which is an interpretation likely missing context)

momothereal··on A List of Hacker News's Undocumented Features and Behaviors (2018-20)
(2020) I guess because that's the last time it was updated
momothereal··on Firefox 88.0
Why? There's been small but consistent improvements in each release, including this one.
momothereal··on An RFC that adds support for Rust to the Linux kernel
The opposite of ACK (Acknowledged) in many protocols. Basically Rejected.
← PreviousPage 3 of 6Next →