Add end-to-end application examples in the documentation

It would be great to show some real usage examples in the docs. Ideally we would have examples for both architectures:

1. Managed architecture - the DB and app are deployed together in one manifest.
2. Referenced architecture - the DB is created via Terraform and its ID injected into the app manifest before deployment (also via Terraform).