** Note: This is in Beta release. This functionality is in constant development and many features are in planning stages. Use the cache plugin to store provider data in a sqlite database.**

ape cache init --network <ecosystem-name>:<network-name>

If you want to set up your network connection for caching use this guide

ape cache init --network ethereum:mainnet

This creates a SQLite database file in the hidden ape folder.

Get data from the provider

Use ape console:

ape console --network ethereum:mainnet:infura

Run a few queries:

In [1]: chain.blocks.query("*", stop_block=20)
In [2]: chain.blocks[-2].transactions

On a deployed contract, you can query events:

  • Below, FooHappened is the event from your contract instance that you want to query from.

contract_instance.FooHappened.query("*", start_block=-1)

where contract_instance is the return of owner.deploy(Contract)

See this guide for more information how to get a contract instance.

Exit the IPython interpreter.

You can query the cache database directly, for debugging purposes. For example, to get the blocks table data from the SQLite db we can do the following:

ape cache query --network ethereum:mainnet:infura "SELECT * FROM blocks"


                                                 hash num_transactions  number                                        parent_hash  size   timestamp  gas_limit  gas_used base_fee   difficulty  total_difficulty
0   b'\xd4\xe5g@\xf8v\xae\xf8\xc0\x10\xb8j@\xd5\xf...                0       0  b'\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00...   540           0       5000         0     None  17179869184       17179869184
1   b'\x88\xe9mE7\xbe\xa4\xd9\xc0]\x12T\x99\x07\xb...                0       1  b'\xd4\xe5g@\xf8v\xae\xf8\xc0\x10\xb8j@\xd5\xf...   537  1438269988       5000         0     None  17171480576       34351349760
2   b'\xb4\x95\xa1\xd7\xe6f1R\xae\x92p\x8d\xa4\x84...                0       2  b'\x88\xe9mE7\xbe\xa4\xd9\xc0]\x12T\x99\x07\xb...   544  1438270017       5000         0     None  17163096064       51514445824

To get transactions or contract_events:

ape cache query --network ethereum:mainnet:infura "SELECT * FROM transactions"


ape cache query --network ethereum:mainnet:infura "SELECT * FROM contract_events"