I'm trying to create an attribute members that will store the documentId of certain users. Was thinking of using a String array attribute for this. What's the maximum size for an array when creating an attribute?
#[SOLVED] Size of array attribute in Appwrite collection
tropic hound
viral olive
The array it self would be a longtext which in MariaDB has a limit of 4,294,967,295 https://mariadb.com/kb/en/longtext/#:~:text=Description,232 - 1 )%20characters.
So if you store Appwrite id's inside an array in such a field and every ID is 20 characters that's means you can store roughly 171,798,691.8 IDs
tropic hound
The array it self would be a longtext which in MariaDB has a limit of 4,294,967,...
That's perfect. Thanks a lot 😄