A suggestion that may integrate a lot of ideas which have been previously suggested…
I think an integration between Ragic and Coda would be stunning and would simultaneously address many of the issues we have discussed here. It scales to a million or more records and it can handle many of the database-oriented use cases not quite within Coda’s capability and it can sync with an external data source automatically. Of course Coda excels in the presentation; Coda is the ultimate front-end whereas Ragic would be a great back end to feed data to Coda.
To integrate these one would essentially use the Ragic API and/or new Coda API to match specific tables between the two and then update or Sync Coda on a regular basis with the corresponding tables in Ragic.