I want to use a phoenix as a message queue. it has a 'priority' column and a 'enqueue_time' column. I want to select rows order by priority first then enqueue_time. After poll out a few rows, I need to delete them. There is only one client connect to this table so there isn't any concurrent problem.
Is phoenix suitable for me? how should I design this table?
