Recent submissions

Comment · 5 months ago
Comment · 1 year ago
”I think GPT-5 is the closest to AGI we’ve ever been”

Sorry, but this sounds like overly sensational marketing speak and just leaves a bad taste in the mouth for me.

Comment · 1 year ago
Comment · 1 year ago
To some people the process leading to a finished project is the most interesting thing about posts like these.
Comment · 1 year ago
I’d like to add: Programs should not add files to your home directory and should respect XDG_CONFIG_HOME and friends.
Comment · 1 year ago
Awesome! Thanks for sharing. It feels good to have some company in this, I will follow your progress!

I created a repo for my solutions here: https://github.com/lyxell/aoc2024-sqlite

Update: Wow. Reading your solutions was a real eye-opener for me. It never struck me that one can exploit the fact that unmaterialized CTE's will not be evaluated for rows that is not needed by another SELECT and one can use this the same way one uses laziness in Haskell. This is great stuff, thanks again for sharing!

Comment · 1 year ago
I’m allowing myself to convert the data to a csv and read it using ’.mode csv’.

I realized when solving todays problem that SQLite’s

  json_each("[" || T.c1 || "]")
Is useful for parsing comma separated rows into (row, col)-pairs as well.
Comment · 1 year ago
I’m using sqlite this year. Hoping that there won’t be any computational geometry or trie problems. Kind of hoping for a graph problem solvable with recursive CTEs, that would be cool.
Comment · 1 year ago
The API looks really nice and intuitive! What motivated you to build this?
Comment · 2 years ago
Comment · 2 years ago
I’ve used both standalone esbuild as well as Vite for hundreds of hours and HMR works flawlessly in React using Vite, it’s the only reason I use Vite instead of just using esbuild directly. I suggest you to try it out.

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton