5 replies

Schema Design for DynamoDB with Variable Sort Keys

I'm looking for a bit of guidance on something.

I'm trying to create a dynamodb schema to match an existing one that already exists. I've got a couple of indexes that end up getting used in different ways depending on the type of object being stored, and I'm trying to figure out a good way to model that in schema. For instance, in one type, the sort_key is a constant, we'll call it 'X' for the time being, and in another it's 'Y-<uuid>'. I can think of a couple of ways to do this, but I'm looking for experience here.

My first thought is to have a union of possible options for the sort_key value.

S.Struct({pk: S.UUID, sk: S.Union(S.Literal('X'}),S.String.pipe(S.startsWith('Y-'), S.endsWith(S.UUID))});

S.Struct({pk: S.UUID, sk: S.Union(S.Literal('X'}),S.String.pipe(S.startsWith('Y-'), S.endsWith(S.UUID))});

This seems like it is going to get hard quite quickly as I add more and more of what is going on with the repository.

The other option I can think of is to have a base class, and then override it:

S.Struct({pk: S.UUID}).pipe(S.extend(S.Struct({sk: S.String.pipe(S.startsWith('Y-'), S.endsWith(S.UUID))});

S.Struct({pk: S.UUID}).pipe(S.extend(S.Struct({sk: S.String.pipe(S.startsWith('Y-'), S.endsWith(S.UUID))});

Has anyone had to deal with a situation like this and had better luck with a particular approach?

Effect Community•2y ago•

5 replies

elchapitan

Schema Design for DynamoDB with Variable Sort Keys

S.Struct({pk: S.UUID, sk: S.Union(S.Literal('X'}),S.String.pipe(S.startsWith('Y-'), S.endsWith(S.UUID))});

S.Struct({pk: S.UUID, sk: S.Union(S.Literal('X'}),S.String.pipe(S.startsWith('Y-'), S.endsWith(S.UUID))});

This seems like it is going to get hard quite quickly as I add more and more of what is going on with the repository.

The other option I can think of is to have a base class, and then override it:

S.Struct({pk: S.UUID}).pipe(S.extend(S.Struct({sk: S.String.pipe(S.startsWith('Y-'), S.endsWith(S.UUID))});

S.Struct({pk: S.UUID}).pipe(S.extend(S.Struct({sk: S.String.pipe(S.startsWith('Y-'), S.endsWith(S.UUID))});

Has anyone had to deal with a situation like this and had better luck with a particular approach?

Schema Design for DynamoDB with Variable Sort Keys

Similar Threads

Schema Design for DynamoDB with Variable Sort Keys

Similar Threads

Similar Threads

Similar Threads