@cap-js/sqlite
The SQLite service, in memory during the inner loop — which is why a CAP project runs before anyone has provisioned a database.
Facts
Where it sits
Who is behind it
In the atlas: maintains 34@cap-jsmaintainerJohannes VogtContributes to this
In the atlas: maintains 1, contributes to 28, wrote 10@AkatuoroArley Triana MorinContributes to this
In the atlas: contributes to 9, wrote 1@arleytmAndreas SchmidtContributes to this
In the atlas: contributes to 6@aschmidt93Bob den OsContributes to this
In the atlas: contributes to 13@BobdenOsAndre MeyeringContributes to this
In the atlas: contributes to 10@bugwelleCAP BotContributes to this
In the atlas: contributes to 5@cap-botsChristian GeorgiContributes to this
In the atlas: maintains 1, contributes to 53@chgeoChristian SchüringsContributes to this
In the atlas: contributes to 25@cschueringsDaniel HutzelContributes to this
In the atlas: contributes to 32, wrote 3@danjoaDaniel O'GradyContributes to this
In the atlas: contributes to 10@daogrady35 contributors
Before choosing this
Conditions
LicenceSAP Developer License Agreement 3.2 CAP§ 1, 2, 3A cds-plugin is used with SAP CAP materials, or an artifact is explicitly identified as a CAP plugin or application.
- § 1 License. Productive customer applications are limited to SAP BTP or another SAP-licensed platform, and mass extraction to a non-SAP product is restricted except where solely required for SAP interoperability.
- § 2 Intellectual Property. The agreement retains SAP's rights in the covered materials and limits making APIs, tools or software available to third parties, while preserving ownership of customer applications subject to SAP's underlying rights.
- § 3 Artificial Intelligence Training. The agreement prohibits use of the covered materials and customer applications for training artificial-intelligence models or systems.
Also, from Database connectors§ 1: The connector itself does not decide the licence boundary. Section 1 makes the destination and purpose of extraction relevant, including the scoped exception for interoperability with an SAP product.
What it declares
Every artifact
- Type
- CDS plugin
- Origin
- By SAP
As a CDS plugin
- Declared for
- ^10
- Distributed through
- npm
Connections
Connecting a data model and its queries to a database
Value-help recommendations and SAP AI Core as a CAP service
CAP caching plugin for query results and remote service responses
Demo CAP bookshop with server-rendered UI5 views
Serves a Vite app through cds watch and imports .cds files
Six CAP features in one package, from replication cache to rate limits
Data federation for CAP via delegation, caching and replication
Monorepo of CAP's SQL database services
Download
Install
npm add @cap-js/sqliteDerived from the package name. No recipe recorded; the README has the configuration.
README
quoted from cap-js/cds-dbs under Apache-2.0, readCDS database service for SQLite
Welcome to the SQLite database service for SAP Cloud Application Programming Model Node.js, based on streamlined database architecture and better-sqlite driver.
Setup
If you want to use SQLite for development, all you need to do is to install the database package, as follows
npm add @cap-js/sqlite -D
Learn more about setup and usage in the respective database guide.
Support
This project is open to feature requests/suggestions, bug reports etc. via GitHub issues.
Contribution
Contribution and feedback are encouraged and always welcome. For more information about how to contribute, the project structure, as well as additional contribution information, see our Contribution Guidelines.
Versioning
This library follows Semantic Versioning. All notable changes are documented in CHANGELOG.md.
Code of Conduct
We as members, contributors, and leaders pledge to make participation in our community a harassment-free experience for everyone. By participating in this project, you agree to abide by its Code of Conduct at all times.
Licensing
Copyright 2024 SAP SE or an SAP affiliate company and cds-dbs contributors. Please see our LICENSE for copyright and license information. Detailed information including third-party components and their licensing/copyright information is available via the REUSE tool.
History
Dependencies 1
Notes
Dependencies
- The following workspace dependencies were updated
- dependencies
- @cap-js/db-service bumped from ^3.1.1 to ^3.1.2
- dependencies
Dependencies 1
Notes
Dependencies
- The following workspace dependencies were updated
- dependencies
- @cap-js/db-service bumped from ^3.1.0 to ^3.1.1
- dependencies
- The following workspace dependencies were updated
Features 1, Fixes 1, Dependencies 1
Dependencies 1
Notes
Dependencies
- The following workspace dependencies were updated
- dependencies
- @cap-js/db-service bumped from ^3.0.0 to ^3.0.1
- dependencies
- The following workspace dependencies were updated
Breaking 1, Features 2, Dependencies 1
Dependencies 1
Notes
Dependencies
- The following workspace dependencies were updated
- dependencies
- @cap-js/db-service bumped from ^2.8.1 to ^2.8.2
- dependencies
- The following workspace dependencies were updated
Dependencies 1
Notes
Dependencies
- The following workspace dependencies were updated
- dependencies
- @cap-js/db-service bumped from ^2.8.0 to ^2.8.1
- dependencies
- The following workspace dependencies were updated
Dependencies 1
Notes
Dependencies
- The following workspace dependencies were updated
- dependencies
- @cap-js/db-service bumped from ^2.7.0 to ^2.8.0
- dependencies
- The following workspace dependencies were updated
Dependencies 1
Notes
Dependencies
- The following workspace dependencies were updated
- dependencies
- @cap-js/db-service bumped from ^2 to ^2.6.0
- dependencies
- The following workspace dependencies were updated
Features 2, Changed 1, Fixes 1
Features 2, Fixes 5
Notes
Added
- SELECT returns LargeBinaries as streams unless feature flag "stream_compat" is set (#251) (8165a4a)
- Support Readable Streams inside INSERT.entries (#343) (f6faf89)
Fixed
- config in streaming test with compat flag (#412) (335a178)
- Do not generate UUIDs for association keys (#398) (9970e14)
- make @cap-js/sqlite work with better-sqlite3@9.3.0 (#422) (44c0a59)
- sqlite date string compatibility parsing only for valid dates (#410) (2a8bb2d), closes #409
- UPSERT for @cap-js/hana for entities with multiple keys (#418) (9bbac6e)
Fixes 1
Notes
Fixed
- Adapt implementation to comply with implication of SQLite version 3.43 which is included in
better-sqlite3@8.6.0. #210
- Adapt implementation to comply with implication of SQLite version 3.43 which is included in
Others providing
Compare all 26 on the Database connectors page →- SAP ASE ServiceSAP ASE ServiceSAP ASE database systems and tenant databases on BTP with SAP running the platform operations, used from Java applications on BTP or on premise over SQL, JPA and JDBC.sap official, btpManaged SAP ASE databases on BTP for Java applicationsfrom BTP/BAIP
- SAP HANA CloudSAP HANA CloudThe managed database under most of this: CAP's default target, the store Datasphere and Analytics Cloud sit on, and a service with plans and components.sap official, btpManaged SAP HANA database service on BTPfrom BTP/BAIP
- SAP HANA Service (SAP Regions) for SAP BTPSAP HANA Service (SAP Regions) for SAP BTPManaged SAP HANA 2.0 database systems in fixed sizes from 64 GB to 1 TB, in SAP's own regions, with tenant databases bound to applications on SAP BTP.sap official, btpManaged SAP HANA 2.0 databases in fixed sizes on SAP BTPfrom BTP/BAIP
- PostgreSQL on SAP BTP, hyperscaler optionPostgreSQL on SAP BTP, hyperscaler optionA managed PostgreSQL from the underlying hyperscaler — AWS, Azure, Google Cloud or Alicloud — consumed through a BTP service binding.sap official, btpManaged PostgreSQL from the hyperscaler via a BTP service bindingfrom BTP/BAIP
- com.sap.cds:cds-feature-hanacom.sap.cds:cds-feature-hanaThe CAP Java feature that wires a Maven application to SAP HANA Cloud, the production default among CAP's supported databases.sap official, capSAP HANA Cloud datasource for CAP Java applicationsfrom CAP
- com.sap.cds:cds-feature-jdbccom.sap.cds:cds-feature-jdbcConnects the CAP Java runtime to JDBC databases through the CDS4j JDBC runtime: H2 and SQLite, which capire names for local development and CI tests rather than enterprise use.sap official, capJDBC runtime for H2 and SQLite in CAP Javafrom CAP
- com.sap.cds:cds-feature-postgresqlcom.sap.cds:cds-feature-postgresqlThe CAP Java feature that wires a Maven application to PostgreSQL as its datasource beside SAP HANA, with limitations capire lists: schema evolution first, and no multitenancy or extensibility yet.sap official, capPostgreSQL datasource for CAP Java applicationsfrom CAP
- com.sap.cds:cds-services-bomcom.sap.cds:cds-services-bomThe Maven bill of materials for CAP Java, pinning every com.sap.cds module in a release, from the API and core runtime to the Spring Boot starters and the CQN engine, to the same version.sap official, capMaven bill of materials pinning CAP Java module versionsfrom CAP
- @cap-js/db-service@cap-js/db-serviceThe base every CAP database service is built on: the shared query translation and pooling that SQLite, PostgreSQL and HANA specialise rather than reimplement.sap official, capBase service shared by CAP's SQLite, PostgreSQL and HANA servicesfrom CAP
- @cap-js/hana@cap-js/hanaThe HANA database service — the production default, on the same streamlined architecture as the SQLite and PostgreSQL services.sap official, capSAP HANA database service for CAPfrom CAP
- @cap-js/postgres@cap-js/postgresThe PostgreSQL database service — the production option for running CAP off HANA, sharing the base service with the other three.sap official, capPostgreSQL database service for CAPfrom CAP
- cap-postgres-btp-connectivitycap-postgres-btp-connectivityConnects a CAP Node.js application to a PostgreSQL database that is not publicly reachable, tunnelling through BTP Connectivity and the Cloud Connector.independent, capTunnels CAP Node.js to a private PostgreSQL via Cloud Connectorfrom CAP
- cds-mongodbcds-mongodbMongoDB as a native CAP database service, through Mongoose — CQN reads and writes, managed associations as ObjectId references, $expand resolved by populate, and cds deploy --to mongoose.independent, capMongoDB as a CAP database service through Mongoosefrom CAP
- @cds-pgroll/postgres@cds-pgroll/postgresThe destructive half of PostgreSQL schema evolution — DROP and RENAME, which CAP's own schema_evolution: alter will not perform — driven from the command line beside @cap-js/postgres.independent, capCLI for DROP and RENAME schema changes beside @cap-js/postgresfrom CAP
- hdbhdbSAP's HANA driver for Node.js, written entirely in JavaScript so installing it pulls in no native client, running SQL against SAP HANA and SAP HANA Cloud with streams and prepared statements.sap official, btpPure JavaScript SAP HANA driver for Node.jsfrom BTP/BAIP
- @neoimpulse/cap-js-restore-model-defined-types@neoimpulse/cap-js-restore-model-defined-typesA CAP plugin that casts values back to the types the CDS model declares after a READ, for the entities you name, where the database driver returned them as strings.independent, capCAP plugin casting read values back to CDS model typesfrom CAP
- @quadrio/cds-db2@quadrio/cds-db2A DB2 adapter for CDS, so a CAP model can be deployed to and served from DB2, last released July 2023 and still on npm while the repository it was published from has been deleted.independent, capDB2 adapter for CDSfrom CAP
- @sap/cds-hana@sap/cds-hanaThe SAP Cloud Application Programming Model's database adapter for SAP HANA, the package a CAP project adds to run its model on a SAP HANA database.sap official, capDatabase adapter for SAP HANA in CAPfrom CAP
- @sap/cds@sap/cdsThe CAP Node.js runtime, which compiles the CDS model, serves the services declared in it, answers generic requests before any handler runs, and loads every cds-plugin.sap official, capCAP Node.js runtimefrom CAP
- @sap/hana-client@sap/hana-clientSAP's own Node.js driver for SAP HANA: connect, run SQL and prepared statements, synchronously, through callbacks or as promises, over native client libraries npm installs per platform.sap official, btpSAP's Node.js driver for SAP HANAfrom BTP/BAIP
- SAP HANASAP HANASAP’s relational database platform, which stores application data and executes SQL and SQLScript in the database, available on-premise and as the managed service SAP HANA Cloud.sap official, btpSAP's relational database platform, on-premise and in HANA Cloudfrom BTP/BAIP
- SAP-samples/hana-hdbext-promisfied-exampleSAP-samples/hana-hdbext-promisfied-examplePromise-based wrappers around the SAP HANA client libraries for Node.js, Go and Python, replacing nested callbacks with a single async call.sap official, btpPromise-based wrappers around the SAP HANA client librariesfrom BTP/BAIP
- cds-pgcds-pgA PostgreSQL adapter for SAP CDS, built by the SAP Mentors community, which gave CAP a Postgres persistence option years before @cap-js/postgres shipped.independent, capPostgreSQL adapter for SAP CDS from the SAP Mentors communityfrom CAP
- cap-snowflakecap-snowflakeA CAP database adapter for Snowflake with OData V4 support, which the maintainer marks as early development, so its contract is expected to move.independent, capCAP database adapter for Snowflake with OData V4 supportfrom CAP
- cds-mysqlcds-mysqlA MySQL and MariaDB database adapter for CAP that connects to a database instance and translates incoming CQL/CQN requests to it; the repository the package declares has been deleted.independent, capMySQL and MariaDB database adapter for CAPfrom CAP
Details
Sources
Sources are graph entities: the same page may back several entries, and an unreachable source flags every row that rests on it.
Compatibility and provenance
Flavors
“Welcome to the SQLite database service for [SAP Cloud Application Programming Model](https://cap.cloud.sap) Node.js, based on streamlined database architecture and [*better-sqlite* driver](https://www.npmjs.com/package/better-sqlite3).” — cap-js/cds-dbs — sqlite README
Contributors
History in the atlas
- The link named the root of a monorepo, so every crawl read the repository README — 'This is a monorepo for our SQL Database Services' — and filed it as this package's own: data/crawled/readmes/cap-js-sqlite.md is that root README today. npm's record for @cap-js/sqlite declares no repository directory, so the subfolder URL is the only place it can come from, and it is the form the corpus already uses for a package inside a monorepo.
- The entry named no registry page, so the only address it offered was a repository it shares with three other packages.
- The repository's README states the relation: the four subfolders are parts of one monorepo, each published on its own.
- https://github.com/cap-js/cds-dbs/tree/main/sqlite — 'Welcome to the SQLite database service for SAP Cloud Application Programming Model Node.js, based on streamlined database architecture and better-sqlite driver.'
- The SQLite service, in memory during the inner loop — which is why a CAP project runs before anyone has provisioned a database.
- First seen.
For your agent
- Ref
artifact:cap-js-sqlite- JSON
- /artifacts/cap-js-sqlite.json
- MCP
- Connecting an agent