Hello, I got interested in Prefect as I was investigating Python based orchestration engine.
First off, can we use MYSQL as the underlying DB instead of Postgres.
Our use case is that we want to define a flow with some tasks. And that flow's trigger should be event driven (say a message in queue). We can have potentially 100's of thousands of those triggers in a day, and the tasks are short tasks.
But the individual tasks involve calling some api, but we get the response asynchronously. So the next task can only proceed after previous task was successful, but we need another trigger to inform the flow that previous task was successful. I wonder if Prefect can be used to solve this particular use case ? Also we'll use a self-hosted env, if that makes any difference.