cds-dbs
cds-dbs copied to clipboard
cap-js
Monorepo for SQL Database Services for CAP
In certain scenarios it _might_ be beneficial to use sqlite in disk mode and have multiple worker threads processing the queries.
## Fractal Service By tracking database query targets. Create short lived caches (using `@cap-js/sqlite`) which all instances redirect their queries to. Creating a live cache which can be queried reliably....
This PR unifies the `UPSERT` implementation of all the database services. resulting in 2 helper functions in each database service that allow for defining the database specific JSON extraction logic...
[Postgres.js](https://www.npmjs.com/package/postgres) claims to be the fastest postgres client. See [benchmarks](https://github.com/porsager/postgres-benchmarks#results). Should we switch?
Based on the documentation page for [Parameters](https://help.sap.com/docs/postgresql-hyperscaler-option/postgresql-on-sap-btp-hyperscaler-option/parameters?locale=en-US&q=engine_version) for the PostgreSQL on SAP BTP, Hyperscaler Option, the latest available version is 14. With #351 the testing was switched to PostgreSQL v16....
It is best practice when using HANA to use execution plan visualization files to identify the root cause of slow performing queries. This change targets to add native support for...
Currently it is not very common that people develop with `HANA` in their local development setup, but sometimes it is required to validate specific behaviors. This change there for exposes...
Trying to reproduce https://github.com/cap-js/cds-dbs/issues/229 @BobdenOs Do you know by any chance whether this can be depending on pg version?
### Description of erroneous behaviour When doing a deep `UPDATE` when using an ambiguous `WHERE` clause it creates children without parents. ### Detailed steps to reproduce ```js await INSERT([{ ID:...