Hacker News: sceadu

New comment by sceadu in "We Mapped Rural Data Center Development – and Opposition"

sceadu — Thu, 09 Jul 2026 17:29:32 +0000

by concentrating the load into a single location like that, you would likely overload the transmission system at that location and trigger a ton of system upgrades. so they would likely need to build their own generation and still probably upgrade lines if they just took over a county.

New comment by sceadu in "DuckDB Internals Part 1"

sceadu — Fri, 19 Jun 2026 14:57:54 +0000

I really hate SQL as a language for doing data-related tasks, but the core tech for it is often much better in terms of reliability (and is close to having performance parity IME)... specifically for working with larger-than-memory datasets. I think the team at Polars is working on improving larger-than-memory operations though.

New comment by sceadu in "DuckDB Internals: Why Is DuckDB Fast? (Part 1)"

sceadu — Fri, 19 Jun 2026 14:53:37 +0000

In my experience it works OK with spilling to disk so I haven't had too much of a concern with memory usage... previously I had issues with it OOM'ing and failing (or maybe this was a skill issue?), but haven't had that happen recently.

New comment by sceadu in "Learn SQL Once, Use It for 30 Years"

sceadu — Fri, 05 Jun 2026 15:27:19 +0000

the I in ACID stands for isolation, not idempotency

New comment by sceadu in "Boris Cherny: TI-83 Plus Basic Programming Tutorial (2004)"

sceadu — Thu, 07 May 2026 19:22:56 +0000

I'm a TI guy, but really like RPN and there is (was?) an excellent RPN package for the TI-89 https://old.reddit.com/r/calculators/comments/fdytes/lars_fr...

New comment by sceadu in "Pandas Exercises for Data Analysis (Interactive)"

sceadu — Wed, 18 Mar 2026 15:46:38 +0000

also I would recommend looking at videos from matt harrison for polars or pandas, e.g.:

https://www.youtube.com/watch?v=Z9ekw2Ou3s0

New comment by sceadu in "Programming in K"

sceadu — Mon, 02 Mar 2026 21:58:50 +0000

dang I had no idea you wrote the asof join for pandas. thank you for that

New comment by sceadu in "What's New in Python 3.15"

sceadu — Sun, 21 Dec 2025 21:31:35 +0000

I usually do REPL driven development in Python via emacs but you can tell it's not the natural way to do things, esp. if you start doing stuff with async. But I still feel that it makes me way more productive than I would otherwise be

New comment by sceadu in "IBM to acquire Confluent"

sceadu — Tue, 09 Dec 2025 00:38:02 +0000

Always Increasing

New comment by sceadu in "Microsoft Python Driver for SQL Server"

sceadu — Wed, 17 Sep 2025 16:58:01 +0000

You might be able to do it with ibis. Don't know about the performance though

New comment by sceadu in "Using Emacs Org-Mode With Databases: A getting-started guide"

sceadu — Fri, 12 Sep 2025 19:24:35 +0000

I also use: https://github.com/kostafey/ejc-sql for stuff not natively supported by sql-mode in emacs FWIW

New comment by sceadu in "Ask HN: What trick of the trade took you too long to learn?"

sceadu — Mon, 04 Aug 2025 20:55:26 +0000

not sure if it counts as a list of case studies, but a relevant and recent video nonetheless https://www.youtube.com/watch?v=KZeIEiBrT_w

also in general bayesian statistics

random medium article: https://medium.com/pythoneers/monte-carlo-simulation-ideas-a...

New comment by sceadu in "The beauty entrepreneur who made the Jheri curl a sensation"

sceadu — Wed, 16 Jul 2025 16:20:08 +0000

Comment history says yes to your second point

New comment by sceadu in "Analyzing database trends through 1.8M Hacker News headlines"

sceadu — Fri, 11 Jul 2025 13:36:11 +0000

relevant GH issue I think

https://github.com/ClickHouse/ClickHouse/issues/29693

New comment by sceadu in "TSA to end shoes-off policy for airport security screening"

sceadu — Tue, 08 Jul 2025 16:13:37 +0000

trickle down economics?

New comment by sceadu in "An illustrated guide to Amazon VPCs"

sceadu — Thu, 05 Jun 2025 17:10:56 +0000

are you planning on turning this into a book also? if so I'd be interested. the blog posts were very helpful :)

New comment by sceadu in "When memory was measured in kilobytes: The art of efficient vision"

sceadu — Thu, 05 Jun 2025 13:45:35 +0000

Don't know about radar but here's a good book on classical CV https://udlbook.github.io/cvbook/

even though I think Simon admits that most of it is obsolete after DL computer vision came about

New comment by sceadu in "I created Perfect Wiki and reached $250k in annual revenue without investors"

sceadu — Wed, 30 Apr 2025 15:01:09 +0000

Seems like you're unfamiliar with enterprise IT

New comment by sceadu in "Widespread power outage in Spain and Portugal"

sceadu — Mon, 28 Apr 2025 17:46:28 +0000

> But with solar, how is the synchronization provided? In like a giant buck? Or in software somehow? Does the phase shift matter as much as in the electromechanical systems?

If you mean how does solar detect phase and synchronize to the grid: https://en.wikipedia.org/wiki/Phase-locked_loop

If you mean how does solar act to reinforce the grid: search for terms like "grid forming inverter vs. grid following inverter" though not all generators are the same in terms of how much resilience they add to the grid, esp. w.r.t. the inertia they do or do not add. See e.g. https://www.greentechmedia.com/squared/dispatches-from-the-g...

New comment by sceadu in "Calendar.txt"

sceadu — Sat, 01 Mar 2025 14:33:57 +0000

https://en.m.wikipedia.org/wiki/Clock_of_the_Long_Now