BlogBlogtypeA post on somebody's own site or a community platform. Nobody edits it after publication, so it dates from the day it was written.See every one →SAP Community

SQLite as database for a multi-target (/productive) CAP Application

Opens with "Not recommended but possible", and then names the two cases where it is the right call anyway: a showcase, and a landscape with no HANA Cloud available. The caveat is the content.

Where it sits

Explains
Database connectorsCAPDatabase connectorscapabilityConnecting an application’s data model and queries to a database, including the differences in supported queries, types and schema management between database implementations. Changing an existing schema belongs to [schema evolution](capability:schema-evolution).DeploymentCAPBTPDeploymentcapabilityGetting an application onto a runtime and keeping it there: build descriptors, deployment topology, service bindings and lifecycle operations. The target runtime determines how the application is packaged and configured.
Since then
Database connectors has changed twice since this was published, most recently in @sap/cds 10.1.0, 2026-09-07
Source
reachable

Who is behind it

Christopher_Ketzlerauthor

Before you read it

read from the page
ApplicabilityCore changedDatabase connectors has changed twice since this was published, most recently in @sap/cds 10.1.0, 2026-09-07.

This is a derived prompt to re-check the work, not a claim that the work is wrong. Exact stale statements are recorded separately after editorial review.

Properties

About this work

declared and crawled
Published
declared
Published on
declared
Views
crawled
3,996

What was found on the page

derived
Prose
derived
592 words
Numbered steps
derived
7
Code blocks
derived
6

For database-connectors

on the edge
Applies in
authored
cap

For deployment

on the edge
Applies in
authored
btpcap

More on this94

Group by94 of 94 pieces
Piece, what it offersStill applies
Also explainingDatabase connectors94
CAP Foundry: Engineering SAP CAP Applications from Business Intent with Guardrailed AI
SAP Community, Shahid
nothing recorded
Connect SAP CAP (Node.js) to On-Premise/Private PostgreSQL using SAP Cloud Connector
SAP Community, KalaikovanThe reasoningA recipe
Core changed
SAP BTP Account Architecture Best Practices: A Practitioner's Field Guide
SAP Community, basanireddy
nothing recorded
Autonomous Diagnostics on Kyma Unplugged: Goose + LiteLLM + KRO + SAP AI Core in Production
SAP Community, quovadis
nothing recorded
From Concept to action: Hands-On with the CAP Operator and the Partner Reference Application
SAP Community, ChristianWeissThe reasoningA recipeRunnable code
nothing recorded
Fullstack CAP Application with HANA Cloud (Decoupled Architecture) [Part-6]
SAP Community, sanjucsThe reasoningA recipe
nothing recorded
Fullstack CAP Application with HANA Cloud (Decoupled Architecture) [Part-4]
SAP Community, sanjucsThe reasoningA recipe
Core changed
Fullstack CAP Application with HANA Cloud (Decoupled Architecture) [Part-3]
SAP Community, sanjucsThe reasoning
nothing recorded
Fullstack CAP Application with HANA Cloud (Decoupled Architecture) [Part-1]
SAP Community, sanjucsThe reasoningA recipeRunnable code
Core changed
Build BTP CAP App with Fiori Integration – Part 2: Implementing End to End App
SAP Community, SuryaRamesh, part 2 of 2The reasoning
nothing recorded
Building a CAP App with Fiori Integration – Part 1: Environment & HANA Cloud Setup
SAP Community, SuryaRamesh, part 1 of 2The reasoning
nothing recorded
SAP CAP on HANA XSA: Scaling Industrial Data Applications Beyond the Cloud
SAP Community, rgadirovThe reasoningRunnable code
Core changed
Part 2: Creating and Deploying a CAP Application with PostgreSQL, Hyperscaler Option
SAP Community, yashbhosle789, part 2 of 2The reasoningA recipe
Core changed
Part 1: Creating and Deploying a SAP CAP Application with SAP HANA on SAP BTP (Cloud Foundry)
SAP Community, yashbhosle789, part 1 of 2The reasoningA recipe
Core changed
Receive Events from Event Mesh of Integration Suite to CAP Node.js Applications
SAP Community, KevinWang_ST_Consultancy
nothing recorded
Part 2: Runtime Architecture & Cost efficiency gains
SAP Community, ChristianWeiss, part 2 of 3The reasoning
nothing recorded
Kyma Evolution: Transforming SAP Kyma into a tailor-made SaaS Platform for sbs extensions
SAP Community, ChristianWeiss, part 1 of 3The reasoning
nothing recorded
Streamlined Kyma deployment for CAP applications
SAP Community, rupamaity
nothing recorded
Event Driven SAP CAP on Kyma with Agentic AI and UI Auto Refresh
SAP Community, ShahidThe reasoning
nothing recorded
Adding Shell Plugin to SAP Fiori CAP Application and Deploying to Cloud Portal Service
SAP Community, Abhinandan2The reasoning
nothing recorded
Create a CAP Application with SAP HANA Cloud from Scratch and Deploy to Cloud Foundry
SAP Community, MaheshSirsat1708The reasoningA recipe
Core changed
Quickly Deploy a Sample CAP Application to BTP
SAP Community, AminAlmarsafyThe reasoningA recipe
nothing recorded
Creating a Hybrid CAP (Node.js) Profile with PostgreSQL on BTP from Business Application Studio
SAP Community, valentincadartThe reasoningRunnable code
Core changed
Joule Studioがリリースされたので早速CAPアプリを自然言語で操作するカスタムスキルを構築してみた
SAP Community, takayuki_tanaka
nothing recorded
Exploring Application Frontend Service: Deploying the UI of an MTA App
SAP Community, MioYasutakeThe reasoningRunnable code
nothing recorded
Deploying first CAP Project in SAP Cloud : A Step-by-Step Guide
SAP Community, satyanarayanpradhanThe reasoning
nothing recorded
🚀 秒速で学ぶ SAP AI Core Agent 開発 🚀 - Part 8 CloudFoundry にデプロイ
SAP Community, Ryota_Ito
nothing recorded
DevOps with SAP BTP
SAP Architecture Center, SAP Architecture CenterThe reasoningA reference
nothing recorded
Build, Configure, and Deploy SAP CAP Projects to the Cloud
SAP Community, DhanushwarThe reasoningA recipe
nothing recorded
Lets Talk to the Database - CAP & SQLite Powered by Google Gemini-2.5-Pro
SAP Community, ShivamShuklaSAPThe reasoning
nothing recorded
SAP CAP With Prostgres Serice in BTP
SAP Community, satya-dev
nothing recorded
A 25x faster mta.yaml build for SAP CAP Node.js projects
SAP Community, Mauricio LaufferThe reasoning
nothing recorded
Using HANA Cloud’s "VECTOR_EMBEDDING" Function in CAP
SAP Community, Mio YasutakeThe reasoningRunnable code
nothing recorded
Architecting Multi-Region HA/DR resiliency patterns
SAP Architecture Center, SAP Architecture CenterThe reasoningA reference
nothing recorded
The fastest way to a deployable CAP app on SAP BTP Cloud Foundry
SAP Community, Daniel SchlachterThe reasoning
nothing recorded
SAP CAP Lessons Learned: SQLite is single threaded, HANA is not
SAP Community, LucasMagriniRigo
nothing recorded
SAP CAP Lessons Learned: Run a CAP app using SQLite on SAP BTP - Cloud Foundry
SAP Community, LucasMagriniRigoThe reasoning
nothing recorded
Deploy and Run the Incident Management Application in the SAP BTP, Kyma Runtime with a Mock Server
SAP Developer Center, Grzegorz KaraluchThe reasoningA recipe
Core changed
Speed up deployment for CAP using Turborepo
SAP Community, Jakob Marius KjaerThe reasoningRunnable code
Core changed
Configure an SAP CAP Application to Connect to an SAP HANA Cloud Database in Another Global Account or Subaccount
SAP Community, JhoelAnthonyRamosRomeroPEThe reasoning
nothing recorded
Using Postgresql Database in Cloud Application Programming model
SAP Community, Arun KrishnamoorthyThe reasoningA recipeRunnable code
Core changed
Sharing SAP HANA Cloud instance to multiple subaccounts and creating HDI containers
SAP Community, Kazuhiko TakataThe reasoningRunnable code
Core changed
2024/01最新版!Productivity Toolsを使ったCAPバックエンド開発②~HANA Cloud編~
SAP Community, takayuki_tanakaA recipe
Core changed
CAP PostgreSql setup local debugging using Docker - Part 2
SAP Community, ramonlee5A recipe
Core changed
CAP with PostgreSQL DB alternate to HANA Cloud DB - Part 1
SAP Community, ramonlee5The reasoning
nothing recorded
Open Sourcing CAP – how to learn more or get involved
SAP Community, Fempel
nothing recorded
SAP BTP - KYMA - SERVICE MESH
SAP Community, maxi1555The reasoning
nothing recorded
Simplifying SaaS Self-Onboarding Automation using Terraform in Kyma and Cloud Foundry
SAP Community, martinfrickThe reasoning
nothing recorded
SAP CAP (Java) with Amazon Aurora PostgreSQL
SAP Community, shanthakumar_krishnaswamyThe reasoningA recipeRunnable code
Core changed
SAP CAP (Java) with Azure Cosmos DB for PostgreSQL
SAP Community, shanthakumar_krishnaswamyThe reasoningA recipeRunnable code
Core changed
Run and Deploy SAP CAP (Java) with PostgreSQL using Official Database Adapter @cap-js/postgres
SAP Community, shanthakumar_krishnaswamyThe reasoningA recipeRunnable code
Version drift
Lets Deep dive into CAPM and HANA Cloud --> HANACap
SAP Community, shivamshukla12The reasoningRunnable code
Core changed
Run and Deploy SAP CAP (Node.js or Java) with PostgreSQL on SAP BTP Cloud Foundry
SAP Community, TiaXuThe reasoningA recipeRunnable code
Core changed
A modern workflow for SAP Cloud Integration with CAP and Azure DevOps
SAP Community, marcel_schork62The reasoning
nothing recorded
Tips for running CAP nodejs in SAP BTP
SAP Community, Mauricio LaufferThe reasoningRunnable code
Core changed
从BTP Launchpad里的sapui5应用里调用部署的CPI IFLOW
SAP Community, Jacky_Liu1
nothing recorded
#BTP #SAPCAP: Quirky Nuggets (N03-N04)
SAP Community, Ajit_K_PandaThe reasoningA recipeRunnable code
Core changed
SAP SuccessFactors extensibility easy with SAP BTP, Kyma runtime
SAP Community, quovadisThe reasoningRunnable code
nothing recorded
Multitenant SaaS applications on SAP BTP using CAP? SAP BTP, Kyma Runtime!
SAP Community, martinfrickThe reasoning
nothing recorded
Run and Deploy SAP CAP (Java) with PostgreSQL on SAP BTP Cloud Foundry
SAP Community, shanthakumar_krishnaswamyThe reasoningRunnable code
1 stale part
Surviving and Thriving with the SAP Cloud Application Programming Model: Deployment to SAP BTP, Kyma runtime
SAP Community, maxstreifenederThe reasoningA recipeRunnable code
Core changed
SFSFとHANA Cloudを使用するCAPのアプリケーション開発
SAP Community, rasaiA recipeRunnable code
Core changed
How to create an API to run a HANA Cloud Stored Procedure in Cloud Foundry
SAP Community, gonzalo_hernan_sendraThe reasoningRunnable code
Core changed
Upload data from excel in CAP (Node.js)
SAP Community, KM11Runnable code
Core changed
Distributed Resiliency of SAP CAP applications using SAP HANA Cloud (Multi-Zone Replication)
SAP Community, shanthakumar_krishnaswamyThe reasoning
nothing recorded
HTML5.Timeout for CAP destinations in mta.yaml longer than default
SAP Community, NilsJanen
nothing recorded
Useful CAP CDS and Fiori Commands to Accelerate Development and Deployment
SAP Community, TiaXu
nothing recorded
Testing your CAP HANA Artifacts with jest – including multitenancy, hdbprocedure and hdbview
SAP Community, TristanThe reasoningA recipeRunnable code
Core changed
How I migrated my on-prem xsa cds3+hana solution to cds6+sqlite
SAP Community, alex_myakinkiiThe reasoningRunnable code
Core changed
CAP on Kyma - Deploy your CAP apps to SAP BTP, Kyma Runtime
SAP Community, Uwe_KlingerThe reasoningA recipeRunnable code
Core changed
The new way to consume Service Bindings on Kyma Runtime
SAP Community, Uwe_KlingerThe reasoningA recipeRunnable code
nothing recorded
SAP CAP - Optimize your build MTA projects with several ui apps
SAP Community, maxi1555The reasoningA recipe
Core changed
Extend SAP SuccessFactors on SAP BTP with CAP - Deploy to SAP HANA Cloud
SAP Community, ale_biagiThe reasoning
nothing recorded
Build and deploy a CAP Project Node.js API with a SAP Fiori Elements UI and a managed approuter configuration
SAP Community, jlongThe reasoningA recipeRunnable code
Core changed
Dynamic OData from "any" API through SAP BTP Kyma
SAP Community, GunterThe reasoningA recipeRunnable code
nothing recorded
Create a Business Service using CDS, Node.js, SQLite and a OData service
SAP Community, raybantonThe reasoningA recipeRunnable code
Core changed
Deploying CAP services with the in-memory SQLite database
SAP Community, liam_mischewskiThe reasoning
nothing recorded
From R/3 ABAP to CAP/Fiori Elements on SAP BTP- Deployment
SAP Community, former_member231477Runnable code
Core changed
cds deploy to sqlite in-memory database
SAP Community, AndrewBarnard
nothing recorded
Simple steps to deploy your CAP project to HANA cloud
SAP Community, OmPrakashJhaThe reasoning
nothing recorded
SAP BTP Showcase - Use SAP Cloud Application Programming to do Native Development on HANA Cloud
SAP Community, former_member271284The reasoningA recipeRunnable code
Core changed
SAP BTP Showcase – SAP Continuous Integration and Delivery (SAP CI&D) for SAP HANA Cloud
SAP Community, gcalixtosThe reasoningRunnable code
Core changed
SAP Business Application Studio – Using SAP HANA Tools with SAP Cloud Application Programming Model projects
SAP Community, Former MemberThe reasoningA recipeRunnable code
Core changed
My Learnings in SAP-CAP Using MongoDB
SAP Community, krish469The reasoningRunnable code
Gone quiet
SAP Cloud Application Programming Model(CAP):概要およびデモ - Part 1
SAP Community, rasai, part 1 of 2
nothing recorded
Deploying a CAP Application to SAP Cloud Platform, Kyma runtime & connecting an iOS app
SAP Community, KRiedelsheimerThe reasoning
nothing recorded
First Java Cap Application
SAP Community, bruce_wang3
nothing recorded
Run and Deploy CAP with PostgreSQL on SAP BTP Cloud Foundry (Node.js)
SAP Community, Mike ZaschkaThe reasoningRunnable code
1 stale part
The Future of Continuous Delivery for SAP Cloud SDK and SAP Cloud Application Programming Model
SAP Community, Florian WilhelmThe reasoning
nothing recorded
Getting started with CAP on PostgreSQL (Node.js)
SAP Community, Mike ZaschkaThe reasoningRunnable code
1 stale part
PostgreSQL persistence adapter for CAP (Node.js)
SAP Community, Volker BuzekThe reasoningRunnable code
Superseded
cf-create-app: Create End-to-End apps and deploy to Cloud Foundry in minutes
SAP Community, former_member604013The reasoningA recipeRunnable code
Core changed
Use SAP HANA as the Database for a CAP Java Application
SAP Developer Center, SAPThe reasoningA recipe
nothing recorded
Deploy a Full-Stack CAP Application in SAP BTP
SAP Developer Center, SAPThe reasoningA recipe
nothing recorded

Details

Graph4 edges
POINTS OUT →
explainsDatabase connectorscapability, core and community
explainsDeploymentcapability, core and community
published onSAP Communitypublishing source
discovered viaSAP Communitycap-tag
Source
Type
blog
Published on
Host
community.sap.com
First seen
History2
  • explains → applies_to on capability:database-connectors (cap); capability:deployment (cap, btp)Door scope proposed from the title and summary, so a door page lists the piece only where it holds (docs/concepts/content-on-doors.md).
  • Entered the atlasDiscovered via SAP Community · cap-tag.
For your agent
Ref
content:sqlite-as-database-for-a-productive-cap-application
JSON
/content/sqlite-as-database-for-a-productive-cap-application.json
MCP
Connecting an agent