ilemi on Warpcast

Content pfp

0 reply

0 recast

0 reaction

jesse.base.eth 🔵 pfp

jesse.base.eth 🔵

I just bought a /bytexplorers token that I hope to redeem! I'd love to explorers to investigate: how many "quality builders" are there are on @base (and how is it growing)? define quality however you choose, but find a predictive metric that tracks the number of great builders. @msilb7 has explored this previously

9 replies

3 recasts

110 reactions

ilemi pfp

alright, I'm going to start querying this and replying in this thread with my thinking/work until I finish :) here is what I'm starting with...

3 replies

1 recast

3 reactions

ilemi pfp

took a look at some of @msilb7 's queries on developers/contracts, iterating a bit. Working with the features: factory, token category, decoded, usd_value received, times called, unique wallets, unique contract-to-contract callers. now to get some food while the query runs https://dune.com/queries/3555390

2 replies

0 recast

3 reactions

ilemi pfp

Pro tip, when you have a long running query you're building off of, materialize it so you can quickly iterate your other queries. You can then delete the matview when you're done and replace it with a query view again to save the costs/credits. I do this a lot when querying complex data

1 reply

0 recast

5 reactions

ilemi pfp

alright, I incorporated more of @msilb7 table (new favorite table) and decided to take a "complexity" measurement approach. Will share some charts soon. 5 - well known project/serious team 4 - fairly technical team (create2 or gnosis deploy 3 - non-factory contract 2 - non-token contract 1 - token contract

3 replies

0 recast

4 reactions

ilemi pfp

Alright, and after adding another layering of quality based on usage I end up with this query/chart. Tldr; there are about 1,400 high quality developers on base. medium quality developers have seen more of an uptick recently. https://dune.com/queries/3555382/5984629

2 replies

1 recast

13 reactions

ilemi pfp

What's interesting to me is that the pure number of contracts of various qualities are all ticking up healthily across the board. The lag in high quality developers means to me that most of the high quality contract growth is coming from a small number of high quality devs.

1 reply

0 recast

1 reaction

ilemi pfp

I left some follow up bounties that would be great for people who want to dive into this further (could test them out as follow up bytelight questions 😉) @jessepollak if this thread answered your question, then reply with @bytecast answered :)

2 replies

0 recast

2 reactions

ilemi pfp

one last note, comparing @msilb7 's revgen deployers chart to my chart the numbers are fairly similar (1400 revgen devs versus 1600 high quality devs). The interesting thing to note is that in my methodology, this is the second peak versus the first peak. Probably some gold insights if we dug a few layers deeper.

1 reply

0 recast

2 reactions

Michael Silberling pfp

Michael Silberling

Yeah I think having multiple methodologies that are all plausible is great. So when they agree or diverge, that tells us something about the market.

0 reply

0 recast

2 reactions