sbds icon indicating copy to clipboard operation
sbds copied to clipboard

Add methods to sbds to replace account history in steemd

Open jredbeard opened this issue 7 years ago • 5 comments

Account History Implementation Requirements

Data Storage

  • [x] index all operations
  • [x] link all account name references (all of these are done except fields of typeflat_set< account_name_type>)
  • [ ] determine best way to index information (View, Materialized View, Table)

get_account_history Implementation

steemd source

  • [ ] #109 get_account_history sql query
  • [x] get_account_history jrpc method handling
    • defined in sbds.server.methods
    • signature: get_account_history( account:str , from:int, limit:int )

get_state Implementation

steemd source roadscapes excellent explanation

  • [ ] #110 decompose get_state query into parallel subqueries
  • [ ] #111 get_state jrpc method handling
    • defined in sbds.server.methods
    • signature: get_state( path:str )

jredbeard avatar Dec 01 '17 16:12 jredbeard

at least one call used for the account history in the wallet in condenser, per @roadscape

get_state("@username/transfers")

internally it calls get_account_history and filters based on relevant transactions

sneak avatar Dec 15 '17 19:12 sneak

Third parties who access our API use the vote history in AH, which is huge - we don't need it for condenser/steemit.com. We can vastly reduce the usage of the AH's plugin state file size simply by filtering out vote operations.

sneak avatar Dec 15 '17 19:12 sneak

in master at least, the only places where the account_history plugin is invoked are in database_api:

goldibex avatar Dec 15 '17 19:12 goldibex

#89 is part of this effort

sneak avatar Jan 15 '18 23:01 sneak

Good work done by @roadscape here https://github.com/steemit/condenser/issues/2244

john-g-g avatar Mar 06 '18 18:03 john-g-g