News for hackers. Stuff that matters.

countmora

Re:Like MS Excel, Pivot tables never die on Thursday October 16, 2025 @10:22AM (#45605718)
If you import with PowerQuery you can explicitly specify the data type for each column.
Re:Like MS Excel, Pivot tables never die on Thursday October 16, 2025 @10:19AM (#45605670)
I wish more people stop hating on Excel. It's an incredible tool with cool stuff baked in (Python support, PowerQuery, etc.). Just because some people misuse it as database or it doesn't scale well beyond a couple of 10k rows does not make it a bad product. For 90% of daily office tasks it's just fine.
Re:IMDB Terminal Browser on Monday August 18, 2025 @08:34AM (#44939871)
Don't want to be that guy, but [1] says

>Robots and Screen Scraping: You may not use data mining, robots, screen scraping, or similar data gathering and extraction tools on this site, except with our express written consent as noted below.

[1] www.imdb.com/conditions/

> "Unicode" button label way off center

Its actually the center of the button, I made a video for context: https://imgur.com/a/1Y9O8dS

> The 8/10/16 selector being off center in its own position

Might be due to the image compression, it looks fine on my MB.

Re:Spotify demonetizes all tracks under 1k streams on Monday April 08, 2024 @04:11AM (#39967363)
I think royalties from <1k streams are basically nothing anyway. Giving up the ability to distribute your music for free and reach more people would be a terrible idea.
Re:Sora: Creating video from text on Thursday February 15, 2024 @03:53PM (#39388664)
> We’re also building tools to help detect misleading content such as a detection classifier that can tell when a video was generated by Sora.

I am curious of how optimised their approach is and what hardware you would need to analyse videos at reasonable speed.

Re:*@gmail.com on Thursday August 31, 2023 @06:45AM (#37335126)
I was still curious about the exact response, therefore I see no harm in posting that.
If you have a newer macOS version on an entry Intel machine, ordinary tasks can cause a lot of fan noise. You can activate Low Power Mode [1] to reduce clock speed and therefore the fan will not be as loud. See if the reduced clock speed does not interfere with your daily tasks.

[1] https://www.howtogeek.com/771767/how-to-enable-low-power-mod...

> unfortunately the tokenizer was trained on this subreddit

Do you have a source for that or was it just an assumption?

Re:Vanilla Handbook on Tuesday March 14, 2023 @08:46PM (#35162051)
It is so frustrating when there is nothing at the top that forwards to the main page,e.g., a project name or logo.

I managed it by clicking on the How to Install guide and then on the download image link.

Re:Americans want to delete Instagram more than any other app on Wednesday March 08, 2023 @12:46PM (#35072202)
> My decision to delete Facebook is not captured in their data.

I think for some people, it is. If I want to "delete Facebook" then I want to delete my account and every data associated with it. This is often not a straight forward process because sometimes the delete account option is buried in settings, you have to contact support, fill out a form, etc. Hence a quick search will guide you through the deletion process.

Re:All the streaming boxes suck now on Tuesday March 07, 2023 @05:17PM (#35062041)
There is a bug since at least two years where Netflix streams at roughly < 480p if you have a ATV4K hooked up to a 1080p screen.
Re:Show HN: I trained an AI model on 120M+ songs from iTunes on Friday February 03, 2023 @02:03AM (#34638046)
I've spun up Hitchin' a Ride by Green Day and I think the results are quite interesting. Despite them being completely different from one another, they somehow manage to catch the vibe of certain sections of the song.

Here's the link: https://maroofy.com/songs/1159778217

Really cool project.

Re:A secret message in a Colombian song gave hostages hope on Tuesday January 03, 2023 @09:20AM (#34231620)
Just to add: The sentences start a bit after 1:30, 2:30 and 3:30 respectively.
Re:Ask HN: Where are the simple Git GUIs? on Friday November 25, 2022 @06:26AM (#33741381)
Re:How a QR code works on Wednesday September 14, 2022 @02:24PM (#32841164)
This is also greatly covered in the second edition of Charles Petzold's Code.
Re:Excel: Getting rid of everything except numbers on Sunday July 17, 2022 @08:32PM (#32133122)
So a lot of comments here suggest copying it to another application and process it there.

Two points from my side why I would not do that:

First, you can do this directly in Excel either with a regex expression in a macro [0] or PowerQuery [1].

Secondly, I don’t know about the authors example but generally if you have to do something like this the column is likely to be one out of many, i.e., part of a table. I can’t point my finger to it but I imagine there might be a lot of steps in that process that could go wrong (formatting issues, altering table scheme, etc.)

[0] https://software-solutions-online.com/vba-regex-guide/

[1] https://www.myonlinetraininghub.com/extract-letters-numbers-...

Re:The first dating app made for developers on Sunday July 10, 2022 @05:27PM (#32049225)
How did you find out that it uses stuff from other websites? Reverse image search?
Re:The most satisfying checkbox on Friday June 17, 2022 @04:55PM (#31784254)
The tile animation on your website is also really well done!
Re:Epic gives away the entire Bioshock series for free on Saturday May 28, 2022 @10:44AM (#31540729)
They once gave away GTA V for free if you set up MFA. They also did the new Tomb Raider Triology a while back.
Yes, I am under the same impression that the spam detection takes some false positives lately. Even an official government mail which was a .gov equivalent. Glad I am not the only one noticing.
Re:Move myself to inactive on Sunday December 19, 2021 @03:01AM (#29612255)
I always managed to get getter speeds using the aria2 parameter.
Re:Avy Can Do Anything on Friday December 03, 2021 @04:04AM (#29428059)
As someone who has only experience with vim and not Emacs, are there any advantages to Emacs or is it just „different“?
Re:Show HN: 4K Desktop Wallpaper Generator on Sunday November 28, 2021 @08:38AM (#29368799)
On Safari (macOS) it is as impossible to download this easy-to-download-picture as it is possible to download the impossible-to-download-picture[1] from yesterday.

[1] https://news.ycombinator.com/item?id=29358880

Re:You can't download this image on Saturday November 27, 2021 @05:13PM (#29364096)
I chuckled about this. However you can drag and drop it to your Desktop on macOS.
Re:BibTeX Tidy on Friday November 26, 2021 @01:12AM (#29347887)
First I used a VS Code extension for formatting. After getting into my thesis I switched to Zotero[1] to manage my resources. Its extension BetterBibtex[2] can export into a prettyprinted *.bib which refreshes automatically on change. Works on Zoteros subcollections too.

[1]: https://www.zotero.org

[2]: https://retorque.re/zotero-better-bibtex/

I have a similar issue with a M1 MacBook Air.

My 1440p 144 Hz monitor works fine on my Intel MacBook Pro via USB C, but the M1 MacBook can’t do more than 60fps on the same connection.

Have not found much info about it at the time either.

It won’t be a problem if you don’t know German. Everybody is at least capable of basic English so you will almost never be able to not communicate with somebody. You can take your time with learning the German basics but you can also totally live there for 1-2 years without speaking German. Australian/Irish pubs are generally hosted by people with English as their mother tongue.
Re:Ask HN: What're some great cities to live for $2k USD per month? on Wednesday September 22, 2021 @12:22PM (#28618254)
Vienna.

A great public transport system, fast-ish internet and classical culture. The budget would totally fit the lifestyle but not as cheap as Bucharest and Bratislava.

Older »