Data type for sheet like data?
I have been doing evaluating Convex recently but couldn’t find answer to this. I have bunch of data sheets which have dynamic structure, user can define columns and rows dynamically. If i would do this with postgres directly i would probably make sheets table with jsob column, i couldn’t find anything similar from Convex. I could use Convex arrays and record types but arrays have max length of 8192. Most likely i dont hit the limit but it would be nice that I shouldn’t have to worry about that? What kind of schema would you build around this?
1 Reply
Thanks for posting in <#1088161997662724167>.
Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets.
- Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.)
- Use search.convex.dev to search Docs, Stack, and Discord all at once.
- Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI.
- Avoid tagging staff unless specifically instructed.
Thank you!