Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
aidos
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
10 ms
·
91.
▲
by
aidos
2y ago
I suspect that a certain amount of confusion here stems from English not being the author’s native language, but this isn’t a great read. If you’re working with Postgres you owe it to yourself to understand how to read query planner output.
92.
▲
by
aidos
2y ago
Well there’s the trolley dilemma up close and personal. I imagine those out there in the field have to think about this a lot more than the rest of us. Edit: removed link as was tangentially related
93.
▲
by
aidos
2y ago
When we built our frontend sync system we tried a few different options. We had a fairly simple case of just trying to store entities so we could pull incremental updates since you were last online. The one we ran in production for a while
94.
▲
by
aidos
2y ago
Just skimmed the article but my guess is that it’s a dream type experience where if you turned around 180 and walked the other direction it wouldn’t correspond to where you just came from. More like an infinite map.
95.
▲
by
aidos
2y ago
I’ve been playing around recently trying to do a bit of refactoring work with copy pasting in Claude and using Cursor. This week I tried a task where I had a small script that used jquery (one Ajax call and a bunch of dom manipulations). I
96.
▲
by
aidos
2y ago
I think really, like your parent said, people charge them at home. In the UK, energy providers have plans where they schedule charging overnight so it costs next to nothing. It costs about £10 / month for a family vehicle that gets dai
97.
▲
by
aidos
2y ago
Good and better by which metrics? Different people have different requirements.
98.
▲
by
aidos
2y ago
I love debugging Python. The stacktraces are great when logged through Sentry so even on production I can normally spot the bug immediately. On my local machine it’s even better because I can run the code, let it break and then jump straigh
99.
▲
by
aidos
2y ago
The updates wouldn’t be in place anyway because of the Postgres mvcc approach, right? I can see the advantage in terms of just needing a single tuple for a reads. So a timestamp + value model would likely take twice as much heap space than
100.
▲
by
aidos
2y ago
Yeah, that was about the same time when I saw them. From memory they just looked like your standard 3 piece but had those lovely backwards sounding swells. I recall being really surprised because it sounds like the sort of thing you’d strug
101.
▲
by
aidos
2y ago
Man, those two first Ratatat albums had such a great sound. I’m not quite sure how they created it but I saw them play in a little club in London and it was every bit as full and textured as on the albums. I have a recording of the gig some
102.
▲
by
aidos
2y ago
Config file here with a couple of lines to add it to ipython automatically. https://github.com/aidos/dotfiles/blob/master/_config/ipytho...
103.
▲
by
aidos
2y ago
Even though I don’t use Dart myself I very much approve of this initiative. I live in my Python REPL (ipython) and I couldn’t live without my hot reloading without losing state. Allows for hacking about a bit directly in the REPL. Once some
104.
▲
by
aidos
2y ago
“Tailscale takes over port 22 for SSH connections incoming from the Tailscale network ”
105.
▲
by
aidos
2y ago
I’m based in the uk now so don’t get to Auckland all that often anymore! Have seen quite a few clips of SailGP but am yet to watch a full race. Will give it a bit more of a look.
106.
▲
by
aidos
2y ago
I believe the power is used to control the wing (sail) and the foils. These boats don’t have a keel and instead rely on foils that they drive into the water. I think they’re adjusted constantly as they fly and they swap from side to side
107.
▲
by
aidos
2y ago
As a kiwi that lived through the Americas cup challenges of the 90s the sport is pretty close to my heart. These boats are amazing and I’ve been following along this year but it’s the first time I’ve found it harder to connect. Now the team
108.
▲
by
aidos
2y ago
Sure! I've created a gist so you can see for yourself but the basic idea is as described. Read a chunk, find the first date in it and then decide if you want to read further forward or back in the file. https://gist.github.c
109.
▲
by
aidos
2y ago
sed, awk, grep and friends are just so effective at trawling through text. I dump about 150GB of Postgres logs a day (I know, it's over the top but I only keep a few days worth and there have been several occasions where I was saved by
110.
▲
by
aidos
2y ago
Good for them. I think I got old because I don’t entirely understand why someone would put themselves through hosting and policing an open file storage system in 2024.
111.
▲
by
aidos
2y ago
No. That’s the point of tailwind. You can include things like hover states. Inline css hits a roadblock there and you’re forced to go out to a style tag. Then you have to start naming things. Then you risk conflicts. That’s the problem ta
112.
▲
by
aidos
2y ago
I disagree with the main motivations and benefit. For me it’s always been about being able to handle hover states etc without having to leave the local context where I’m working. I don’t think anyone can really write tailwind without unders
113.
▲
by
aidos
2y ago
To be honest I don’t quite recall the history anymore and no doubt the place we were at was late with adoption. My first day they said “congratulations, you’ve just inherited 3 million lines of confusion”
114.
▲
by
aidos
2y ago
I ended up doing cf almost by accident for quite a while (like, 8 years) and was there as it went through the adobe -> railo transition. Coldfusion had a bad rep but it was actually a pretty good tool to work with. Railo made it a millio
115.
▲
by
aidos
2y ago
Gotcha. Thanks. That’s actually super useful! Looks like Postgres doesn’t implement it unfortunately. I revert to “group by 1, 2, 3… “ when I’m just hacking about. Group by all would definitely be an improvement.
116.
▲
by
aidos
2y ago
Ability to survive != intelligence Off the back of this comment I’ve just flicked back to a random video of my then 2 yo where we have a discussion about how houses in real life aren’t normally the colour of the ones in the kids book she’s
117.
▲
by
aidos
2y ago
What’s group-by-all? Sounds like distinct?
118.
▲
by
aidos
2y ago
Mutool is the one I suggest to people. The easiest way to understand a PDF is to decompress it and then just read the contents. mutool clean -d in.pdf out.pdf At that point you’ll realise that a PDF is mostly just a list of objects
119.
▲
by
aidos
2y ago
Exactly. Depending on where you live it’s hard to impossible to get permission to go above the existing ridgeline of the house, leaving people to poke flat roof dormers out the side. Flat roofs don’t have to leak. I’m doing an EPDM roof o
120.
▲
by
aidos
2y ago
Golly, QUALIFY, a new SQL operator I didn’t know existed. I tend not to do much with window functions and I would have reached for a CTE instead but it’s always nice to be humbled by finding something new in a language you thought you knew
More ›