18268
Index Supply
@indexsupply #18268
Indexing Ethereum https://indexsupply.com
129 Follower 1 Following
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
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
Here is a "index" example. Learn more here: https://indexsupply.com/shovel/docs/#table
New TS package for building Shovel config: https://indexsupply.com/shovel/docs/#typescript
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
- 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
https://indexsupply.com/shovel/docs/#monitoring