ewan-escience

Better dependency tracking for non-sql functions

12

When trying out this product with the `plan` command, the program errors, because it seems to do some live validation of the plan. If I understand correctly what is happening,...

### What is the problem? In [the setup instructions for Python](https://datacarpentry.org/python-socialsci/instructor/index.html#setup-instructions-for-python), two screenshots are visible in the Instructor View but not in the Learner View. ### Location of problem (optional)...

Delete ignores resource embedding with top level filtering

1

When deleting using resource embedding with [top level filtering](https://postgrest.org/en/v12/references/api/resource_embedding.html#top-level-filtering), the top level filtering is not applied when determining what rows to delete. I would expect this to be the case,...

Upgrade GitHub workflows

3

The `Link Checker for Pull requests` workflow emits a lot of warnings (see e.g. https://github.com/NLeSC/guide/actions/runs/11070939423). We should look into upgrading and adapting the workflows.

Pin dependencies and add integrity checks

7

Linked dependencies, as in `` don't have a version in their URL, meaning they will always point to the latest version. (Side note: why do these dependencies start with `//`...

Combine array contains with pattern matching

8

## Problem A table could have a column that is an array, e.g. ```sql CREATE TABLE my_table ( some_array VARCHAR[] ); ``` To find all rows that contain the string...

Return ignored rows when `resolution=ignore-duplicates` is combined with `return=representation`

6

### Environment * PostgreSQL version: 15.12 * PostgREST version: v12.2.8 * Operating system: Linux ### Description of issue When making a POST request using the `Prefer` header with value `return=representation,resolution=ignore-duplicates`,...