michaelmcmillan

Joined 14 years ago

Karma
1,010
Submissions
382
Member since
Jun 5
https://michaelmcmillan.net
View on Hacker News

Recent submissions

Comment · 10 months ago
It is a long-standing policy at Netflix for employees to pay for their own subscriptions. It ensures that employees "live the member experience".
Comment · 11 months ago
Linux is written in C, my friend.
Comment · 1 year ago
Which is useless if the domain had HSTS enabled, which they should.
Comment · 1 year ago
"modicum of research"

Jesus christ. The reason why that comment gets brought up is because it stereotypes the HN community. He wasn't disrespectful. Calm down.

Comment · 1 year ago
Exactly.
Comment · 1 year ago
Please, please, please use Terraform workspaces: One workspace per environment.

For environment specific things use conditionals:

  nodes = terraform.workspace == "prod" ? 2 : 1
Comment · 2 years ago
My bad. You’re right.
Comment · 3 years ago
Same here. Use n8n. Self hosted and open source.
Comment · 4 years ago
Good example of why it’s a good idea to browse the web using a VM.
Comment · 4 years ago
That's not nearly enough.
Comment · 4 years ago
Real estate: Buy, repair, rent, refinance, repeat.
Comment · 4 years ago
Exactly, this is ridiculous...
Comment · 4 years ago
This section was interesting! Somehow I've never realized that row oriented storage is orthogonal to how disks work...

  Jd is a columnar (column oriented) RDBMS.
  
  Most RDBMS systems are row oriented. Ages ago they fell into the trap of thinking of tables as rows (records). You can see how this happened. The end user wants the record that has a first name, last name, license, make, model, color, and date. So a row was the unit of information and rows were stored sequentially on disk. Row orientation works for small amounts of data. But think about what happens when there are lots of rows and the user wants all rows where the license starts with 123 and the color is blue or black. In a naive system the application has to read every single byte of data from the disk. There are lots of bytes and reading from disk is, by orders of magnitude, the slowest part of the performance equation. To answer this simple question all the data had to be read from disk. This is a performance disaster and that is where decades of adding bandages and kludges started.
  
  Jd is columnar so the data is 'fully inverted'. This means all of the license numbers are stored together and sequentially on disk. The same for all the other columns. Think about the earlier query for license and color. Jd gets the license numbers from disk (a tiny fraction of the database) and generates a boolean mask of rows that match. It then gets the color column from disk (another small fraction of the data) and generates a boolean mask of matches and ANDS that with the other mask. It can now directly read just the rows from just the columns that are required in the result. Only a small fraction of the data is read. In J, columns used in queries are likely already in memory and the query runs at ram speed, not the sad and slow disk speed.
  
  Both scenarios above are simplified, but the point is strong and valid. The end user thinks in records, but the work to get those records is best organized by columns.
  
  Row oriented is slavishly tied to the design ideas of filing cabinets and manila folders. Column oriented embraces computers.
  
  A table column is a mapped file.
Comment · 4 years ago
Cool! Do you login with one account bouncing off 60 IP addresses?

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton