granthdb

Ledger

Three years of transactions — 12,000 rows — with balances recomputed from the rows rather than stored beside them, date ranges served by a compound index, and transfers that write two entries in one transaction.

Live database

Opening…

Entries

In
Out
Net
DatePayeeCategoryAccountAmount
Amounts are integer pence, never floats — a ledger that is a penny out is a broken ledger.