Limit to the number of items in an array/bubble List?

Need help Database
1

Greetings, folks. Rookie bubbler here, first post.

Is there a limit to the number of items that can be in a list? For example, say I have a data type/table called Coin. And I want to create a link between User and Coin to manage a user’s coin collection. So I create a field on User called “coins” and define it as a List of Coins. Is there a maximum number of Coins that can be placed into that user’s “coins” field? i.e. a max number of array items/unique IDs pointing at the Coin table

Thanks!

2

Hi there, @ThatFizzGuy… there is a limit on the number of items that can be in a list, and that limit is 10,000. That being said, it is pretty well documented that including more than 100 items in a list is not ideal from a performance perspective, so you might be better off scrapping the list and just searching the Coin data type when you need the data for a specific user’s coin collection.

Hope this helps.

Best…
Mike

4 Likes
3

@mikeloc thanks very much for the prompt response! I found the list cap here, as you eluded to:
https://manual.bubble.io/core-resources/data/operations-and-comparisons#list-of-things

Any chance you can point me to that “well documented” suggestion of not listing more than 100 items? If not, no worries, I’ll definitely do some more searching!

Related, does Bubble say what their backend database is? I’ve been assuming it leverages a “document database” like Mongo, but your above suggestion makes me wonder if that’s true. Does Bubble document what type of Db they use/have created?

Thanks again!

4

Bubble uses a PostgresSQL database hosted on AWS.

One of the places where the 100 item thing is mentioned is in the example scenarios section of this article from Bubble. However, if you do searches around Bubble and performance, you will find no shortage of reading material on the subject.

1 Like
5

Awesome, thanks again @mikeloc ! Greatly appreciated.

1 Like