pgr0ss
Joined 16 years ago
Karma
676
Submissions
85
Member since
Feb 2
http://www.pgrs.net/
View on Hacker NewsRecent submissions
Comment · 1 year ago
My idea for for this to add metadata to the transfers, likely with a jsonb column. But I agree that the ledger won't encompass everything. You would still have other database tables and then you'd store domain identifiers in the ledger and/or ledger identifiers in your other tables.
Comment · 1 year ago
I updated the README and added an example test: https://github.com/pgr0ss/pgledger?tab=readme-ov-file#histor...
Comment · 1 year ago
The idea is that the ledger implementation itself is generic and shared, and then how you use the ledger is the novel part.
Comment · 1 year ago
> how do we efficiently get the balance of a certain account at a certain date time?
This depends on how you implement the ledger. For pgledger, I store the balance in every entry, so to find a historical balance, you just need to find the most recent entry before that time:
https://github.com/pgr0ss/pgledger/blob/df5541dcf25f416a6a24...
I have a mental TODO to add a query function to make this simpler.