search

ordinals / ord

👁‍🗨 Rare and exotic sats
https://ordinals.com
Creative Commons Zero v1.0 Universal
3.8k stars 1.33k forks source link

Index inscriptions by address #2619

Open 77656233 opened 10 months ago

77656233 commented 10 months ago

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

raphjaph commented 10 months ago

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

77656233 commented 10 months ago

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?

elocremarc commented 10 months ago

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.

77656233 commented 10 months ago

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

77656233 commented 10 months ago

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

raphjaph commented 9 months ago

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.

77656233 commented 9 months ago

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.

elocremarc commented 9 months ago

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.

markovichecha commented 5 months ago

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.