Follow your curiosity

The reading room

Conceptual desk scene with a notebook, a pressed leaf and blank cards beside a laptop.
Data, Decoded

One Order Can Become Three Rows After a Join

An orders table contains one row per order. An items table contains one row per item. Join them by order ID and an order containing three items can appear…

Conceptual desk scene with a notebook, a pressed leaf and blank cards beside a laptop.
Data, Decoded

GeoJSON Coordinates Put Longitude Before Latitude

A point can contain two perfectly valid numbers and still land on the wrong side of a map. In GeoJSON, the order of those numbers is part of the format, not…