PostgreSQL index fundamentals
When an index helps, when it hurts, and how to read an EXPLAIN without guessing.
An index is not decoration on a large table: it is a structure the planner may choose to ignore. Understanding when it makes that call is worth more than memorising index types.
In the final build the article body comes from PostgreSQL as semantic HTML, server-rendered so crawlers read the full text without depending on the 3D layer.
The article view drops the constellation effects and prioritises reading: 60 to 72 character measure, 1.78 line height, contrast above 4.5:1. The origin star stays noted in the footer so the reader keeps their place on the timeline.
On close, the camera returns to the exact point it left from, with no constellation reload.