Uniqueness and idempotency

tupui / soroban-versioning

Tansu - Soroban Versioning

https://tansu.dev

Other

4 stars 3 forks source link

Uniqueness and idempotency #19

Closed tupui closed 3 months ago

tupui commented 3 months ago

Event records are unique and we should prevent double ingestion.

Evaluate:

Composite primary keys
Surrogate index
Uniqueness on multi-columns
Other?

tupui commented 3 months ago

Closed by f6e2c52f3357533032fa1564401620e92cd93916

I went with uniqueness on multi-columns to keep primary key logic simple for every DB consumer. This has an impact on write performance but we should be good for a while before having to do fancier things (e.g. partition by ledger could solve it all quite easily.)