Evan

@evandekim

60 Following

13 Followers

Evan pfp

🌊Wrote an article on a simple way to build a streaming embedded OLAP database with historical blockchain data leveraging @lancedb , @duckdb , and @envio_indexer https://paragraph.xyz/@evandekim/streaming-embedded-olap-data-pipeline-with-lancedb-duckdb-in-python

0 reply

0 recast

0 reaction

Evan pfp

New research article on the state of the blob market with lots of data and charts https://mirror.xyz/preconf.eth/6lZYL62DR9U14KC7wCC4RHReVdHcBeMy5PKeHVbPq5k

0 reply

0 recast

0 reaction

Evan pfp

Average blob propagation and block vs blob size will be important metrics to keep an eye on

0 reply

0 recast

1 reaction

Evan pfp

Where can you buy degen, is it ethereum token?

1 reply

0 recast

0 reaction

Evan pfp

https://twitter.com/primev_xyz/status/1761020003858473153?t=2-37E4w1sevJddw2hCyjgg&s=19

0 reply

0 recast

1 reaction

Evan pfp

https://twitter.com/isamlambert/status/1758909084731142314?t=6v-UtSEdoCneFYtl-8Y6JQ&s=19

0 reply

0 recast

1 reaction

Evan pfp

How was it made?

1 reply

0 recast

1 reaction

Murat pfp

We released a new article that goes over our framework for Preconfirmations on Ethereum and other chains 🦾 I'm very excited to announce that I will also be giving a speech on this at ethDenver! https://mirror.xyz/preconf.eth/sgcuSbd1jgaRXj9odSJW-_OlWIg6jcDREw1hUJnXtgI

0 reply

1 recast

1 reaction

Evan pfp

Ringwoodite is like a sponge, soaking up water. If it were composed of even only one percent of the compound (of water), it would still contain more water than all the oceans on the Earth’s surface combined. https://greekreporter.com/2024/02/05/ocean-found-earths-crust/

0 reply

0 recast

1 reaction

Evan pfp

Are you 100% locked into clickhouse if you want to use tinybird?

1 reply

0 recast

1 reaction

Evan pfp

Substrait is to unified computation as arrow is to unified storage https://blog.lancedb.com/substrait-powered-filter-pushdown-in-lance-3d204355365c

0 reply

0 recast

1 reaction

Evan pfp

Duckdb +1 for simplicity for reading/writing data to S3 over polars https://www.confessionsofadataguy.com/duckdb-vs-polars-for-data-engineering/

0 reply

0 recast

2 reactions

Evan pfp

The modern data stack https://georgheiler.com/2023/12/11/dagster-dbt-duckdb-as-new-local-mds/

0 reply

0 recast

1 reaction

Evan pfp

I believe their API gives you slot level views (unless they removed this the last time I used the API https://api-docs.rated.network/getting-started/welcome

0 reply

0 recast

1 reaction

Evan pfp

https://www.rated.network/?network=mainnet&view=pool&timeWindow=1d&page=1&poolType=all Shows similar data

1 reply

0 recast

1 reaction

Evan pfp

EVO still bad after reaching past it's smoke point

0 reply

0 recast

0 reaction

Evan pfp

Is there a good "aggregate feed" of channels?

0 reply

0 recast

0 reaction

Evan pfp

New research published about reordering slippage and telegram bots. Studying reordering slippage utilized 3 diverse data sources - subgraphs, reth, and libmev to aquire a good data perspective. You are only as good as your data! https://twitter.com/MuratLite/status/1748367222249275723?t=yyP0jJWb7-SwbaFTBmQEAA&s=19

0 reply

0 recast

1 reaction

DCinvestor pfp

wanted: a one-stop shop for all important Ethereum stats, cleanly formatted with no additional agenda, ready to be quoted by financial media - L1+ L2 activity summary (volume, fees, etc.) - ETH supply & burn many have pieces, none integrate it it would appear on CNBC daily

17 replies

3 recasts

43 reactions

Tarun Chitra pfp

One of the most interesting things that those in Ethereum can learn about from Solana is Jito's MEV auction; here are some high level differences: 1. # of auctions isn't fixed per slot; dynamically changes based on txns 2. Set of auctions implicitly defines a DAG of state priority 3. Often more efficient than PBS (!)

5 replies

33 recasts

99 reactions