Recent submissions

Comment · 9 months ago
The most interesting thing for me in this article was the mention of `MERGE` almost in passing at the end.

> I'm not a big fan of using the constraint names in SQL, so to overcome both limitations I'd use MERGE instead:

``` db=# MERGE INTO urls t USING (VALUES (1000004, 'https://hakibenita.com')) AS s(id, url) ON t.url = s.url WHEN MATCHED THEN UPDATE SET id = s.id WHEN NOT MATCHED THEN INSERT (id, url) VALUES (s.id, s.url); MERGE 1 ```

I use `insert ... on conflict do update ...` all the time to handle upserts, but it seems like merge may be more powerful and able to work in more scenarios. I hadn't heard of it before.

Comment · 10 months ago
I think you might have terminal brain rot
Comment · 1 year ago
I know I'm going to get downvoted into oblivion here but I do think it looks kinda nice -- like I might would buy one of the sweatshirts
Comment · 1 year ago
The other two companies labeled as Columbia SC are actually Columbia Maryland too haha
Comment · 1 year ago
3 companies in columbia sc but further investigation yields columbia md for 2 and columbia mo for the third. So state data seems pretty non-existent
Comment · 1 year ago
Seems like the regulation works well when it is applied. Why is there a need for a simpler solution? Why try to replace it with a 'simpler' tax with none of the human consideration about how the m/a could lead to less competition.

Like if this regulation was replaced in favor of this tax, a big company merging with another big company would be considered fine when obviously big company mergers can be just as concerning as larger companies buying smaller ones

Comment · 1 year ago
I think what you’re seeing is a confusion coming from ground news own terms. They call something a “left wing blind spot” when it’s a story that does not appear in left-wing sources, meaning that it only appears in right wing sources. The blog copies that terminology here, but it can lead to some confusion.
Comment · 1 year ago
So being permitted to run 15 turbines and the installing and running 24 turbines is not breaking your permit?
Comment · 1 year ago
Saw this and came here to look in the comments for somebody asking the same thing
Comment · 1 year ago
Comment · 1 year ago
Fair point
Comment · 1 year ago
[flagged]
Comment · 1 year ago
There are some hilarious tidbits in here

> Starting in the first week of 2024, the FreeBSD boot process suddenly got about 3x slower. I started bisecting commits, and tracked it down to... a commit which increased the root disk size from 5 GB to 6 GB. Why? Well, I reached out to some of my friends at Amazon, and it turned out that the answer was somewhere between "magic" and "you really don't want to know"; but the important part for me was that increasing the root disk size to 8 GB restored performance to earlier levels.

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton