Conversation

Does anyone have a nice way of storing ADTs/variants/discriminated unions in PostgreSQL?

3

4

Brendan Zabarauskas

I remember seeing a few articles around on this, for example this one:

Sum Types for Relational Databases

There are a few ways to encode sum types in relational databases. Not so long ago I was thinking about the same problem and came up with slightly different solutions.

1

2

Brendan Zabarauskas

Replying to

and

Also this one, by

: parsonsmatt.org/2019/03/19/sum

11:52 PM · Mar 18, 2021Twitter Web App

Replying to

and

Thank you

1

Brendan Zabarauskas

Note: I've never had a chance/reason to use these personally (haven't done any database stuff in a long time), so can't vouch for any techniques pros and cons. But hope it helps you! 😊

1