double entry book keeping can be used to track any resource of any size, though it's particularly good at tracking money of any size.

The upside of a "real database" like postgres is when you need multiple people in the books making changes at the same time. Until your accounting department grows into multiple people, Beancount, hledger or any plain text accounting system would be fine.