James on Programming

Technique to centrally rate-limit access to resources to at most once per an arbitrary interval.

Postgresql has built-in types and features allowing you to do basic geospatial work — storing and querying by latitude / longitude boxes and / or K-nearest neighbors without swallowing the added complexity of PostGIS.

Postgresql 11 now supports arrays of domains, but query projections may surprise your application code. This can be worked around in Python’s psycopg2 driver by registering custom type adaptors.