Limit how much values fit into an array

[vast cedar]

I found no way to limit the amount of values fit into an array, so I open this as a feature request.

I need something that matches this SQL implementation:

    string_array TEXT[] CHECK (cardinality(string_array) <= 3)

[slim lotus]

interesting. you can just check in the mutation, right? if (doc.arrayField.length < 3) { db.patch(..) }

[vast cedar]

yes, that would be a solution.

[vast cedar]

But it would be nicer to have immediately a type-error if there is the possibility that we insert too many (like we get a type error for the wrong type etc.)

So that it can't happen in the first place that you insert to much items in an array

[vast cedar]

This could be implemented with tuples and that stuff right?

[echo wraith]

The general recommendation for more complex validation is to use something like Zod, there's a guide for integrating Zod into your schema here: https://stack.convex.dev/typescript-zod-function-validation

[vast cedar]

I don't want to validate function arguments. I want to limit how much data can fit into my database. for example if I have a v.array() field in my db I want to limit how much can fit into this array

[echo wraith]

Oh are schemas not covered in that article

[vast cedar]

in SQL it would be:

    string_array TEXT[] CHECK (cardinality(string_array) <= 3)

[echo wraith]

You can use Zod for advanced schema validation, there are helpers for it, finding now

[vast cedar]

ok

[echo wraith]

A lot of good stuff from the team here, including some info from Ian about extending Zod/Convex usage to schema definition: https://discord.com/channels/1019350475847499849/1186112627462647819

Also includes a breakdown from Jamie on why validation is limited currently