Group world cities by timezone
A simple example of how to group world cities by timezone
PostgreSQL
Released pg-tzf: High-Performance Lat/Lon → Time Zone PostgreSQL Extension
Developed and released pg-tzf, a PostgreSQL extension providing microsecond-level latitude/longitude to time zone conversion, based on the Rust library tzf-rs and the pgrx framework.