News for hackers. Stuff that matters.

winslett

Re:Postgres Calculations and the Ambiguity of Null on Sunday September 06, 2026 @11:25AM (#49587424)
All the ways people encounter chaos when encountering unexpected NULL values.
Re:British Columbia, Time Zones, and Postgres on Tuesday June 23, 2026 @02:13PM (#48649013)
As the author of this blog post, your comment is overwhelmingly my favorite.
Re:Golfing Is Not Rowing on Monday December 29, 2025 @10:14AM (#46421505)
For golf, you don't try harder, you relax more. At the highest level of sports, even rowing, I suspect it's similar. Only in golf do we compare the outcome of a ball flight -- we think we row similar to professionals, but there a ton of difference, you just can't see it in the result of ball flight.

My go-to golf philosophy book is "Cheng Hsin: The Principles of Effortless Power":

> To relax, you must surrender your mind-even the notion that you have a mind. You will find that relaxing your mind is the same thing as relaxing your body. There should be no separation between your mind's activity and your feeling-awareness of bodily sensations and impulses. Feel yourself letting go so that your body isn't "held" so much--this requires doing the same thing with your mind. When you relax your tissues, nervous system, organs, the muscles around your organs, every-thing, then the energy will flow. It is this very relaxation that allows for the energy, or feeling-attention inherent in your body-being, to circulate, develop, and be utilized.

Don't know how this affects daily writing ;)

Re:3D reconstruction of the capital of the Aztec empire on Sunday February 09, 2025 @10:39AM (#42991304)
Do all of these comments seem like they are AI generated to anyone else?
Finding a business / product that actually is working is unique. When you find it, stick with it. Nothing is perfect, and shit is going to be hard, it’s just the next level of the company. Be optimistic — look for what’s working and do more of what’s working. Don’t let pessimism get routed in the way you think. All of that, and fight the urge to build first — sell first.
Re:Pgvector 0.5.0 Feature Highlights and how tos on Tuesday August 29, 2023 @08:31PM (#37316088)
You can do this with a lateral join.

SELECT * FROM A, LATERAL (SELECT * FROM B ORDER BY a.embedding <-> b.embedding LIMIT 2) AS closest_in_b ORDER BY A.id;

It’s going to have so-so performance. So, don’t hose your production server. Create a vector index on b.embedding. HNSW will be nice for this use case.

Older »