Cardano DB Sync 4.0.0

This release provides improvements and bug fixes. The database schema additions include transaction metadata, certificate index within a transaction, raw hexadecimal transaction address, raw stake address. The update fixes delegation and pool_retire references, stake deregistration, stake ordering, epoch start and end times data.

This release has a breaking change, and requires the database to be dropped and recreated.

Compatible with Cardano Node 1.18.0.

Released as a library (not deployed to any environment).

Added

• Added and populated tx_metadata table (#229)
• Added index within the transaction for all transaction certificates (#230)
• Added raw address to tx_out table; the raw address that is stored along the rendered version of address (#223)

Breaking change ⚠️

• Added raw address in stake_address table; the raw address is stored as well as the rendered version, and stake_address.hash is renamed to stake_address.hash_raw (#224)

Resolved

• Moved stake deregistrations into a correct table instead of the registration table (#234)
• Fixed certificate ordering issues that resulted in an abort if a MIR certificate was found whose output was a stake address that was inserted later in the same transaction (#237)
• Corrected stake_address registration handling on rollbacks (#238)
• Fixed epoch start and end times in epoch table (#242)
• Made delegation and pool_retire tables reference pool_hash table instead of pool_update (#245)

Known issues

• Missing PoolOwner for some pools (#251)

Documentation

Cardano DB Sync Overview
Building and Running the Cardano DB Sync Node
Schema Management
Validation
The Plug-in System

Platforms

• Linux 64-bit
• Docker

Sign off

Role	Approval
Technical Lead	✔️
QA Engineer	✔️
Release Manager	✔️