PostgreSQL

Proficient

Primary relational store, with PostGIS for geospatial scoring models.

Default database. Comfortable designing schemas, reading EXPLAIN ANALYZE, choosing index types, and reasoning about isolation levels. PostGIS backed the store-expansion scoring model after GCP proved unworkable for it.

Projects using PostgreSQL

Store-Expansion Location Scoring2024 – 2025
A location-scoring model for retail store expansion on geospatial data; migrated from H2O/Java to Python and settled on PostgreSQL/PostGIS as model engine.