> Common in a situation where you're writing for a presentation layer and you need human readable data. Yup, this was it. For compactness (theoretical) alot o

> Common in a situation where you're writing for a presentation layer and you need human readable data. Yup, this was it. For compactness (theoretical) alot of the fields were stored as small integers, then a lookup. Here is the relevant offender if interested. https://github.com/praphael/baseball/blob/main/retrosheet_init_db.py#L1274 https://github.com/praphael/baseball/blob/main/retrosheet_in... Alot of lookup for player names and more descriptive fields (field conditions, play descriptions, etc.) In retrospect, this all could have been done as part of a post-process step on the backend. I already was doing that for certain fields such as the month. Which does fail the "anything that can be reasonably be done on the DB end should be done by the DB" test. But it might be a better idea.