**Warning: this update (due to underlying Hived modifications) changes hived/HAF state format and requires HAF node replay, if you are using version 1.27.4.0 or earlier.**

#### New features, functional improvements, and optimizations

1. Support for the new Query Supervisor (limits database resources available to database roles during a query). See documentation located here: README.md

- https://gitlab.syncad.com/hive/haf/-/merge_requests/257
- https://gitlab.syncad.com/hive/haf/-/merge_requests/273
- https://gitlab.syncad.com/hive/haf/-/merge_requests/291
- https://gitlab.syncad.com/hive/haf/-/merge_requests/288
- https://gitlab.syncad.com/hive/haf/-/merge_requests/294
- https://gitlab.syncad.com/hive/haf/-/merge_requests/305

2. Dockerized environment supports --load-snapshot/--dump-snapshot options backup/restore a HAF server (including hived): https://gitlab.syncad.com/hive/haf/-/merge_requests/282
3. Optimization of `hive.operation` type conversion into textual format (improves backup/restore times): https://gitlab.syncad.com/hive/haf/-/merge_requests/292 . Right now by default `hive.operation` is converted into `bytea` literal (representing operation binary format common to blockchain storage). To use the legacy JSON-textual form, use the `body` column provided by `hive.operations_view` (also in app-specific operations view) or change your app to use the new `body_binary` column (this will improve performance).

- https://gitlab.syncad.com/hive/haf/-/merge_requests/292
- https://gitlab.syncad.com/hive/haf/-/merge_requests/306

4. New function available for calculating HivePower value: https://gitlab.syncad.com/hive/haf/-/merge_requests/287
5. Complex HAF apps can now be built from multiple smaller apps: https://gitlab.syncad.com/hive/haf/-/merge_requests/277

#### Bugfixes:

1. Fixed a constraint violation while processing data in Account Metadata State Provider (common Metadata Collector provided by HAF, next to be instantiated at HAF-app level): https://gitlab.syncad.com/hive/haf/-/merge_requests/274
2. Eliminated hang of hived node while closing after earlier caught PostgreSQL related error: https://gitlab.syncad.com/hive/haf/-/merge_requests/278
3. Community reported problem related to processing forks by the HAF server: https://gitlab.syncad.com/hive/haf/-/merge_requests/285
4. Multiple app roles are allowed to create app-specific tables like also perform synchronization (simplifies and makes deployments much more secure):
   - https://gitlab.syncad.com/hive/haf/-/merge_requests/286
   - https://gitlab.syncad.com/hive/haf/-/merge_requests/286
5. HAF functions will explicitly fail when app-specific table identifiers are too long: https://gitlab.syncad.com/hive/haf/-/merge_requests/295

1. New features:
    - Optimized HAF operation storage to reduce its size (Hive operations are now serialized to binary form in same way as blockchain does): https://gitlab.syncad.com/hive/haf/-/merge_requests/201
    - Optimized Hive operation to JSONB type conversion: https://gitlab.syncad.com/hive/haf/-/merge_requests/228
    - HAF knows hardfork data and stores this info in the dedicated table: https://gitlab.syncad.com/hive/haf/-/merge_requests/172
    - HAF provides subset of basic DGPO data specific to given block: https://gitlab.syncad.com/hive/haf/-/merge_requests/213
    - HAF is able to store and verify a database schema to match running HAF node to existing database: https://gitlab.syncad.com/hive/haf/-/merge_requests/229
    - Support for dump and load HAF instances (specific to backup administration purposes): https://gitlab.syncad.com/hive/haf/-/merge_requests/194 
    - Prepared Account Metadata Consensus Data State provider to be used at implementation of account metadata HAF application
    - Preliminary boilerplate for building and deploying HAF applications using docker compose: https://gitlab.syncad.com/hive/haf/-/merge_requests/217
    - Upgrade to Ubuntu 22.04 as a base supported OS
2. Devops/automations:
    - docker setup permission fixes
    - Gitlab cache is used for HAF data generation for testing purposes https://gitlab.syncad.com/hive/haf/-/merge_requests/220
    - Official HAF images can be built and published by CI job: https://gitlab.syncad.com/hive/haf/-/merge_requests/219
3. Bugfixes:
    - fixed deadlock during joining massive operation processor

Test tag for hive#434

Test tag for hive#434

Test tag for hive#434

Test tag for hive#434

Test tag for hive#434

Related to MR: https://gitlab.syncad.com/hive/haf/-/merge_requests/172/