Ivan

Add support for pgpass

3

We follow the spec in https://www.postgresql.org/docs/current/libpq-pgpass.html, Order of passfile path is: 1. passfile path specified in connection string, e.g. `postgresql://localhost:5432?passfile=/home/someuser/secret/.pgpass` 2. default path `~/.pgpass` in *nix, `%APPDATA%\postgresql\pgpass.conf` in windows. -...

### Feature request description Hi, I'm from the ecosystem engineering team at CrateDB. I need a testcontainer module, I will shortly create PR with the feature myself. ### Image reference...

Release 0.5.2

2

## Summary of the changes / Why this is an improvement New release, last one is 10 months old. ## Checklist - [ ] Link to issue this PR refers...

Possible memory leak

4

User at https://community.cratedb.com/t/disk-space-issues-on-prometheus-integration/1848/3 reports **85%** memory usage, I checked out my own long running container and it was: **35%** ```sh 5fd5f000593a crate-prometheus-exporter 0.00% 5.462GiB / 15.51GiB 35.22% 4.26GB / 1.62GB...

Improve storage by normalizing the current metrics table

7

As pointed out by @proddata in some private conversations, we could further reduce the storage usage by normalizing how we store the data in CrateDB. I did some testing on...

Check for connectivity on startup

2

Would it make sense to issue an `SELECT 1` on startup and check if connectivity to CrateDB is possible with the given configuration? I'd say it would be helpful for...

feat: add `CrateDB` module

3

Solves #198 cc @kneth

## Summary of the changes / Why this improves CrateDB old: [](https://github.com/crate/crate/actions/workflows/main.yml) new: [](https://github.com/crate/crate/actions/workflows/main.yml) ## Checklist - [ ] Added an entry in the latest `docs/appendices/release-notes/.rst` for user...

Add String scalar functions `starts_with` and `ends_with`

6

### Problem Statement Current alternatives are ugly and harder to read, many SQL dialects already implement this. E.g. Postgres: [starts_with](https://pgpedia.info/s/starts_with.html) Databricks SQL: [startswith](https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/functions/startswith) ### Possible Solutions Implement `starts_with(expr, string) ->...

Support parameter placeholder in 'insert into ... returning ?' for literals

1

### CrateDB version 5.10.1 ### CrateDB setup information _No response_ ### Problem description It seems that we cannot bind values for the 'RETURNING' part of an INSERT query. ### Steps...