CAP development guidelines recommendSQLiteas the default database for local development because:
It requires no installation.
It supports CDS features needed for rapid prototyping.
It enables quick testing without deploying to SAP HANA.
For productive deployments, SAP HANA or SAP HANA Cloud is used, but SQLite remains the recommended local option.
Incorrect choices:
A – NoSQL:CAP does not support NoSQL databases as primary stores.
C – PostgreSQL:Supported via adapters, butnotthe recommended development default.
D – HANA Cloud:Used for production, not recommended for local development.
[References:, CAP Documentation – Local Development Databases, CAP Node.js / Java Developer Guide – “Use SQLite Locally”, ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit