IntroThis article presents a framework for building data pipelines on the Sui blockchain using Sentio, illustrated through a complete implementation to analyze Rootlets NFT holders. Sentio is used for efficient data backfilling, custom processing with TypeScript, and real-time analysis via its SQL Studio. The article culminates in demonstrating a user-friendly Sentio dashboard that queries Rootlet ownership by wallet address. This approach provides a reusable and adaptable foundation for deve...

Over 50% of transactions to mutate shared liquidity pool objects that pay the maximum gas fee end up below the median block position. Users paying max gas fees have a 0.001-0.002% chance of securing the top block position, compared to 7-10% for those not paying the highest fees.SIP-45 proposes increasing the max gas price to 1 trillion MIST and making tra...

Sentio Referral Code: Reach out to @is_ye in the sentio telegram chat and give the referral code evandekim2025 for a 20% discount for Sentio subscription! IntroSentio is a game-changing development platform that enables end-to-end data observability for web3 data pipelines. The platform provides a fully integrated, hosted experience that combines modern monitoring, alerting, and debugging capabilities. What makes Sentio particularly powerful is its real-time processing architecture: developer...

IntroThis is the start of a series of posts that examines how to analyze Solana data in SQL using different platforms. We start off the s...

TLDR:Pyth contract has a 26.5% tx failure rate (292,165 txs) across 1.1m transactions, resulting in 1.45 SOL in lost fees. The failure rate....

IntroThis post goes over a simple solution to create an embedded streaming OLAP data pipeline that leverages historical blockchain data from Hypersyn...