msdrigg

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.

I think you might have terminal brain rot

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

The other two companies labeled as Columbia SC are actually Columbia Maryland too haha

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

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

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.

So being permitted to run 15 turbines and the installing and running 24 turbines is not breaking your permit?

Saw this and came here to look in the comments for somebody asking the same thing

Airport has been deprecated for a year or two. Here's an article talking about its deprecation and its relatively nonfunctional replacement: wdutil https://www.intuitibits.com/2024/03/14/goodbye-airport/

Fair point

> 2025-06-06 - Vendor confirms that the No-JS username recovery form has been fully deprecated

So Google's solution to this is to force JS usage for username recovery. Wow good job team /s

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.

Relevant to dave plummer: https://news.ycombinator.com/item?id=39813625

> Now, as to the tidbit. Dave Plummer ran a scam company that was sued by Washington State in 2006, "SoftwareOnline.com, Inc. ". He actually left Microsoft specifically to run this company.

> Court documents can be seen here: https://www.atg.wa.gov/news/news-releases/attorney-general-s... You can find David W. Plummer listed in the court complaint.

> The short of it is that it was an online software scam company that tricked people into downloading fake Anti-virus and security software using online ads, and then the software delivered additional adware and nagware onto users machines.

The credit freeze portion is permanently free for all 3 sites. I use it myself.

At the same time, these companies all offer other paid ‘monitoring services’ that they use heaps of dark patterns to push new users into paying for and confuse users to prevent people from finding the free ‘just security freeze’ service

Obviously within the context of this discussion, we are talking about states (in this case the EU) making laws.

As to whether or not, they have a right to make laws? I think that’s outside of the scope of this discussion because they clearly already made the law and meta isn’t challenging their right to do so.

So from the articles I can find about the complaints filed against Meta [1] I can't find any explanation of what would be an acceptable price for non-consent besides free.

I mean like it's their right as a government to say 'you can't charge for consent. either charge everyone or no-one', but I wonder how it'll all pan out.

[1](https://techcrunch.com/2024/02/28/meta-consent-or-pay-consum...)

I don't see a lot of discussion of the Meta "pay or consent" investigation. Why wouldn't giving users the option to pay for tracking-free, ad-free service meet the requirement? Is the concern that the $10/month price too high? Would this kind of model be acceptable at a more reasonable price point?

- reacting to messages/replying to messages

- sending messages over data (obviously)

Hmm still clickbaity because you don't know how it happens. Better title:

"This is the story of the most unbelievable demo I've been given in world of open source. You can't make this stuff up.

It was 2005, and I felt like I was in the eye of a hurricane. I was an independent performance consultant and Sun Microsystems had just released DTrace, a tool that could instrument all software. This gave performance analysts like myself X-ray vision. While I was busy writing and publishing advanced performance tools using DTrace (my open source DTraceToolkit and other DTrace tools, aka scripts), I noticed something odd: I was producing more DTrace tools than were coming out of Sun itself. Perhaps there was some internal project that was consuming all their DTrace expertise?

DTraceToolkit v0.96 tools (2006) As I wasn't a Sun Microsystems employee I wasn't privy to Sun's internal projects. However, I was doing training and consulting for Sun, helping their customers with system administration and performance. Sun sometimes invited me to their own customer meetings and other events I might be interested in, as a local expert. I was living in Sydney, Australia.

This time I was told that there was a Very Important Person visiting from the US whom I'd want to meet. I didn't recognize the name, but was told that he was a DTrace expert and developer at Sun, and was on a world tour demonstrating Sun's new DTrace-based product. Ah-hah – this must be the internal project!

But this would be no ordinary project. I'd seen some amazing technologies from Sun, but I'd never seen a developer on a world tour. This was going to be big, and would likely blow away my earlier DTrace work.

The VIP was returning to Sydney for a few days before going to the next Australian city, so we agreed to meet at the Sun Sydney office.

...

This would need to account for how much more or less of the chemical that the person consumes (e.g. children would likely drink proportionately less water all things considered)

I created a Roku remote for macOS. Before I made the app, there was 50 iOS remote apps but none of them had a native macOS version. For a while I used the testing client that I found on Roku’s developer site, but it didn’t have volume buttons.

Building it gave me a chance to learn modern iOS dev and SwiftUI. And I even had a bit of fun playing around with audio streaming protocols to get the private listening feature working!

https://apps.apple.com/us/app/roam-a-better-remote-for-roku/...

Some Minecraft servers will attempt to detect modded Minecraft clients, potentially based off of how they handle the protocol or mechanics. If this re-implementation has accidental differences from the main Minecraft client, it could potentially get detected as a malicious cheating client and banned.

22K * 45560 / 100 = 10023200

This is the right takeaway honestly. I was hoping a comment like this would be the top comment, but unfortunately hackernews loves this kind of bait

Its doing that to get a static str (no allocations). I assume it is for performance reasons, but I can’t speak to whether it’s actually a significant impact.

Not just most. All but one strongly supported hypothesis

One quick google away:

> Can I really pay with cash?

> You bet, and please! Stay anonymous all the way. Just put your cash and payment token (randomly generated on our website) in an envelope and send it to us. We accept the following currencies: EUR, USD, GBP, SEK, DKK, NOK, CHF, CAD, AUD, NZD.

https://mullvad.net/en/pricing/