Looking for advice on an external db - limited skills outside of no-code

Need help Database
1

Hey all I need to host 20k worth of records somewhere.

I am getting the data in json format and need to upload it somewhere, it needs to be searchable and some kind of fuzzy search would be good.

Basically its a list of thousands of products with barcodes, description and dietry requirements.

I’m building the app in bubble but I’m worried first about WU units when uploading all the data.

I have limited skills outside of bubble, I can use Xano a little bit but I’m wondering if it is the best option or not.

Anyone with expertise in external DB’s, i’d love to hear an opinion

2

Algolia depending on what these records are for or xano.

3

Yeah Algolia, didn’t think about that.

I’ll look into it, thanks Chris

4

Admittedly I am not a WU expert nor an API expert, but I do think it’s worth doing a few test uploads with smaller sizes to get an idea of the upload calculation. In Josh’s April post, the WU weights listed ‘0.5 WU for each item written to or modified in the database’. I’m not sure in this if ‘item’ is the same thing as a ‘thing’ (thing usually meaning a whole row) or simply 1 cell’s value per column. If it is a ‘thing’, 20K records should be around 10K WU, well within the 100K ‘free’ WU available in Dev. If so…it may be worth it to keep it all within Bubble and avoid the APIs necessary to/from.

5

@nick.carroll or anyone else with Bubble- can you clarify on the chart Josh shared on what an ‘item’ is in regards to a ‘thing’?

image
image2220×3944 475 KB

1 Like
6

We seem to use item and thing somewhat interchangeably. Lets say you have 100 products in your database (Product data type), we would say there are 100 things or items in your database of type Product. Hope this helps!

1 Like
7

That’s what I figured / hoped but glad to hear it confirmed. Thanks!