ord icon indicating copy to clipboard operation
ord copied to clipboard

Index inscriptions by address

Open 77656233 opened this issue 1 year ago • 9 comments

Is it possible to add a search by address endpoint to get a list of all inscriptions an address holds?

77656233 avatar Nov 01 '23 17:11 77656233

It's definitely possible but I'm hesitant to add this because it adds a huge (more than 60gb) database table. It could be added behind an optional flag though

raphjaph avatar Nov 01 '23 17:11 raphjaph

It's definitely possible but I'm hesitant to add this because it adds a huge (more than 60gb) database table. It could be added behind an optional flag though

That would be amazing as i guess a lot of users would love to use it :) Is there a chance you can take a look into it?

77656233 avatar Nov 01 '23 17:11 77656233

This would be a nice recursive endpoint too. Would also be nice to navigate to a address page on the inscription page when clicking it. Thing to consider how big will this table grow if we get millions more addresses in inscriptions or something? If we max min this and every 460 million bitcoin addresses hold inscriptions thats a big table.

elocremarc avatar Nov 03 '23 05:11 elocremarc

True ,would be a big table but if it's an optional flag it should be fine for everyone :)

77656233 avatar Nov 03 '23 06:11 77656233

@raphjaph, could you provide an estimate for this request? We, and undoubtedly others, would greatly appreciate having access to that endpoint. Thanks a lot!

77656233 avatar Nov 09 '23 05:11 77656233

Do you mean as a recursive endpoint or just a normal html page?

At the moment we're working on database optimizations so want to control the amount of tables we have. I think I'll code something quick up and do some testing to see how it impacts performance.

raphjaph avatar Nov 09 '23 16:11 raphjaph

Do you mean as a recursive endpoint or just a normal html page?

At the moment we're working on database optimizations so want to control the amount of tables we have. I think I'll code something quick up and do some testing to see how it impacts performance.

I talk about the json api endpoint that the server offers.

77656233 avatar Nov 09 '23 17:11 77656233

Do you mean as a recursive endpoint or just a normal html page?

Recursive endpoint would be nice but we can add that later I think a html/json page would be a good start.

elocremarc avatar Nov 11 '23 05:11 elocremarc

Hey, may I handle this task? To clarify, do we need to create an index that includes addresses and their corresponding inscription IDs? And add an html page that shows all inscriptions for given address after that.

markovichecha avatar Mar 24 '24 15:03 markovichecha