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...

What’s your issue with shuttle? 

I'm running one that only stores the last 30 data, and it's working well.