Index Supply

@indexsupply

1 Following

502 Followers

Index Supply pfp

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

2 replies

3 recasts

21 reactions

Index Supply pfp

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

1 reply

3 recasts

47 reactions

Index Supply pfp

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

2 replies

20 recasts

134 reactions

Index Supply pfp

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.

0 reply

2 recasts

15 reactions

Index Supply pfp

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 reply

10 recasts

77 reactions

Index Supply pfp

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

0 reply

0 recast

2 reactions

Index Supply pfp

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

1 reply

0 recast

13 reactions

Index Supply pfp

New TS package for building Shovel config: https://indexsupply.com/shovel/docs/#typescript

0 reply

6 recasts

9 reactions

Index Supply pfp

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

1 reply

1 recast

4 reactions

Index Supply pfp

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

0 reply

0 recast

23 reactions