Hi @Victor,
I am a long time user of AWS, as for S3 vs ImgIX, I am not that familiar with ImgIX to be honest (I have used other alternatives in the past), but I believe ImgIX is only a compressor, still needs S3 as storage provider. For that compressor I use ImagekitIO, the support is quite great and has a generous free tier (20GB). You can also use CloudFront (AWS) for CDN, or in my case Cloudflare (They have a good free plan) and it works with AWS.
I do agree 100% with you, it is not easy to setup, it takes some time to get the hang of it (In my opinion it is the downfall of AWS in converting beginners to the business), But I think it is a great solution for storage and one the cheapest in the Market.
Regarding Airtable speed, I cannot really tell now, but I can do a couple of tests during weekend “FilterByFormula vs Views”.
So mainly yes, 100 records, that is why I use the view also to filter only 100 records when possible (the booking system case where I only filter the next 90 days). Very useful to pull most recent records.
Hopefully I will have more time to make some more videos regarding AWS, I just released one in how to use with Integromat, but waiting for Adalo team to tell me if images are deleted or not from Adalo side (I tested and it does not seem that way so far).
I have this going on: HOW storage works
Would be great if Adalo team would clarify.