Hacker News: jelder

New comment by jelder in "90% of Claude-linked output going to GitHub repos w <2 stars"

jelder — Thu, 26 Mar 2026 12:02:26 +0000

Who goes out of their way to “star” a GitHub repo, and what does that even mean? Is it a “like” button, a tip jar, or a bookmark? Does this bare any relationship to the importance, quality, novelty, trustworthiness, or any other property of the repo other than number of stars?

What a dumb metric to focus on.

New comment by jelder in "We give every user SQL access to a shared ClickHouse cluster"

jelder — Sat, 21 Mar 2026 12:42:15 +0000

We did this with MotherDuck, and without introducing a new language. Every tenant has their own isolated storage and compute, so it’s trivial to grant internal users access to specific tenants as needed. DuckDB’s SQL dialect is mostly just Postgres’ with some nice ergonomic additions and a host of extra functionality.

New comment by jelder in "Nearby Glasses"

jelder — Wed, 25 Feb 2026 14:51:15 +0000

It would be a shame if somebody modified this to trigger Bluetooth and Wi-Fi deauthentication attacks.

New comment by jelder in "Pipelined Relational Query Language, Pronounced "Prequel""

jelder — Mon, 23 Feb 2026 16:31:03 +0000

DuckDB had the right idea: just allow some flexibility in the relative order of the `select` and `from` clauses, and make a few other concessions for ergonomics. This then becomes valid:

    from events      -- table is first, which enables autocomplete
    select
        count(),     -- * is implied, easier to type
        customer_id, -- trailing commas allowed everywhere
    group by all     -- automatically groups by all non-aggregate columns
    order by all     -- orders rows by all columns in selected order

https://duckdb.org/docs/stable/sql/dialect/friendly_sql

New comment by jelder in "Testing Ads in ChatGPT"

jelder — Mon, 09 Feb 2026 19:30:44 +0000

You can't trust a product that uses ads, because then you are the product.

New comment by jelder in "We tasked Opus 4.6 using agent teams to build a C Compiler"

jelder — Fri, 06 Feb 2026 13:09:16 +0000

If you were to rank all of the C compilers in the world and then rank all of the welfare systems in the world, this vibe-coded mess would be at approximately the same rank as the American welfare system. Especially if you extrapolate this narcissistic, hateful kleptocracy out a few more years.

New comment by jelder in "Show HN: Teemux – Zero-config log multiplexer with built-in MCP server"

jelder — Fri, 23 Jan 2026 19:57:11 +0000

Couldn't coding agents just run `tail -f *`?

New comment by jelder in "enclose.horse"

jelder — Wed, 07 Jan 2026 13:28:10 +0000

Indie games don’t have a budget for playtesting, but they can probably swing a GA account.

New comment by jelder in "High-Performance DBMSs with io_uring: When and How to use it"

jelder — Tue, 06 Jan 2026 23:49:58 +0000

I just today realized io_uring is meant to be read as "I.O.U. Ring" which perfectly describes how it works.

New comment by jelder in "Dude, where's my supersonic jet?"

jelder — Tue, 06 Jan 2026 19:51:48 +0000

eTAXI is just one such solution

https://www.safran-group.com/videos/e-taxi-safran-unveils-it...

New comment by jelder in "Dude, where's my supersonic jet?"

jelder — Tue, 06 Jan 2026 19:50:05 +0000

> You’re already flying this route with a 300-seat plane where 80+ people in business class generate most of your profit. Give those passengers a supersonic plane, cut the flight time in half, and charge the same price.

What does that end up doing to the cost of a seat in coach?

New comment by jelder in "Ruby website redesigned"

jelder — Mon, 22 Dec 2025 00:36:24 +0000

Haven’t seen a loading progress spinner on a landing page in a while. The Ruby website now loads almost as slowly as Ruby on Rails boots up.

New comment by jelder in "MIT professor shot at his Massachusetts home dies"

jelder — Tue, 16 Dec 2025 22:38:47 +0000

“Most people” is not even remotely accurate.

New comment by jelder in "SQLite JSON at full index speed using generated columns"

jelder — Fri, 12 Dec 2025 16:25:47 +0000

The necessity of using a JSON column was outside of my control, but Zod etc. are absolutely required, I think, in most projects. I wrote more about that here: https://www.jacobelder.com/2025/01/31/where-shift-left-fails...

New comment by jelder in "SQLite JSON at full index speed using generated columns"

jelder — Fri, 12 Dec 2025 16:23:26 +0000

That works for lookups but not for foreign key constraints.

New comment by jelder in "SQLite JSON at full index speed using generated columns"

jelder — Fri, 12 Dec 2025 14:44:24 +0000

I thought this was common practice, generated columns for JSON performance. I've even used this (although it was in Postgres) to maintain foreign key constraints where the key is buried in a JSON column. What we were doing was slightly cursed but it worked perfectly.

New comment by jelder in "The Nerd Reich – Silicon Valley Fascism and the War on Democracy"

jelder — Thu, 27 Nov 2025 11:59:58 +0000

The purpose of software is to reduce the cost of change.

Of course “code” belongs here.

New comment by jelder in "RegreSQL: Regression Testing for PostgreSQL Queries"

jelder — Fri, 14 Nov 2025 15:19:25 +0000

Underrated point.

Looking for performance issues on a machine with different baseline IO and CPU load, buffer state, query plans, cardinality, etc. is just theater and will lead to a false sense of security. RegreSQL is approaching a stateful problem as if it were stateless and deterministic. A linter like https://squawkhq.com is a good partial solution but only addresses DDL problems.

RegreSQL would be better served by focusing only on the aspects of correctness that tools like SQLx and sqlc fundamentally cannot address. This is a real need that too few tools try to address.

New comment by jelder in ".NET 10"

jelder — Wed, 12 Nov 2025 13:10:29 +0000

Using the right language for the problem domain is a good thing, but what I can't stand is when people self-identify as the one language they are proficient in. Like, "I'm Staff JavaScript developer" no buddy, you aren't "Staff" anything if you only know one language.

New comment by jelder in "Tell HN: X is opening any tweet link in a webview whether you press it or not"

jelder — Tue, 04 Nov 2025 15:55:06 +0000

My recollection is that this happened pretty much immediately after Twitter became X.