Hacker News: sceadu

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

New comment by sceadu in "The Efficiency of Vim"

sceadu — Thu, 27 Feb 2025 03:47:48 +0000

the vim one is pretty irritating with input delay but the neovim one isn't too bad (the one that hooks into neovim)... at least it makes vs code tolerable enough for me so I don't bang my head against the wall when I have to use it

New comment by sceadu in "LibreOffice still kicking at 40, now with browser tricks and real-time collab"

sceadu — Thu, 13 Feb 2025 19:17:47 +0000

https://elpa.gnu.org/packages/csv-mode.html ;) (M-x csv-align-fields)

New comment by sceadu in "Homes Withstood the LA Fires. Architects Explain Why"

sceadu — Fri, 17 Jan 2025 13:34:15 +0000

the space is able to be opened up as part of the main living area https://www.youtube.com/watch?v=3oIeLGkSCMA