Index Supply (indexsupply)

Here is a power user's tip for querying the logs table directly. Keep in mind: you'll want to add a `block_num` predicate since we don't have an index on tx_hash. This is useful if you want all logs for a specific tx. https://www.indexsupply.net/query?query=select+topics%2C+data+%0Afrom+logs+%0Awhere+tx_hash+%3D+0x856230d65058272c1c53722e758c737f190722523f745b2e62dddcf33ee31179%0Aand+block_num+%3D+26774642&event_signatures=&chain=8453

• 1 reply
• 1 recast
• 7 reactions

• 0 replies
• 0 recasts
• 5 reactions

Fascinating example of how to query events with nested tuples!

• 2 replies
• 1 recast
• 13 reactions

SQL CASE Now Supported Here is a fun query from @liam.eth showcasing World App User Migrations on the World Chain. https://tinyurl.com/wrldchain

• 0 replies
• 20 recasts
• 42 reactions

How Index Supply collects payments with Daimo Pay + Index Supply @daimo-pay is the simplest service for accepting any coin, on any chain, from any wallet. Index Supply is the simplest API for instant access to Ethereum. But can they blend?

• 2 replies
• 7 recasts
• 21 reactions

Queries using indexed fields typically run in sub-millisecond time. So you'll never see the loading indicator. But, If you query a contract with ¼ × 10⁶ rows then we have to do an index scan, and send the data; which, even on dialed hardware, can take time. And for these cases, there is now a fun loading indicator. (it’s database themed)

• 0 replies
• 1 recast
• 29 reactions

Fun Query for this Friday: Token Balances for a Wallet https://tinyurl.com/token-balance

• 1 reply
• 0 recasts
• 27 reactions