topic Re: Sync an API with a hubdb in CMS Development

Sync an API with a hubdb

BBecker1 — Tue, 28 May 2024 11:29:33 GMT

Hello,

I was wanted to know what would be te best approach for my problem. I am looking to create a website wich shows for example "cars" these come from a API that has 35.000 cars in it. These cars should have their own pages so my first tought is to sync the api with a hubdb and check the dynamic pages in hubdb to create this. this way its also easier to get data.

The api changes a few times a day so syncing the hubdb with the api once or twice a day.

How would I create or find a proper solution for this problem?

(Or would it be better to create a private app that handles this?)

Re: Sync an API with a hubdb

Teun — Tue, 28 May 2024 12:10:07 GMT

Hi @BBecker1 ,

Using HubDB is a great fit for a use-case as you are describing. However, there is a limit that you have to keep in mind. Currently, the limit is 10.000 rows per HubDB. So storing all those cars in a single HubDB and using that HubDB table to create dynamic detail pages is not possible.
If you have an Enterprise subscription, you could also look into Custom Objects, as you can create dynamic detail pages using custom objects as well.

Re: Sync an API with a hubdb

BBecker1 — Tue, 28 May 2024 13:11:12 GMT

Ah, Totatly forgot about the limit! Will look into to the custom objects this looks to be more suitable for my problem.