Program Struct V2

[amilz]

Issue

Program struct for burn accounts is:

pub struct BurnScore {
    pub burned_tokens: u64,
    pub pyro_key: Pubkey,
    pub num_burns: u64,
    pub user_name: String,
    pub mint: Pubkey
}

Unfortunately the way mmecp filters work, I can't filter on mint b/c it's after a variable byte-length string. So each program query looks up all accounts and then we filter for mint on front end. Fine now but won't scale if we get more users.

Proposed Solution

Create a new struct, e.g..:

pub struct BurnScore {
    pub acct_version: u8,
    pub mint: Pubkey,
    pub pyro_key: Pubkey,
    pub burned_tokens: u64,
    pub num_burns: u64,
    pub user_name: String,
}

Create a migration function.

Note: if we start to get higher volume of users before we implement a fix, we may want to useLocalStorage for our account query and store the results rather than calling it each page (only really an issue if somebody is navigating around multiple mints)

Resources:

• https://solana.stackexchange.com/questions/742/how-the-scope-for-memcmp-works-when-the-struct-has-multiple-strings
• https://solanacookbook.com/guides/data-migration.html#how-can-you-migrate-a-program-s-data-accounts