Add methods to sbds to replace account history in steemd

[jredbeard]

Account History Implementation Requirements

Data Storage

• index all operations
• 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

• get_account_history sql query #109 get_account_history sql query
• 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

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

[sneak]

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]

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.

[goldibex]

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

• get_account_history
• get_state

[sneak]

#89 is part of this effort

[john-g-g]

Good work done by @roadscape here steemit/condenser#2244