HNHacker News
TopNewBestAskShowJobs

sceadu

156 karma · joined July 29, 2007

submissionscomments
sceadu··on VSCode's SSH Agent Is Bananas (2025)
not to tell you that it's better or worse but you might like helium if you are using ungoogled chromium
sceadu··on US diesel prices hit a record high of $5.85 on average
deal for he, heel for thee
sceadu··on We Mapped Rural Data Center Development – and Opposition
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.
sceadu··on DuckDB Internals Part 1
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.
sceadu··on DuckDB Internals: Why Is DuckDB Fast? (Part 1)
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.
sceadu··on Learn SQL Once, Use It for 30 Years
the I in ACID stands for isolation, not idempotency
sceadu··on Boris Cherny: TI-83 Plus Basic Programming Tutorial (2004)
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...
sceadu··on Pandas Exercises for Data Analysis (Interactive)
also I would recommend looking at videos from matt harrison for polars or pandas, e.g.:

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

sceadu··on Programming in K
dang I had no idea you wrote the asof join for pandas. thank you for that
sceadu··on What's New in Python 3.15
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
sceadu··on IBM to acquire Confluent
Always Increasing
sceadu··on Microsoft Python Driver for SQL Server
You might be able to do it with ibis. Don't know about the performance though
sceadu··on Using Emacs Org-Mode With Databases: A getting-started guide
I also use: https://github.com/kostafey/ejc-sql for stuff not natively supported by sql-mode in emacs FWIW
sceadu··on Ask HN: What trick of the trade took you too long to learn?
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...

sceadu··on The beauty entrepreneur who made the Jheri curl a sensation
Comment history says yes to your second point
sceadu··on Analyzing database trends through 1.8M Hacker News headlines
relevant GH issue I think

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

sceadu··on TSA to end shoes-off policy for airport security screening
trickle down economics?
sceadu··on An illustrated guide to Amazon VPCs
are you planning on turning this into a book also? if so I'd be interested. the blog posts were very helpful :)
sceadu··on When memory was measured in kilobytes: The art of efficient vision
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

sceadu··on I created Perfect Wiki and reached $250k in annual revenue without investors
Seems like you're unfamiliar with enterprise IT
sceadu··on Widespread power outage in Spain and Portugal
> 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...

sceadu··on Calendar.txt
https://en.m.wikipedia.org/wiki/Clock_of_the_Long_Now
sceadu··on The Efficiency of Vim
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
sceadu··on LibreOffice still kicking at 40, now with browser tricks and real-time collab
https://elpa.gnu.org/packages/csv-mode.html ;) (M-x csv-align-fields)
sceadu··on Homes Withstood the LA Fires. Architects Explain Why
the space is able to be opened up as part of the main living area https://www.youtube.com/watch?v=3oIeLGkSCMA
sceadu··on Advent of Code 2024 in pure SQL
for those who don't know, the author is one of the best DB researchers in the world
sceadu··on Jimmy Carter has died
He was being sarcastic
sceadu··on The Impact of Jungle Music in 90s Video Game Development
Not sure if you're making a jungle Brothers reference to Amen break reference :)
sceadu··on Overengineering a way to know if people are in my university's CS lab
I guess depending on how you open them they do indeed have the right to bear arms
sceadu··on There Was a Consultant Engineer
https://en.wikipedia.org/wiki/Charles_Proteus_Steinmetz
Page 1 of 4Next →