18268
Index Supply

@indexsupply #18268

Indexing Ethereum https://indexsupply.com
493 Follower 1 Following
If you are querying WowTokenCreated on the Index Supply free plan, please reach out to me as I have a query suggestion for you. It will bring your cold query latency from a couple of seconds down to ~150ms.

here is the faster query: https://tinyurl.com/wowtoken-with-addr
Fun Query for this Friday:

Token Balances for a Wallet

https://tinyurl.com/token-balance
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
We track every API query and carefully study the latency. Now you can too!

Fast is a feature.

This number is the time it took us to serve the request. It does not include client download and decoding. Which, depending on your client and your location may be significant. But hopefully not.
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)
SQL API CHANGELOG

1. nested expressions `where a and (b or c)`
2. min/max aggregate functions `max(block_num) from transfer`
3. fix bool predicates `where spent = true`
4. Added mainnet and zora chains
Few know this, but Shovel includes a nice little PG migration system to create indexes, unique indexes, and deals with adding columns to prev. defined tables!

Here is a "index" example. Learn more here: https://indexsupply.com/shovel/docs/#table
Shovel now logs on each tick: nrows=X nrpc=Y nblocks=Z

- number of rows inserted into Postgres
- number of rpc calls made to process
- number of blocks processed

https://indexsupply.com/shovel/docs/#logging
Added a diagnostics endpoint to Shovel. It will show you a comparison of the latest block in the db/node. Latency for db/node operations. And any errors encountered along the way.

https://indexsupply.com/shovel/docs/#monitoring