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)

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