knaccc do you have the code available for the max transaction depth for outputs? If I recall correctly, you ran some numbers on this

sarang what is the best general purpose tool for analyzing the Monero blockchain? Things like querying transactions that spend given outputs and the like

I'm trying to assist someone who is researching churning more specifically

Can do RPC calls on a local blockchain, or use something like the explorer API (which is much slower) on a local installation

That'd be unreasonably slow unless you use a patch that adds spent height to the spent_keys table.

I should probably make it store the tx index instead of height...

I assume you'd want to build some kind of custom DB structure to optimize whatever analysis is desired

n3ptune might have that partiuclar table.

Oh, good call

Yeah, they run a lot of analysis

How can I help? you mention both a specific question, but also wanting a general purpose tool

well, the database tool I use is here: github.com/coinmetrics-io/haskell-t…b/master/docs/coinmetrics-export.md

short doc on using it with Monero: github.com/neptuneresearch/monero-n…tes/blob/main/coinmetrics-export.md

you'll need to set up a PostgreSQL server, and you'll be writing everything in SQL queries

If that all sounds within reach of your researcher, we can talk more about using that to answer their questions

also don't forget about this tool: github.com/moneroexamples/transactions-export

Ty, I'll reply if I need something more or have other questions

sarang | I assume you'd want to build some kind of custom DB structure to optimize whatever analysis is desired < yeah I did that :)

it uses a memory mapped file with only the essentials required for chain analysis

and so it's fast to answer all sorts of questions

sgp_ github.com/knaccc/anonymityExplorer