![blocktrades update.png](https://images.hive.blog/DQmSihw8Kz4U7TuCQa98DDdCzqbqPFRumuVWAbareiYZW1Z/blocktrades%20update.png)

Below are a few highlights of the Hive-related programming issues worked on by the BlockTrades team since my last report. It’s been a while since I last wrote, and a lot of work has been done since then, so a lot of work that was done isn’t covered here, but I’ve tried to capture some of the more important tasks that might affect or be useful to other Hive devs.

# [Hived (blockchain node software)](https://gitlab.syncad.com/hive/hive)

## Fixed log rotation bug

There was a longstanding bug in the fc file appender that was fixed, enabling log rotation to work properly for hived. Log rotation is a process where a program periodically creates a new log file instead of just always writing to the same log file, and then compresses the previously used log file. 

Most commonly node operators may want to configure their log rotation settings so that a new log file is created every day and the last week’s or month’s worth of log files are kept.

Log rotation is particularly useful when hived is configured to log a lot of events, because without log rotation such log files can quickly get too large to manage effectively and can have detrimental side effects such as using up all the disk space on a server.

## Improved error handling for hived “notifications”

External processes can register with a hived node to receive notifications of events (e.g. arrival of a new block, etc). Recently we [improved hived’s HTTP server by supporting 204 HTTP status codes.]( https://gitlab.syncad.com/hive/hive/-/merge_requests/950) 

This change was made to fix intermittent CI test failures for tests that relied on notifications sent by hived. Although the change was initiated to reduce intermittent test failures, it is also an important improvement for other applications that use hived’s notification service.

## Fixed bug when processing a HAF database backup

We fixed an [invalid assert in the code for public key serialization of null key values](https://gitlab.syncad.com/hive/hive/-/merge_requests/941). This would show up when a null public key was specified for a witness key and resulted in a failure when processing a HAF database backup.

## Automated action code removed

We removed the never-used code for automated actions. Automated actions were introduced as a concept in hived to prevent a bunch of “automatically created” actions from requiring too much cpu time, resulting in a block not being able to be produced with the allowed block computation time. 

This concept was originally created by Steemit devs because of fears that automated actions associated with SMTs (e.g. periodic creation of new SMT tokens) could become computationally burdensome. We considered using this capability when recurring transfers were developed, as these operations also generated “future work” beyond the initial block in which they were included, but we decided that there were other ways to schedule such future actions so that the nodes don’t get overburdened.

## RC code continuing to be refactored

As a step towards eventually allowing the resource credit logic being part of blockchain consensus, we’ve been refactoring the code in the resource credit plugin and moving some of this code into the core code. None of this work will impact current consensus rules, however.

## Hived continuous integration (CI) test improvements

Out testing system now generates [a reusable blockchain state file built from the first 5M blocks of the blockchain](https://gitlab.syncad.com/hive/hive/-/merge_requests/900). This state file is versioned to the revision of the hived code that created, so as long as there are no changes to the revision of the hived code, this same statefile can be reused across multiple builds and tests of the code, reducing build and test time.

In other words, when a commit revision only modifies the tests, the commit does not trigger a new build operation (hived images are reused). Similarly, state file generation is skipped (as the state file is also reused).

This means the turnaround time for CI pipelines is very quick when only tests are being modified/added.

Other testing improvements:
* [new blockchain operation tests (testcases for dedicated testing scenarios)](https://gitlab.syncad.com/hive/hive/-/merge_requests/911)
* A new Hived fixture was created that is used for unit tests to much better emulate the real world Hived environment during testing time.  With this new text fixture, the whole appbase application is started and initialized, instead of hacking the initialization of specific plugins being tested. The impetus for this change was that we found a unit test that wasn’t properly testing functionality because of a mismatch between the test setup and real-world hived setup.
* Several fixes to Python regression tests itself to avoid CI random failures: https://gitlab.syncad.com/hive/hive/-/merge_requests/952 https://gitlab.syncad.com/hive/hive/-/merge_requests/936
* Preliminary fixes to libfaketime library eliminating timer blocking problem. Due to bad time recalculations, the witness plugin became blocked and block production was stopped. This error often led to CI failures (tests that timed out).

# [Clive (a new Hive wallet with a text-based user interface)](https://gitlab.syncad.com/hive/clive)

Clive is a Hive wallet written in Python that runs on your own computer (it is not a web-based wallet where the code comes from a remote server) so it is inherently more secure than web-based wallets. Currently there are two such wallets available and supported in the Hive ecosystem: 1) a command-line interface wallet (aka the CLI wallet) written using C++ and 2) a graphical interface wallet called [Vessel (a JavaScript-based wallet)](https://gitlab.syncad.com/hive/vessel). 

Clive is designed to be easier to use than the existing CLI wallet, but at the same time it doesn’t require a terminal that supports graphics like Vessel does. For most people, Clive should provide a more friendly interface for performing Hive operations in a high security environment compared to using the CLI wallet.

As it turns out I was overly optimistic about the development status of Clive in my previous report, so a publicly usable version is still a couple weeks away, and that initial version will mainly support basic operations such as Hive/HBD transfers.

# Beekeeper (tool for managing encryption keys)

Along with the creation of Clive, we created a new C++ program that can be used to store encryption keys and sign transactions with those keys. The purpose of this new program is to separate the high-security aspects of encryption key management from other wallet operations. For example, Clive doesn’t directly store keys or sign transactions. Instead it communicates with a separate beekeeper process and requests these operations to be performed. For those familiar with the EOS ecosystem, beekeeper is based on the ideas embodied in keosd. 

Recently beekeeper was improved to allow a single instance of beekeeper to support multiple clive instances.

# [Hive Application Framework (HAF)](https://gitlab.syncad.com/hive/haf)

HAF is a SQL-based framework for creating highly scalable and robust 2nd layer apps that operate using data from the Hive blockchain.

## New HAF features

* [Support for multiple contexts passed to app_next_block function](https://gitlab.syncad.com/hive/haf/-/merge_requests/277). This makes it easy to create complex haf apps which embedded other haf apps in order to gain the extra functionality of those apps. It enables modular design of complex haf apps. This new feature was tested as part of embedding the balance_tracker app inside the haf_block_explorer app.
* [Support for HAF database backup/restore in dockerized environment](https://gitlab.syncad.com/hive/haf/-/merge_requests/282)
* [better tracking of SQL query activity: counts deleted/updated/inserted/selected tuples in the haf database](https://gitlab.syncad.com/hive/haf/-/merge_requests/288)

## Implemented standardized composite data types for Hive blockchain operations

We completed the creation of [SQL “composite data types” that correspond to Hive blockchain operations](https://gitlab.syncad.com/hive/haf/-/merge_requests/264), and the associated code for creating such composite objects from raw operations data. 

Having a common SQL-based representation of such data promotes more efficient coding practices and code re-use across HAF applications. 

Using these composite objects we were able to cut in half the block processing time required by the haf block explorer indexing engine. 

Next we plan to update  more of the existing haf apps to uses this new feature.

## HAF query supervisor to prevent rogue queries consuming too many resources

One of the more important tasks we’ve been working on for HAF recently is the creation of a “query supervisor”. This is a set of code that is used to monitor the queries executed on a SQL server and limit how many resources can be used by that query before the query will be terminated. 

The query supervisor is necessary to prevent potential denial-of-service attacks that might be launched against a HAF server, especially a HAF server that allows the execution of semi-arbitrary SQL code (e.g. the code of SQL code that would likely be used for a smart contract system running on a HAF server). 

Implementation of the query supervisor has proceeded to the point where it is functionally useful and we’re getting ready to setup an instance of a HAF server that will be publicly accessible with the query supervisor enabled to rate limit loading on the database.

## HAF bug fixes and test improvements

* [Fixed bug that could lead to a constraint violation while processing forks (community reported bug)](https://gitlab.syncad.com/hive/haf/-/merge_requests/285)
* [Eliminated hived node hung while closing](https://gitlab.syncad.com/hive/haf/-/merge_requests/278)
* [Fixed bug when different SQL role (user) owns application schema and different role creates context](https://gitlab.syncad.com/hive/haf/-/merge_requests/286)
* [Support for creating testnet HAF environments to simplify writing testcases]( https://gitlab.syncad.com/hive/haf/-/merge_requests/224)

# HAFAH - HAF-based account history application

* [Testing for this app was updated to reuse already produced data basing on commit revision.](https://gitlab.syncad.com/hive/HAfAH/-/merge_requests/73)
* Eliminated need to have local `hafah_user` unix user and similarly eliminated usage of sudo while performing a database setup using setup_db.sh script.

# Hivemind (social media HAF app for Hive)
* [CI tests for hivemind use a docker image of hivemind instead of directly creating a hivemind setup](https://gitlab.syncad.com/hive/hivemind/-/merge_requests/594). This allows the full dockerized flow for hivemind to be tested during CI testing. 
* [Functional changes to community support: owner can't be changed anymore](https://gitlab.syncad.com/hive/hivemind/-/merge_requests/520)

# HAF-based balance tracker: tracks Hive account balances

This is a HAF app that we originally created as an example of how to make a simple app. It provides an api to track hive and hbd account balances for any Hive account over time (for example, to graph how your account's hive value increases/decreases with time). 

But we found its functionality would be very useful for the haf block explorer, so we've extended its functionality significantly to fit the needs of the block explorer.
* [Support for tracking saving balances](https://gitlab.syncad.com/hive/balance_tracker/-/merge_requests/16 )
* [Support for tracking reward balances](https://gitlab.syncad.com/hive/balance_tracker/-/merge_requests/19)
* [Support for tracking vests delegations](https://gitlab.syncad.com/hive/balance_tracker/-/merge_requests/12) 
* [Vests withdraw routes support](https://gitlab.syncad.com/hive/balance_tracker/-/merge_requests/20)
* [Setup/permission fixes and improvements](https://gitlab.syncad.com/hive/balance_tracker/-/merge_requests/21) 
* https://gitlab.syncad.com/hive/balance_tracker/-/merge_requests/17

# HAF-based block explorer

We’ve been working for a while on new HAF-based block explorer for Hive. There were two main reasons for creating another block explorer for Hive: 1) we wanted an open-source block explorer than could easily be deployed by any of the existing API node operators without adding much overhead to their servers as a means of further decentralizing this critical functionality and 2) we wanted a “heavy-duty” HAF app that could help us identify and fix potential weaknesses and programming difficulties that might arise when developing a complex HAF-based app. So far, I feel we’re well on the way to achieving both goals with this task.

* [Integrated and enabled metadata data provider (offered by HAF)](https://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/37) 
* [implemented delegated vests tracking/endpoint](https://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/38)
* [Implemented savings tracking/endpoint](https://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/44)
* Implemented versioning 
* Use new multiple context scheme provided by HAF
* [Rewards tracking using balance tracker features](https://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/47)
* [Vests withdrawal routes support](https://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/48)
* [Support for structural HAF operations to speed up block indexing](https://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/43)

# Some upcoming tasks

* Integration of keyauth state provider provided by HAF into haf block explorer.
* Improve pg_dump/pg_restore performance by changing format of dumped hive.operation from textual json to bytea literal.
* Complete refactoring work on resource credit code (for eventual inclusion in consensus logic).
* Test real world performance of SQL query_supervisor by setting up a publicly accessible HAF server that users can directly perform read-only queries on.
* Continue work on Consensus State Providers (for more powerful HAF apps).
* Continue work on HAF-based block explorer backend and GUI
* Finish up work on Clive wallet.
* Collect benchmarks for a hafah app operating in “irreversible block mode” and compare to a hafah app operating in “normal” mode (low priority).
* Publish more documentation for various new tools (beekeeper, Clive, consensus state providers) and separate HAF documentation into smaller, more easily digestible chunks.
* Create docker compose scripts to ease deployment of API node infrastructure.