Top posts

Every blog post that took off on Hacker News, ranked by the votes of its best submission. 6,153 posts.

Any topic
2022
781

Postgres 15 improves UNIQUE and NULL

Postgres 15 beta 2 was released recently! I enjoy Beta season... reviewing and testing new features is a fun diversion from daily tasks. This post takes a look at an improvement to UNIQUE constraints on columns with NULL values . While the nuances of unique constraints are not as flashy as making sorts faster (that's…

796

Isometric Pixel Art

Intro Isometric pixel art is based on the isometric projection, which is a method for accurately ‘projecting’ 3D objects into fancy 2D. Unlike perspective drawing, there is no vanishing point in isometric projection. Furthermore, the 3 coordinate axis have equal foreshortening, eliminating the need