From: John Runyon Date: Fri, 7 Jun 2024 06:23:35 +0000 (-0600) Subject: update design docs X-Git-Url: https://jfr.im/git/dlqueue.git/commitdiff_plain/refs/heads/main?ds=sidebyside update design docs --- diff --git a/docs/design/architectural-pillars.md b/docs/design/architectural-pillars.md index 8c954da..3bcb23e 100644 --- a/docs/design/architectural-pillars.md +++ b/docs/design/architectural-pillars.md @@ -2,6 +2,9 @@ MySQL? Postgres would also work. Redis might work but would make things like reporting/aggregating and other work more difficult. MySQL/MariaDB/Postgres all support `SELECT ... FOR UPDATE SKIP LOCKED`, allow aggregation (`SELECT AVG(completed_time-pending_time)`), etc. +MySQL: support in 8.0.1 (2017-04-10, Fedora 40+) +MariaDB: support in 10.6 (2021-07, Ubuntu 22.04+, Debian bookworm+) + ## Insertion Jobs are typically inserted into the database by a front-end like dlqueue.php (optionally via bookmarklet) or dlqueue.sh