Two worst bets I made that did not work at all:

1) Trying to sync the farcaster data to database to provide all farcaster users with advanced stats & analytics. Tried shuttle, different setups, spent 4 months, results are less than usable.

2) Trying to sync the moxie subgraph to database to provide all moxie users with advanced stats & analytics. Spent 2 months doing that, results are inconsistent. When it works - it's amazing. But the sync stops at random times and then the data is unusable.

I could spend all this time working on some cool frames...

great insights! 

I also went down the hubs/shuttle rabbit hole some time ago to have real-time updates directly from hubs, but I quickly switched to nenar, even though I initially had some thoughts like "I have to make this thing reliable."