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

Was the tough part keeping it near real time? It seems like replicating the rocks.db files to postgres or snowflake should be doable