Hacker News: ellisv

New comment by ellisv in "American importers and consumers bear the cost of 2025 tariffs: analysis"

ellisv — Mon, 19 Jan 2026 17:12:16 +0000

It's called the nondelegation doctrine, which forbids one branch of government from authorizing another branch of government to exercise its functions.

Because Article One vests "all legislative powers" to Congress, they cannot delegate legislative powers to the Executive and Judicial branches (because then not all legislative powers would be vested with Congress).

New comment by ellisv in "Avoid UUID Version 4 Primary Keys in Postgres"

ellisv — Mon, 15 Dec 2025 15:11:33 +0000

About 10 years ago I remember seeing a number of posts saying "don't use int for ids!". Typically the reasons were things like "the id exposes the number of things in the database" and "if you have bad security then users can increment/decrement the id to get more data!". What I then observed was a bunch of developers rushing to use UUIDs for everything.

UUIDv7 looks really promising but I'm not likely to redo all of our tables to use it.

New comment by ellisv in "Using Git add -p for fun (and profit)"

ellisv — Sun, 14 Dec 2025 14:42:22 +0000

also barely readable with dark mode

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

ellisv — Fri, 12 Dec 2025 15:12:39 +0000

I wish devs would normalize their data rather than shove everything into a JSON(B) column, especially when there is a consistent schema across records.

It's much harder to setup proper indexes, enforce constraints, and adds overhead every time you actually want to use the data.

New comment by ellisv in "Python Data Science Handbook"

ellisv — Tue, 02 Dec 2025 14:57:14 +0000

These types of books are always interesting to me because they tackle so many different things. They cover a range of topics at a high level (data manipulation, visualization, machine learning) and each could have its own book. They balance teaching programming while introducing concepts (and sometimes theory).

In short I think it's hard to strike an appropriate balance between these but this seems to be a good intro level book.

New comment by ellisv in "Advent of Code 2025"

ellisv — Sun, 30 Nov 2025 13:53:42 +0000

I never liked the global leaderboard since I was usually asleep when the puzzles were released. I likely never would have had a competitive time anyway.

New comment by ellisv in "Migrating to Positron, a next-generation data science IDE for Python and R"

ellisv — Fri, 28 Nov 2025 12:17:11 +0000

The IDE has been available for awhile.

New comment by ellisv in "WeatherNext 2: Our most advanced weather forecasting model"

ellisv — Mon, 17 Nov 2025 21:09:14 +0000

Precip.ai or go grab the MRMS data yourself

New comment by ellisv in "Ask HN: Is GitHub down for you as well?"

ellisv — Thu, 13 Nov 2025 14:58:51 +0000

We can't pull/push to our repos

    git@github.com: Permission denied (publickey).
    fatal: Could not read from remote repository.
    
    Please make sure you have the correct access rights
    and the repository exists.

New comment by ellisv in "Apple reports fourth quarter results"

ellisv — Fri, 31 Oct 2025 21:36:21 +0000

For tasks like planning travel I often am trying to optimize multiple goals at once. I might find cheaper flights on certain days but more expensive hotels. This is much easier on larger screens because you can view more information side by side.

New comment by ellisv in "Using AI to negotiate a $195k hospital bill down to $33k"

ellisv — Tue, 28 Oct 2025 18:58:22 +0000

The most impressive part to me is finding the right channel to communicate with the hospital. We had to dispute a billing issue with our hospital and it simply wasn't possible to talk to any person that wasn't part of the "patient relations" team. Billing problems went through patient relations who talked to the billers.

New comment by ellisv in "American solar farms"

ellisv — Mon, 13 Oct 2025 13:19:23 +0000

> Also, the rainfall. Some farmers go from morning to night never saying a word that isn't a complaint about the rainfall being wrong.

Yes. Some of them use proper rain gauges but some just complain about it. Basically none of them understand the difference between a point measurement and an areal average estimate.

New comment by ellisv in "We will no longer be actively supporting KuzuDB"

ellisv — Sun, 12 Oct 2025 18:03:48 +0000

With property graphs being adopting in the SQL standard, this isn’t surprising.

New comment by ellisv in "Does our “need for speed” make our wi-fi suck?"

ellisv — Sat, 11 Oct 2025 00:08:45 +0000

MoCA is how I get Ethernet upstairs. Works great.

New comment by ellisv in "Self hosting 10TB in S3 on a framework laptop and disks"

ellisv — Sun, 05 Oct 2025 15:19:35 +0000

Plants look very portable

New comment by ellisv in "LoRA Without Regret"

ellisv — Fri, 03 Oct 2025 22:57:05 +0000

I also mistook it to be about LoRa and not about LoRA

New comment by ellisv in "Walking Michigan City (Indiana)"

ellisv — Tue, 23 Sep 2025 14:07:37 +0000

Indiana Dunes National Park is weird and only became a national park because Pence was VP.

New comment by ellisv in "Teardown of Apple 40W dynamic power adapter with 60W max"

ellisv — Sun, 21 Sep 2025 19:43:20 +0000

This is good to know!

I might use these in my basement remodel since I can easily install deeper boxes. A right angle connector cable would also solve the issue of the port direction.

New comment by ellisv in "Teardown of Apple 40W dynamic power adapter with 60W max"

ellisv — Sun, 21 Sep 2025 19:35:28 +0000

The IKEA SJÖSS has ports on the front face rather than down or side.

New comment by ellisv in "Teardown of Apple 40W dynamic power adapter with 60W max"

ellisv — Sun, 21 Sep 2025 15:50:15 +0000

I wish they'd discount their 35W dual port chargers or that I could find a similar 3rd party charger.

My main criteria are (1) dual USB-C ports to charge multiple devices in one location, (2) compact enough to not block the other receptacle, and (3) ports face down/to the side so can fit between the wall and furniture. Unfortunately most chargers fail at least one of these.