Ask HN: What are you working on? (February 2025)
541–550 of 922 posts
Re: Ask HN: What are you working on? (February 2025)
#542Re: Ask HN: What are you working on? (February 2025)
#543Turns out the whole app needs only ~ 10 SQL requests, and it's way funier to write modern SQL than fighting the ORM.
The new code looks like this :
db_message = Model.save_new_message!(@conf.db, DbButler::Hn, item, DbState::Processing)
Than I have a Model module with all the interactions with the DB def self.save_new_message!(db, butler, external_id, state) : Message
sql = {{ read_file "./db/save_new_message.sql" }}
db.query_one(sql, butler.to_s.downcase, external_id, state.to_s.downcase, as: Message)
end
(thanks to Crystal ability to read a file at compile time - I can write raw SQL in a file with syntax highlithing and maybe typesafe if I connect the DB to the editor)The land page is not ready, but the bot has been working for me for months https://newsbutler.xyz/
Re: Ask HN: What are you working on? (February 2025)
#544Re: Ask HN: What are you working on? (February 2025)
#545Plus I having fun plugging it all into ChatGPT and reading the stories it comes up with.
Re: Ask HN: What are you working on? (February 2025)
#546I recently made a little tool for people interested in running local LLMs to figure out if their hardware is able to run an LLM in GPU memory. https://canirunthisllm.com/
Feature request: I would like to know if I can run _any_ LLms on my machine, and if so, which.
Generally speaking models seem to be bucketed by param count (3b, 7b, 8b, 14b, 34b, 70b) so for a given VRAM bucket you will end up being able to run 1000's of models - so is it valuable to show 1000s of models?
My bet is "No" - and what really is valuable is like the top 50 trending models on HuggingFace that would fit in your VRAM bucket. So I will try build that.
Would love your thoughts on that though - does that sound like a good idea?
Re: Ask HN: What are you working on? (February 2025)
#547Now i´m trying to port to Cython to make as fast as possible. Here o3 is almost useless, but I´m progressing.
Re: Ask HN: What are you working on? (February 2025)
#548I recently made a little tool for people interested in running local LLMs to figure out if their hardware is able to run an LLM in GPU memory. https://canirunthisllm.com/
This looks closed source, am I correct?
When it comes to "how to do the math" this repo was my starting point: https://github.com/Raskoll2/LLMcalc
Re: Ask HN: What are you working on? (February 2025)
#549A tool For logistics and container planning and movers: LLM driven 3d packing written in F# https://3dpack.ing
Re: Ask HN: What are you working on? (February 2025)
#550Over at macos9lives.com a group of hackers figured out a way to get Mac OS 9 running on these late model G4s that previously never supported it. That combined with an SSD upgrade makes them close to the fastest machines that can run Mac OS 9.
I’ve taken advantage of this hack, now having sold about 80 -90 machines. But I’ve hit a wall with finding ways to advertise it. eBay has been okay. I tried Reddit Ads on the vintage Apple subreddit and they were so so—probably lost money doing it but got the word out. Google Search ads have surprisingly been ineffective. I’ve posted on various vintage Mac forums but they don’t allow formal advertising (otherwise I would buy it). I probably will try Facebook ads next. Open to other advertising ideas!