At the same time, technological advancement is taking place within agriculture, mining, and drilling. Over time, this produces more of whatever the commodity is for less money.

Yep. This is why the price of gold has been relatively stable (in terms of how many ounces of gold are needed to buy a pair of work boots, a nice suit, a steak dinner, etc.) for quite a little while -- say a couple thousand years ...