Hacker News: dankebitte

New comment by dankebitte in "CBP signs Clearview AI deal to use face recognition for 'tactical targeting'"

dankebitte — Sat, 14 Feb 2026 08:44:40 +0000

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.

New comment by dankebitte in "CBP signs Clearview AI deal to use face recognition for 'tactical targeting'"

dankebitte — Sat, 14 Feb 2026 04:14:30 +0000

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.

New comment by dankebitte in "CBP signs Clearview AI deal to use face recognition for 'tactical targeting'"

dankebitte — Sat, 14 Feb 2026 01:17:53 +0000

> 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.

New comment by dankebitte in "Cloudflare CEO: Football piracy blocks will claim lives"

dankebitte — Mon, 26 May 2025 16:12:55 +0000

> 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...

New comment by dankebitte in "Litestream: Revamped"

dankebitte — Tue, 20 May 2025 22:43:28 +0000

> 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

New comment by dankebitte in "Ditching Obsidian and building my own"

dankebitte — Mon, 19 May 2025 01:25:56 +0000

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.

New comment by dankebitte in "Ditching Obsidian and building my own"

dankebitte — Mon, 19 May 2025 00:07:16 +0000

> 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

New comment by dankebitte in "Coding without a laptop: Two weeks with AR glasses and Linux on Android"

dankebitte — Sun, 18 May 2025 02:44:49 +0000

> 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.

New comment by dankebitte in "A PostgreSQL planner semi-join gotcha with CTE, LIMIT, and RETURNING"

dankebitte — Sun, 04 May 2025 03:44:25 +0000

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

New comment by dankebitte in "AI is stifling new tech adoption?"

dankebitte — Fri, 14 Feb 2025 15:05:54 +0000

> 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...

New comment by dankebitte in "Interactive SQLite Documentation: Experiment with Queries in Real-Time"

dankebitte — Thu, 07 Mar 2024 07:22:15 +0000

> 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

New comment by dankebitte in "Big media publishers are inundating the web with subpar product recommendations"

dankebitte — Tue, 20 Feb 2024 02:10:06 +0000

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

New comment by dankebitte in "Basic proxy implementation using io_uring"

dankebitte — Sun, 18 Feb 2024 04:40:01 +0000

Anything using glommio [1].

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

New comment by dankebitte in "UUID v7"

dankebitte — Mon, 05 Feb 2024 15:15:35 +0000

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