Can you elaborate more? What specifically about offchain world?

My first thought was sending email.

+1, I have another project on payment channels, coming soon

Thanks for the PR, and it's merged, but the gif is still animated though. I'll update with still images later in the day.

I think that's a caching issue

It's not loaded into a SQL database. You can think of Presto as simply as a SQL query engine. It sources data from Ethereum and run queries on it.

Yes, and with presto you can join tables from different sources. So you can join ethereum data with whatever you want, be it a mysql table of accounts in observations, etc.