hasura / hasura/graphql-engine
[Feature request] execute sql statement with cron
Open
a/eventing/cron-triggers
c/scheduled-triggers
c/server
k/enhancement
- Dominant language
- TypeScript
- Stars
- 32.1k
- Forks
- 3k
- PR merge metrics
- PR metrics pending
Description
Following use cases:
- Clean up history, data etc. See also https://github.com/hasura/graphql-engine/issues/5053 and related documentation.
- Move data from hot to cold tables, daily table partitioning etc.
- Periodic data transformations, denormalization etc.
- Refreshing materialized views
- Execute notifiers
The nearest FP I can see is https://github.com/hasura/graphql-engine/issues/5050 . If it's implemented, then, probably, it can be used for that: call a mutation that calls a postgres function. But, well, it's very hacky and error prone.
Contributor guide
Assessment
This issue has not been assessed yet.