Below is a brief list of Hive-related programming issues worked on by BlockTrades team during last week or so: # Hived work (blockchain node software) ## SQL account history plugin for hived We made some fixes to the SQL account history plugin to enable proper operation with hivemind sync process: https://gitlab.syncad.com/hive/hive/-/merge_requests/173 https://gitlab.syncad.com/hive/hive/-/commits/bw_live_postgres_dump/ https://gitlab.syncad.com/hive/hive/-/merge_requests/177 We still have one fix to avoid a potential foreign key violation during live sync (probably will be finished tomorrow). ## HF25 changes (these are described in detail in our [Hive roadmap post](https://hive.blog/hive-139531/@blocktrades/roadmap-for-hive-related-work-by-blocktrades-in-the-next-6-months)) We made some fixes and improvements to the code that handles expiration of governance votes (votes for witnesses and Hive Fund proposals): https://gitlab.syncad.com/hive/hive/-/merge_requests/174 We started work on voting window changes for HF25. We expect to finish implementation tomorrow, then we can begin testing. ## Miscellaneous hived changes We made a fix related to removal of expired Hive Fund proposals: https://gitlab.syncad.com/hive/hive/-/merge_requests/176 We finished review of @howo merge requests. Two have been merged to develop and one is still under review: https://gitlab.syncad.com/hive/hive/-/merge_requests/162 https://gitlab.syncad.com/hive/hive/-/merge_requests/169 We also fixed an intermittent issue with hived shutdown: https://gitlab.syncad.com/hive/hive/-/merge_requests/157 We added some virtual ops to report various changes in state (mainly accounting-related) that weren’t previously reported: https://gitlab.syncad.com/hive/hive/-/merge_requests/167 Some changes to cleanup compile process: https://gitlab.syncad.com/hive/hive/-/merge_requests/172 Fix for proper testnet operation: https://gitlab.syncad.com/hive/hive/-/merge_requests/175 # Hivemind (2nd layer applications + social media middleware) Fixed a problem in master branch that caused issues when upgrading an existing hivemind database: https://gitlab.syncad.com/hive/hivemind/-/merge_requests/483 Fixed an issue with git version reporting: https://gitlab.syncad.com/hive/hivemind/-/merge_requests/479 Added a comand-line option to log the time required for hive server to process API requests: https://gitlab.syncad.com/hive/hivemind/-/merge_requests/481 Some new tests for bridge API calls: https://gitlab.syncad.com/hive/hivemind/-/merge_requests/477 # Postgres extension for fork handling for Modular hivemind One of the key challenges for modular hivemind (the upcoming 2nd layer application framework) is automated support of fork handling. Automated fork-handling will simplify design of 2nd layer apps so that they don't need to worry about fork-handling logic. Currently we’re experimenting with the use of a C-based postgres extension to help accomplish this task (we’re referring to this as the SQL change-audit extension). Last week we tested the prototype’s ability to recover the original state of an updated record in the database. Below are links to where this work is going on in the repo: https://gitlab.syncad.com/hive/psql_tools/-/blob/mi_hive_fork_plugin/README.md https://gitlab.syncad.com/hive/psql_tools/-/commits/mi_hive_fork_plugin

See: 7th update of 2021 on BlockTrades work on Hive software by @blocktrades