Hi,
I see that the no code movement is very popular but one thing that I cannot find about is:
How do people scale no code apps without changing or optimizing code / database queries?
Is it just throwing a lot more money at the problem and hoping it will solve scaling issues?
The idea with nocode is to enable millions of people to build products and in most cases those products will be small to medium and there will be less need to do large scale optimizations. This being said the platforms themselves that provide nocode solution need to have good enough system to scale to millions of use cases and data entries.
No code should just be a way to test your business and find product market fit. If it's growing and making money then it's time to actual make the platform using real dev tools which give your more control over your app and business. What if those guys shut down or something you never know.
Most no-code apps are small to medium scale.
Optimization in the codebase and data queries belong to the no-code providers. The point is to take away technical matters (scaling, optimizing) from the users. So technically, users can't really worry about optimization at low-level.
Though, users can optimize by design better data collection, avoid having too much data at the same page, compress image (some providers take care of this too).
In term of database, some 3rd-party managed database have limits. And the no-code provider can't control. For example, Google Sheet has 5M rows limits or Airtable has 500k rows limit on Pro plan