cardano-db-sync

cardano-db-sync copied to clipboard

Proposal for cardano-db-sync: Consider Migration to ClickHouse for Enhanced Performance and Scalability

1

# Summary I have noticed that the cardano-db-sync database (dbsync) has grown significantly in size, currently occupying around 450GB as of end of 2022. Queries take noticable latency, in the...

sunapi386

Allow Haskell migrations before and after running each .sql files

1

`applyMigration` runs the migration of a `.sql` file as a cmd command. This means it cannot combine it in a single transaction with the `runHaskellMigration`. We could use the `Cardano.Db.Run`...

kderme

Update doc/schema.md to fix description of tx_id in datum and redeemer

2

doc/schema.md previously stated for both `datum` and `redeemer_data` tables that `tx_id` was "The Tx table index for the transaction where this script first became available.", neither of which seems to...

WubbleWobble

Issue with logs formatting after `[db-sync-node:Warning]` message

5

**OS** Your OS: `Linux Mint 21.2 Cinnamon` Kernel: `5.15.0-92-generic` **Versions** ``` [workstat:cardano.node.basicInfo.version:Notice:5] [2024-02-06 12:52:03.01 UTC] 8.7.3 [workstat:cardano.node.basicInfo.commit:Notice:5] [2024-02-06 12:52:03.01 UTC] a4a8119b59b1fbb9a69c79e1e6900e91292161e7 ``` ``` [db-sync-node:Info:6] [2024-02-06 15:42:55.56 UTC] Version number: 13.2.0.0...

ArturWieczorek

Using `cardano-db-sync --rollback-to-slot` after `consumed-tx-out` is bugged, since it only deletes blocks, without undoing the `consumed_by_tx_in_id` update. We should either fix it if possible or fail with a message.

kderme

Transaction metadata gets dropped by Unicode NUL character

1

**OS** Your OS: Gentoo Linux **Versions** The `db-sync` version (eg `cardano-db-sync --version`): cardano-db-sync 13.1.1.1 - linux-x86_64 - ghc-8.10 git revision ec5b22b4364cca9a866b20de3564c27f2c751969 PostgreSQL version: 15.3 **Build/Install Method** The method you use...

jpy-luke

This can be used after restoring from a snapshot, which doesn't enable the flag. Currently the process is very slow, due to the huge amount of updates. To give some...

kderme

BigInt coin represented with number in TreasuryWithdrawals

3

**OS** Your OS: Ubuntu on WSL2 **Versions** The `db-sync` version (eg `cardano-db-sync --version`): 3.0.0 PostgreSQL version: 12.16 **Build/Install Method** The method you use to build or install `cardano-db-sync`: Docker image...

iccicci

# Description Add aarch64-linux support for nix builds # Checklist - [x] Commit sequence broadly makes sense - [x] Commits have useful messages - [ ] New tests are added...

sgillespie

Explicit numerator and denominator request

2

**OS** Your OS: Ubuntu on WSL2 **Versions** The `db-sync` version (eg `cardano-db-sync --version`): 3.0.0 PostgreSQL version: 12.16 **Build/Install Method** The method you use to build or install `cardano-db-sync`: Docker image...

iccicci