cds-dbs icon indicating copy to clipboard operation
cds-dbs copied to clipboard

[PARKED:] feat: deploy only tables

Open BobdenOs opened this issue 11 months ago • 1 comments

Description

Deploying views takes time. So this PR solves that problem. By not deploying the views.

By not relying on the views it is possible to:

  • Use rolling app deployments
    • (e.g. two versions of the same app using the same persistence)
  • Skip deployment when only views are changed
    • (or do schema evolution on tables)
  • Host multiple different models in the same app
    • (e.g. canary tenants)
  • Flatten projections
    • (e.g. rename all columns only once)
  • Optimize joins away
    • (e.g. SFlight with 7 layers of joins while a single column is selected)
  • Cache query optimization in the app layer
    • (removing/reducing execution plan processing times)
  • Define more views

BobdenOs avatar Jul 28 '23 09:07 BobdenOs