Jonathan Gray

For https, flowapi container requires: /run/secrets/cert-flowkit.pem and /run/secrets/key-flowkit.pem Ideally, one should be able to specify names for these files, because to update a docker secret one creates a new secret...

Wondering if the timestamp for the check should be returned here as well _Originally posted by @greenape in https://github.com/Flowminder/FlowKit/pull/6471#discussion_r1541427786_

Bit speculative, but I wonder if we might investigate if it is possible/would be helpful to send etag headers with flowapi responses. We have, I think, the necessary information to...

Make cache management functions available via cli

1

Would be useful if Flowmachine's cache management funcs were available via the CLI in some fashion. This could allow sysadmins to shrink or otherwise resize the cache using the docker...

Add a `FileExistsSensor` before creating the foreign table, using `pg_stat_file` or similar

1

The approach makes sense. Although this still leaves us in the situation of using the fail/retry mechanism in lieu of a sensor; it's just that it will now be the...

API spec generation is slow

3

~10s on my machine. This is only mildly an issue for actual use, because it isn't a frequently used endpoint. However it _is_ an issue for the tests, and slows...

Add https://github.com/pgaudit/pgaudit extension for improved audit logging within flowdb

``` /home/airflow/.local/lib/python3.8/site-packages/airflow/utils/context.py:205 AirflowContextDeprecationWarning: Accessing 'execution_date' from the template is deprecated and will be removed in a future version. Please use 'data_interval_start' or 'logical_date' instead. /home/airflow/.local/lib/python3.8/site-packages/airflow/utils/context.py:205 AirflowContextDeprecationWarning: Accessing 'next_ds' from the...

Should use schedule instead

FlowKit is a mixture of libraries and applications. For the _libraries_ we should probably not be pinning with pipenv and instead be using tox (or more modern equivalent) to test...