4 ms·

Beyond Dune: Accelerating with EVM Query Language

41 points by iankguimaraes 2y ago

iankguimaraes 2y ago
EVM Query Language (EQL) offers a fast, streamlined alternative to Dune for querying blockchain data, specifically optimized for EVM chains. While Dune excels at large-scale data visualization across multiple blockchains, EQL shines in speed and simplicity for Ethereum-specific tasks like transaction lookups and account state queries. EQL’s SQL-like syntax is intuitive for developers, offering faster results for focused datasets, while Dune is more suited for handling complex, multi-blockchain queries and robust visualizations. Benchmark tests demonstrate EQL’s superior speed in tasks such as fetching account states and transactions, though Dune outperforms in block range queries. Ultimately, EQL is a lightweight, open-source option for developers who need quick, efficient blockchain queries, while Dune is better for larger, more complex data processing with advanced visualization capabilities.
distortionfield 2y ago
This is cool! In rust, nonetheless. is blob support planned? Will definitely be messing around with this.
- iankguimaraes 2y ago
  Yes! I'm definitely going to expand the support, but EQL already offers some level of support: See the queries below: https://www.eql.sh/?query=GET+excess_blob_gas%2C+blob_gas_used+FROM+block+latest+ON+eth https://www.eql.sh/?query=GET+excess_blob_gas%2C+blob_gas_us... https://www.eql.sh/?query=GET+max_fee_per_blob_gas+FROM+tx+0x31abbc1ea235977070809d492a7100e473a32cd821a01ac210b4daff40bbd475+ON+eth https://www.eql.sh/?query=GET+max_fee_per_blob_gas+FROM+tx+0...
hanniabu 2y ago
On your homepage I would love to see some more medium complexity examples. For example, how would one query the deposit addresses made to the staking deposit contract, only counting addresses that deposited an aggregate of 32ETH or more.
- iankguimaraes 2y ago
  Good feedback. I'll add more useful examples there! Thanks
jackb4040 2y ago
"EVM Query Languange" I gotta tell you, a typo in the name of your product on your homepage makes me question if you're ready for prime time.
- iankguimaraes 2y ago
  Just fixed it, thank you. Bring the prime time!

41 points by iankguimaraes 2y ago

EVM Query Language (EQL) offers a fast, streamlined alternative to Dune for querying blockchain data, specifically optimized for EVM chains. While Dune excels at large-scale data visualization across multiple blockchains, EQL shines in speed and simplicity for Ethereum-specific tasks like transaction lookups and account state queries. EQL’s SQL-like syntax is intuitive for developers, offering faster results for focused datasets, while Dune is more suited for handling complex, multi-blockchain queries and robust visualizations. Benchmark tests demonstrate EQL’s superior speed in tasks such as fetching account states and transactions, though Dune outperforms in block range queries. Ultimately, EQL is a lightweight, open-source option for developers who need quick, efficient blockchain queries, while Dune is better for larger, more complex data processing with advanced visualization capabilities.

distortionfield 2y ago

This is cool! In rust, nonetheless. is blob support planned? Will definitely be messing around with this.

iankguimaraes 2y ago
Yes! I'm definitely going to expand the support, but EQL already offers some level of support: See the queries below: https://www.eql.sh/?query=GET+excess_blob_gas%2C+blob_gas_used+FROM+block+latest+ON+eth https://www.eql.sh/?query=GET+excess_blob_gas%2C+blob_gas_us... https://www.eql.sh/?query=GET+max_fee_per_blob_gas+FROM+tx+0x31abbc1ea235977070809d492a7100e473a32cd821a01ac210b4daff40bbd475+ON+eth https://www.eql.sh/?query=GET+max_fee_per_blob_gas+FROM+tx+0...

hanniabu 2y ago

On your homepage I would love to see some more medium complexity examples. For example, how would one query the deposit addresses made to the staking deposit contract, only counting addresses that deposited an aggregate of 32ETH or more.

iankguimaraes 2y ago
Good feedback. I'll add more useful examples there! Thanks

jackb4040 2y ago

"EVM Query Languange" I gotta tell you, a typo in the name of your product on your homepage makes me question if you're ready for prime time.

iankguimaraes 2y ago
Just fixed it, thank you. Bring the prime time!