Skip to content

Instantly share code, notes, and snippets.

View kderme's full-sized avatar

Kostas Dermentzis kderme

View GitHub Profile

Sancho changelog

sancho-a-b-c tags in db-sync are a series of incremental integration of conway feautures. These tags can follow the sanchonet https://book.world.dev.cardano.org/environments.html#sanchonet-testnet. Their enumeration has the following meaning:
a: schema changes
b: compatible with a respinned sanchonet or node
c: minor changes or fixes

It is advised to resync from genesis when using a new version a or b.

@kderme
kderme / gist:2ab2f79fcdc159be3465bae9b7df78e7
Last active October 9, 2023 14:29
Sancho DBSync tags

sancho-a-b-c tags in db-sync are a series of incremental integration of conway feautures. These tags can follow the sanchonet https://book.world.dev.cardano.org/environments.html#sanchonet-testnet. Their enumeration has the following meaning:
a: schema changes
b: compatible with a respinned sanchonet or node
c: minor changes or fixes

It is advised to resync from genesis when using a new version a or b.

Some useful links (adjust the numbers to the correct tag):

@kderme
kderme / DBSync.md
Last active November 9, 2022 14:15

DBSync 3 months plan

Syncing speedup

  • Performance optimizations Postgres. It syncs faster performance view
    --> Depends on benchmarks. Plan: prototype, benchmark, evaluate, implement
  • Migrations. It avoids long resyncing.
    --> Depends on upstream breaking changes which cause unpredictable changes to the db.
  • Configuration and flavors. It doesn't sync everything.
    --> Depends on downstream, users input.

orthogonal with each other

Integration dependencies view

Schema Documentation for cardano-db-sync

Schema version: 12.0.1 (from branch master which may not accurately reflect the version number)

schema_version

The version of the database schema. Schema versioning is split into three stages as detailed below. This table should only ever have a single row.

  • Primary Id: id
@kderme
kderme / vasil-schema.md
Last active June 9, 2022 09:25
Expected schema changes for Vasil hf

Schema Documentation for cardano-db-sync

Schema version: 13.0.0

schema_version

The version of the database schema. Schema versioning is split into three stages as detailed below. This table should only ever have a single row.

  • Primary Id: id
{-# LANGUAGE FlexibleContexts #-}
{-# LANGUAGE ScopedTypeVariables #-}
{-# LANGUAGE TypeFamilies #-}
{-# LANGUAGE UndecidableInstances #-}
module Main where
import Data.Kind
main :: IO ()