search

holaplex / indexer

Index Solana data using a Geyser plugin (downstream service cluster)
https://holaplex.com
GNU Affero General Public License v3.0
162 stars 38 forks source link

Cache Table for NFT Lowest Price #654

Closed kespinola closed 2 years ago

kespinola commented 2 years ago

Goal

Have a table of the lowest price for each NFT that gets updated as listings are written into the database.

The lowest written listing should be over all auction houses + magic eden unless its the auction house of the DAO. If the listed on the DAO always write it to the lowest_metadata_listing

lowest_metadata_listings
-------------------------
listing_id
metadata_mint_address_address

Benefits

Can do a single join from metadata to its lowest price instead of a nest query for each record.

kespinola commented 2 years ago

Requiring all queries to pass in a single marketplace program address/auction house so able to cleanly join in a single listing record for price sorting.

replaced by https://github.com/holaplex/indexer/issues/722

kespinola commented 2 years ago

Requiring all queries to pass in a single marketplace program address/auction house so able to cleanly join in a single listing record for price sorting.

replaced by https://github.com/holaplex/indexer/issues/722