Hacker News: banana_giraffe

New comment by banana_giraffe in "Do you even need a database?"

banana_giraffe — Wed, 15 Apr 2026 17:51:05 +0000

DuckDB can do exactly this, once you get the API working in your system, it becomes something simple like

    SELECT \* from read_csv('example.csv');

Writing generally involves reading to an in-memory database, making whatever changes you want, then something like

    COPY new_table TO 'example.csv' (HEADER true, DELIMITER ',');

New comment by banana_giraffe in "Tinybox – A powerful computer for deep learning"

banana_giraffe — Sun, 22 Mar 2026 01:52:30 +0000

A quick benchmark using float32 copies using torch cuda->cuda copies, comparing some random machines:

    Raptor Lake + 5080: 380.63 GB/s
    Raptor Lake (CPU for reference): 20.41 GB/s
    GB10 (DGX Spark): 116.14 GB/s
    GH200: 1697.39 GB/s

This is a "eh, it works" benchmarks, but should give you a feel for the relative performance of the different systems.

In practice, this means I can get something like 55 tokens a sec running a larger model like gpt-oss-120b-Q8_0 on the DGX Spark.

New comment by banana_giraffe in "uBlock filter list to hide all YouTube Shorts"

banana_giraffe — Sun, 15 Feb 2026 05:01:19 +0000

And for those that want to get the feed URL, this little Python snippet can get the feed URL from a channel's page, either from the channel's URL itself or a video or playlist page:

https://gist.github.com/Q726kbXuN/834882f59bc921a3865272a66d...

New comment by banana_giraffe in "Total monthly number of StackOverflow questions over time"

banana_giraffe — Sun, 04 Jan 2026 00:41:23 +0000

They actually added some new question categories a while ago [1]

"Troubleshooting / Debugging" is meant for the traditional questions, "Tooling recommendation", "Best practices", and "General advice / Other" are meant for the soft sort of questions.

I have no clue what the engagement is on these sort of categories, though. It feels like a fix for a problem that started years ago, and by this point, I don't really know if there's much hope in bringing back the community they've worked so hard to scare away. It's pretty telling just how much the people that are left hate this new feature.

[1] https://meta.stackoverflow.com/questions/435293/opinion-base...

New comment by banana_giraffe in "I put a real search engine into a Lambda, so you only pay when you search"

banana_giraffe — Mon, 24 Nov 2025 17:01:24 +0000

https://docs.aws.amazon.com/lambda/latest/dg/gettingstarted-...

The default Lambda quota for all accounts is 10240 MB. I've never seen it below that (in recent memory, at least), even on fresh accounts not connected to a big org.

I know I routinely use 10gb of RAM for my account that's never talked to support for the related CPU allocation.

New comment by banana_giraffe in "Steam Frame"

banana_giraffe — Thu, 13 Nov 2025 01:14:44 +0000

Reminds me of Apple's AWDL, a similar workaround for crappy networks when the devices need a high speed low latency network. I do wonder if the headset here will do similar channel hoping tricks to join both the dongle's network and the normal wifi network.

New comment by banana_giraffe in "Nepal picks a new prime minister on a discord server days after social media ban"

banana_giraffe — Sat, 13 Sep 2025 07:38:04 +0000

Gift link:

https://www.nytimes.com/2025/09/11/world/asia/nepal-protest-...

New comment by banana_giraffe in "Anthropic Agrees to Pay $1.5B to Settle Lawsuit with Book Authors"

banana_giraffe — Fri, 05 Sep 2025 19:30:40 +0000

Gift link:

https://www.nytimes.com/2025/09/05/technology/anthropic-sett...

New comment by banana_giraffe in "How to free up and automatically manage disk space for WSL"

banana_giraffe — Tue, 19 Aug 2025 05:06:39 +0000

https://gist.github.com/Q726kbXuN/c80028aa1714032546d3b442c1...

Nope, they don't eat up space. One of the fun side effects of sparse files on NTFS is calling WriteFile on the sparse file can lead to an ERROR_DISK_QUOTA_EXCEEDED error, which applications tend to not expect.

New comment by banana_giraffe in "Grok Has Been Suspended"

banana_giraffe — Mon, 11 Aug 2025 19:11:34 +0000

It was briefly suspended:

https://imgur.com/a/NZ4aK60

New comment by banana_giraffe in "The Game Genie Generation"

banana_giraffe — Tue, 22 Jul 2025 00:55:26 +0000

Not quite. The Game Genie presented a UI before the game started where you could enter codes. These codes were basically patches to the game's ROM. When the game ran, the Game Genie would intercept the requests for the bytes of ROM based off your code and replace them with a different value.

There was a prototype of a more advanced model that would be closer to what you're describing, but it never made it to market.

New comment by banana_giraffe in "Linda Yaccarino is leaving X"

banana_giraffe — Wed, 09 Jul 2025 16:45:50 +0000

Gift link: https://www.nytimes.com/2025/07/09/technology/linda-yaccarin...

New comment by banana_giraffe in "Encoding Jake Gyllenhaal into one million checkboxes (2024)"

banana_giraffe — Thu, 03 Jul 2025 18:51:39 +0000

The site uses "font-size: calc(1.5vw + 1.5vh);" or some variant, for most of the sizes, which has the effect to lock the size for everything to the size of the viewport, regardless of zoom.

New comment by banana_giraffe in "OpenAI charges by the minute, so speed up your audio"

banana_giraffe — Wed, 25 Jun 2025 22:37:02 +0000

Last time I ran this at scale was a couple of months ago, so my information is no doubt out of date, but in my experience, YouTube seems less concerned about this than they are when you're grabbing lots of videos.

But that was a few months ago, so for all I know they've tightened down more hatches since then.

New comment by banana_giraffe in "OpenAI charges by the minute, so speed up your audio"

banana_giraffe — Wed, 25 Jun 2025 20:44:57 +0000

You can use yt-dlp to get the transcripts. For instance, to grab just the transcript of a video:

    ./yt-dlp --skip-download --write-sub --write-auto-sub --sub-lang en --sub-format json3

You can also feed the same command a playlist or channel URL and it'll run through and grab all the transcripts for each video in the playlist or channel.

New comment by banana_giraffe in "Show HN: Claude Code Usage Monitor – real-time tracker to dodge usage cut-offs"

banana_giraffe — Fri, 20 Jun 2025 02:53:24 +0000

Interesting, do you recall which podcast this was on?

New comment by banana_giraffe in "A leaderless NASA faces its biggest-ever cuts"

banana_giraffe — Sat, 07 Jun 2025 00:06:05 +0000

https://archive.is/JGPw9

New comment by banana_giraffe in "New study casts doubt on the likelihood of Milky Way collision with Andromeda"

banana_giraffe — Wed, 04 Jun 2025 03:48:48 +0000

https://web.archive.org/web/20140701085917/http://www.nasa.g... :

> Although the galaxies will plow into each other, stars inside each galaxy are so far apart that they will not collide with other stars during the encounter. However, the stars will be thrown into different orbits around the new galactic center. Simulations show that our solar system will probably be tossed much farther from the galactic core than it is today.

New comment by banana_giraffe in "FreeBASIC is a free/open source BASIC compiler for Windows DOS and Linux"

banana_giraffe — Sun, 18 May 2025 00:00:33 +0000

It does support "-lang qb" which is designed to specifically limit FreeBASIC to a QuickBASIC compatible dialect.

New comment by banana_giraffe in "Ports that are blocked by browsers (2023)"

banana_giraffe — Thu, 15 May 2025 22:12:15 +0000

Interestingly, they are there:

https://github.com/mozilla/gecko-dev/blob/771bc161e016e2bd1f...

(Confirmed on a recent-ish Firefox browser)

They look to have been there for at least 5 years, dunno when they were added before that.