Thread by @iam4x

Girlfriend out for the weekend, it's time for a side project! I like @yieldwatch but it's not giving me the changes over time. Let's plug a @TimescaleDB and let's create a website with nice charts for that 😎 #DeFi #BSC

wow, that was easy to bootstrap and I've found a name as well 🙌

- jobs to track the price in @TimescaleDB
- jobs to update user wallet content
- @HasuraHQ for GraphQL subscriptions over WebSockets
- #nextjs + @tailwindcss + recharts.org for the frontend

Next steps are:

- add github.com/Web3Modal/web3… for login
- display more portfolio information
- (fancy?) home page with explanations
- deploy to production

I want to make it live the fastest possible and then work on the improvements.

Please note that during the beta testing and improvements cycles, it will only support @autofarmnetwork

First version released farmfol.io 🚀

- frontend and serverless APIs hosted on @vercel
- backend (@HasuraHQ) is hosted on the new @Scaleway serverless service, it's AMAZING you can host a container and add a trigger to keep alive which is allowing delayed jobs

There's no documentation yet, just click "connect wallet" and your wallet will be tracked on farmfol.io

Let it some time to have some prices historic for your wallet and then you will be good to go ✌️

Ah and yeah, naturally the database is also hosted on @Scaleway managed database 🇫🇷

Alright, I've fixed the issue with tracking new wallets you can start tracking your
@autofarmnetwork
staked portfolio value on farmfol.io for just $5 ✌️

I've added some information on the homepage and a demo link. If you are using @autofarmnetwork you should check it out, I will add more features soon #BSC #BinanceCoin #PancakeSwap #DeFi #BTC

👀👀👀 @PancakeBunnyFin might be coming sooner than expected

Still pushing updates, new holdings overview 💄 #BNB #BSC #BinanceSmartChain #Binance #DeFi #Crypto #AUTO #Autofarm #Vaults #Pools #BTC #ETH

Can we break the 1M$ milestone today? 🗣🗣🗣

LETS GOOOOOOO 🚀

Few updates:

Migrated @TimescaleDB to my own server in order to have access to the community functions. What does it do?

I can now generate full ranges of times, no more blank waiting screen when you first connect your wallet.

Your weekly historic should look like this now:

I'm now also using PostgreSQL Materialized Views to cache the your charts, it speeds up the dashboard loading a lot (went from ~7-8s down to ~1s) 🏎

The next step is to re-write the jobs orchestration in a more robust way for allowing more jobs to run concurrently. @HasuraHQ CRON events are great, but I need more granularity.

This will allow indexing other networks, like @PancakeSwap, @beefyfinance, or your @BinanceChain wallet 🙌

So if you have holdings on @autofarmnetwork and you want to track them the stylish way you should try farmfol.io 📉 This will help me for future improvements 😍 #BNB #BSC #BinanceSmartChain #Binance #DeFi #Crypto #AUTO #Autofarm #Vaults #Pools #BTC #ETH