How to store long lists in Convex DB, i.e. a user's known foreign words?
My app has an aspect of reading comprehension assistance for foreign languages. It shows word-level translations for foreign language text. My app shouldn't show a translation for a given foreign word if a user already knows it.
I am trying to store a user's "known words" for a given language. That list can get pretty long: a typical American 8th grader would know ~25,000 English words.
Looking at the documentation, there's some database limits that I don't know how to accommodate:
1) Number of documents scanned in a query: 16,384
2) The column data type, Arrays, can have at most 8192 values.
3) The column data type, Objects can have at most 1024 entries.
I am trying to store a user's "known words" for a given language. That list can get pretty long: a typical American 8th grader would know ~25,000 English words.
Looking at the documentation, there's some database limits that I don't know how to accommodate:
1) Number of documents scanned in a query: 16,384
2) The column data type, Arrays, can have at most 8192 values.
3) The column data type, Objects can have at most 1024 entries.
