dankebitte

A point hasn't actually been made when the sole example, presented as fact, was a partisan lie that collapsed under extremely basic scrutiny. The decision had nothing to do with this strange notion that the courts err on the side of restraining the government and everything to do with the fact the 5th Circuit [yet again] presumed an alternate reality in order to achieve a Republican policy victory.

It's simply bizarre to claim that a blatantly partisan circuit court issuing capricious restrictions on their political opposition and having them vacated by SCOTUS is evidence of "the courts" erring against "the government" generally. The decision was overturned because the plaintiffs' case was a baseless fiction that the Biden administration was ever even implicitly compelling those third parties to do anything. The plaintiffs' standing was so plainly nonexistent that even 3/6 of the majority from Kennedy v. Bremerton School District couldn't pretend there was a case. The only example that case serves is of the most Republican-allied circuit court consistently issuing garbage opinions to empower Republican administrations and reconsolidate partisan policymaking to itself during Democratic administrations.

> This is why the Biden administration had a restraining order filed against it, on account of them pressuring social media companies to ban content it didn't like. This violated the First Amendment

It's very strange of you to leave out that the extremely right-wing 5th Circuit's opinion was overturned 6-3 by SCOTUS because "pressuring social media companies to ban content" was a complete fabrication the plaintiffs failed to support whatsoever.

> dubious Russian CDNs

Are there multiple? I thought DDoS-Guard [1] had a near-monopoly on CDN services for international piracy.

[1] https://krebsonsecurity.com/2021/01/hamas-may-be-threat-to-8...

> read replicas

Can this be done with only Litestream, or is LiteVFS still in development? I looked into this last year but was put off by LiteFS's stated write performance penalty due to FUSE [1]; it's still marked as WIP [2] and hasn't seen updates for over a year.

[1] https://fly.io/docs/litefs/faq/#what-are-the-tradeoffs-of-us...

[2] https://github.com/superfly/litevfs

Not sure which page you're referencing, but the linked page states it's available for Personal (free) as well:

> Tailnet lock is available for the Personal, Personal Plus, and Enterprise plans.

> If you aren't comfortable with trusting them with control over your network

Wrt the possibility of Tailscale being compromised, there's the in-beta tailnet lock feature:

> Tailnet lock lets you verify that no node is added to your tailnet without being signed by trusted nodes in your tailnet. When tailnet lock is enabled, even if Tailscale infrastructure is malicious or hacked, attackers can't send or receive traffic in your tailnet. [1]

[1] https://tailscale.com/kb/1226/tailnet-lock

> On average I'd drain about 15% battery per hour. So 4 to 5 hours before you need to be thinking about charging, but I'm not sure you'd want to have the glasses on longer than that anyway.

I know there are splitters break a USB-C port out into a USB-PD port and a data transfer port, but can those (or a different accessory) also be used to provide PD to the phone for prolonged usage?

eta: Never mind, just saw that the XREAL Hub addresses this. I still wonder if there's a cheaper option, but most seem to be designed for PD out, not in.

It's not undefined behavior, it's the fact that the uncorrelated subquery within the CTE doesn't specify an ordering, therefore it cannot be implicitly materialized / evaluated once. Postgres documentation is clear here [1]:

> If sorting is not chosen, the rows will be returned in an unspecified order.

The original query from TFA could've instead just had the uncorrelated subquery moved into a materialized CTE.

[1] https://www.postgresql.org/docs/current/queries-order.html

> Updates to GPT-4o in ChatGPT (January 29, 2025)

> By extending its training data cutoff from November 2023 to June 2024 […]

https://help.openai.com/en/articles/9624314-model-release-no...

> Dr. Richard Hipp (the SQLite author) is one of our shareholders, and we have the right to use the SQLite name.

https://news.ycombinator.com/item?id=35251099

There's uBlacklist [1], but there's not much community activity on its subscription list [2] or awesome-ublacklist [3].

[1] https://github.com/iorate/ublacklist

[2] https://iorate.github.io/ublacklist/subscriptions

[3] https://github.com/rjaus/awesome-ublacklist

Anything using glommio [1].

[1] https://crates.io/crates/glommio/reverse_dependencies

Uniqueness aside, UUIDs for public-facing IDs also prevent enumeration attacks and leaking business information other than timestamps.