blog1 post3 categories12 active topicsfiltered: search

Notes from the field.

Working notes on the craft: engineering at scale, the AI-era developer experience, frontend that most teams leave on the table, and whatever else has my attention.

Building SoberMark: twenty public datasets, one record per provider
SoberMark is a national addiction-treatment directory I build and run solo under my LLC. It assembles 10,900+ providers from twenty federal and state data sources, matches the same facility across sources into one record, and serves it through PostGIS and full-text search. I built it to get deep on databases: search, cleaning, combining, and managing data in production.
postgres
postgis
search
data-engineering
python
nextjs
product
October 6, 20263 min

Building SoberMark: twenty public datasets, one record per provider