Creating large data sets (Looping)

Also I will be honest: keep doing what you’re doing, but if you start to run into issues with bulk data manipulation, I see a lot of people repping Xano as a backend alternative. I think it integrates well into Bubble, worth taking a look if you need to scale. There’s some threads about how to set it up but it does cost more of course.

Also, just today I ran into an issue where quotes in the dynamic fields were breaking the JSON format and not creating new things.

When you do the :formatted as text, delete the quotes only around the dynamic fields then click More... after each dynamic field and do :formatted as JSON safe

The JSON safe operator adds those quotes back in and escapes all the special characters like quotes.

Essentially you set up a dummy template on the ‘cart’ side so you are copying a list from the same data type.

The messy part comes when maintaining products as you need to keep the cart ‘template’ in sync.

Splitting up the copy into batches of 50 is fairly easy, and at this scale you are unlikely to be generating a list anywhere, so don’t run into data consistency issues with that.

It is still not instantaneous, but is another possibility along with the bulk create.

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.