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