Viewing profile — pgr0ss

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 table…

I updated the README and added an example test: https://github.com/pgr0ss/pgledger?tab=readme-ov-file#histor...

The idea is that the ledger implementation itself is generic and shared, and then how you use the ledger is the novel part.

> 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,…

I think that's a fair point. Unnesting arrays in SQL can be annoying. Here is your first example with duckdb: duckdb -c \ "select * from ( \ select unnest(assets)->>'browser_downlo…

Hi, I’m the author of the blog post. > And it is bizarre to me that you could run a payments system without high-availability or immutability at its core. I’m not sure what you’re …

It was also covered in: https://www.braintreepayments.com/blog/switching-datacenters...