I am thinking about the 'science' of block explorers
When I go to a block explorer and view an address, I see a list of transactions in that address and current balance
Is this technically just the contents of each block being stored as they are created (or retroactively parsed) and assigning a database entry for each new element found in that block?
Or even storing every unconfirmed transaction's data as well?
Writing this out, I think I answered my own question, but maybe there is some more efficient or clever thing going on here