What I recommend is sticking to the Adalo database, you’re already paying for it. Also, remember that for external collections it requires complex filtering (it gets easier when you do it alot) to filter your data, Adalo makes it so easy.
Also, check out some advice from a developer:
Here’s some videos to help you get started on API’s & external collections. (if you’re going to do it)