waldo
Simple forward/reverse geocoder for WhosOnFirst admin data
Star 0
Fork 0
Watch

Version history of sql/load.sql

May 2026

scooter
use Lit to compose SQL files, use full country name, drop continent + country from hierarchy, fix tests
committed
scooter
fix plus geocoding, add dedupe to load function
committed
scooter
add reverse benchmark (no index), cut load times by switching to point instead of centroid
committed
scooter
add prefix index, 5X benchmark improvement
committed
scooter
add country field with ISO 2-letter
committed
scooter
reduce memory consumption by factor of 9X, performance up 5X
committed
scooter
reduce size of in memory table, reduce memory consumption about 2GB
committed