[ABW]: reused code of bridge.get_ranked_posts with hot/trending for their equivalents in condenser_api

Reimplemented get_blog/get_blog_entries with fixes

See merge request !316

observer validation

See merge request !280

Added comments for batch update portion of the flush method

See merge request !291

[ABW]: reimplemented get_blog/get_blog_entries - contains fix for lack of reblogs and small changes in error handling
[Fix] get_content exception with observer specified
[Fix] restored handling of mutes in load_posts_keyed (still in use)

Mi issue 76 wrong is pinned get ranked post

See merge request !315

mentions fix

See merge request !314

Remove hive_posts(block_num_created) index before initial sync

See merge request !312

Hive accounts info view optimizations

See merge request !310

- Improved definition of hive_accounts_info_view to eliminate performance problems. Also defined additional index: hive_votes_voter_id_last_update_idx
- bridge_get_account_posts_by_replies has added +0 (change taken from deployed_20200928_pure).

replace old children count

See merge request !306

speed up for bridge_get_ranked_post_by_created_for_tag

See merge request !307

previously method does not work for block range different than all blocks

- add block_num_created column for hive_posts table, it is required to
distinguish between post create and post update events in given block
range
- both root and non-root posts have updated block_num when are edited
- when post is edited his block_num is also updated

Fixed bug in mentions update ignoring posts having creation time earlier than...

See merge request !295

Bartek Wrona authored 4 years ago and Marcin committed 4 years ago

Fixed bug in mentions update ignoring posts having creation time earlier than block they have processed by blockchain

hive_posts index fix

See merge request !302

hive_accounts_info_view fix

See merge request !301

get state fix

See merge request !297

more complex indexes to speedup get_ranked_posts methods

See merge request !298

notice 30x speedups for get_ranged_posts trending/hot
no slowdown noticed for other queries
verified on DB with ~47mln of blocks

Changes done directly in deployed_20200928_pure branch delivered to develop.

See merge request !292