IntersectMBO/cardano-db-sync 5.0.0

Cardano DB Sync 5.0.0

on GitHub

This release provides schema changes, validation additions and bug fixes. The database schema changes include new fees and registeredTxId data, breaking changes in column names of ParamUpdate table, removal of redundant indexes. It also has documentation improvements.

As this release has breaking changes, the database has to be dropped and recreated for the upgrade.

Compatible with Cardano Node 1.19.1.

Added

• Added a fees column to the Epoch table (#275)
• Added a registeredTxId column to PoolOwner table (#281)
• Resurrected the cardano-db-tool validate functionality (#268)

Changed

• Added validation that all pools have owners in db-tool (#262)
• Updated interesting-queries.md : removed old queries, fixed existed relevant ones, and added an example query for transaction inputs and outputs (#273)

Breaking changes ⚠️

• Renamed, corrected and clarified column names in ParamUpdate table: active_slot_coeff is replaced by decentralisation, and n_optimal is replaced with optimal_pool_count (#264)
• Removed redundant indices from schema (#261)

Removed

• Dropped support for non-HFC protocols. Specifically, dropped support for pure Byron and pure Shelley networks (#284)

Resolved

• Corrected uniqueness constraint on PoolOwner table (#251)
• Fixed calculation of deposit field of Tx table and accounting (#249, #266, #265, #267)

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