Let me help you out with some insights on Bubble and how it might work better for your real estate website.
The good news is, Bubble allows you to paginate your data, so you won’t have to load all the listings at once. Instead, you can load smaller chunks, making things faster and smoother for users. You can achieve this using Bubble’s repeating groups, which let you display a set number of items per page, with handy navigation for users to browse through different pages.
Now, Bubble is a no-code platform, so there might be some limitations, especially if you need really unique or complex features. But for a real estate site with lots of listings, it should work pretty well. The actual limitations will depend on your specific needs and how complex your project is.
As for using Airtable as your main data source and updating Bubble via Airtable’s API, that’s totally doable! Bubble has a built-in API Connector that lets you hook up to external APIs like Airtable’s. You can use this to pull data from your Airtable base and update your Bubble app in real-time. Plus, you can use Bubble’s workflows to create, update, or delete records in Airtable. It’s a nice way to keep everything organized while still taking advantage of Bubble’s visual development features.