A self-hosted Prestashop could be a good option.
Like any PHP / MariaDB (~ MySQL) project, you can host it locally using xampp / mampp / lampp.
Although not truly an inventory software but a shopping cart system, you could use Prestashop as an inventory software.
Furthermore it will let you sell you your products online if you want.
If I remember well, for each product it keeps the history of items added and removed, although likely not with the price changes.
To see data as tables, in addition to Prestashop's backend you can see the records in its MySQL tables, in phpMyAdmin for instance.
If necessary, you can also create MySQL VIEWS on tables to make things more readable in phpMyAdmin.
To keep trace of price changes, you could add a TRIGGER on the price table that duplicates the record in another table when a price changes occurs.
To my opinion, Prestashop is really powerful but sometimes a little bloated for small business needs.
With versions 7 and 8, the Prestashop's developers are migrating from the legacy version and to a new framework (Symfony if I remember well).
It can sometimes makes adapting the frontend tricky because it is between two worlds.
AbanteCart is another good option, which I personally prefer for quick edits.
Contrarily to Prestashop, its backend does not keep history of changes in quantities.
Both Prestashop and AbantCart have additional modules that you can buy.
Or simply create a database in phpMyAdmin (or else) with one or a few MariaDB / MySQL tables that suits your needs, and edit them through phpMyAdmin.
You can still code some PHP things in later time to make your inventory management easier.