Postgres query to name and shame motivate Musicbrainz contributors.
All in good fun of course; inspired by these posts.
Last active
September 3, 2026 16:04
-
-
Save mibmo/66f5e422587ebb433482eaca5a9fcf01 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH | |
| editor_votes AS ( | |
| SELECT | |
| editor.name AS editor, | |
| count(*) AS votes, | |
| max(vote_time) AS last_voted, | |
| rank() OVER( | |
| ORDER BY | |
| count(*) DESC | |
| ) | |
| FROM vote | |
| JOIN editor ON editor.id = vote.editor | |
| WHERE vote_time >= now() - '24 hour'::interval | |
| GROUP BY editor.name | |
| ), | |
| worst_ranked AS ( | |
| SELECT * | |
| FROM editor_votes | |
| WHERE rank = (SELECT max(rank) FROM editor_votes) | |
| ), | |
| -- single out the worst as fewest votes with longest time since voting | |
| worst_performers AS ( | |
| SELECT editor | |
| FROM worst_ranked | |
| WHERE rank = (SELECT max(rank) FROM editor_votes) | |
| AND last_voted = (SELECT min(last_voted) FROM worst_ranked) | |
| ) | |
| SELECT | |
| rank, | |
| votes, | |
| last_voted, | |
| editor, | |
| CASE | |
| WHEN rank = 1 THEN 'You''re the best!' | |
| WHEN editor IN (SELECT editor FROM worst_performers) THEN 'You''re the worst.' | |
| WHEN votes >= 50 THEN 'Godlike!' | |
| WHEN votes >= 20 THEN 'Unstoppable!' | |
| WHEN votes >= 10 THEN 'Amazing!' | |
| WHEN votes >= 5 THEN 'Great' | |
| WHEN votes >= 3 THEN 'Nice start' | |
| WHEN votes >= 1 THEN 'You can do better than that...' | |
| ELSE 'Go vote!' | |
| END AS message | |
| FROM editor_votes | |
| ORDER BY | |
| rank ASC, | |
| last_voted DESC; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| rank | votes | last_voted | editor | message | |
| ------+-------+-------------------------------+----------------------------+-------------------------------- | |
| 1 | 925 | 2026-08-30 09:42:18.38989+00 | chaban | You're the best! | |
| 2 | 432 | 2026-08-30 14:45:00.896391+00 | chabreyflint | Godlike! | |
| 3 | 195 | 2026-08-30 03:48:18.072566+00 | YoGo | Godlike! | |
| 4 | 191 | 2026-08-30 10:23:25.559802+00 | sayaka | Godlike! | |
| 5 | 132 | 2026-08-30 15:19:57.694483+00 | rdswift | Godlike! | |
| 6 | 130 | 2026-08-30 12:45:51.739713+00 | mudcrow | Godlike! | |
| 7 | 119 | 2026-08-30 10:10:42.826799+00 | ApeKattQuest, MonkeyPython | Godlike! | |
| 8 | 118 | 2026-08-30 14:55:34.132377+00 | jesus2099 | Godlike! | |
| 9 | 115 | 2026-08-30 15:46:26.854597+00 | afrocat | Godlike! | |
| 10 | 106 | 2026-08-30 08:55:34.181143+00 | ZX.Diablo | Godlike! | |
| 11 | 59 | 2026-08-30 13:38:09.479635+00 | Olivetti | Godlike! | |
| 12 | 54 | 2026-08-30 11:10:30.046816+00 | IvanDobsky | Godlike! | |
| 13 | 49 | 2026-08-30 12:33:59.070211+00 | Nomsheep | Unstoppable! | |
| 14 | 41 | 2026-08-30 13:42:06.238758+00 | cobycat | Unstoppable! | |
| 14 | 41 | 2026-08-30 11:39:16.370223+00 | Eincrou | Unstoppable! | |
| 16 | 38 | 2026-08-30 12:27:02.983042+00 | IAmTheBlackMetal | Unstoppable! | |
| 17 | 36 | 2026-08-30 15:35:44.249813+00 | fmera | Unstoppable! | |
| 18 | 30 | 2026-08-30 15:45:12.502009+00 | Hamuko | Unstoppable! | |
| 19 | 28 | 2026-08-30 08:03:00.714683+00 | joiletjake | Unstoppable! | |
| 20 | 26 | 2026-08-30 06:04:21.192712+00 | FloydianDK | Unstoppable! | |
| 21 | 23 | 2026-08-30 15:15:00.392829+00 | asexyhobo | Unstoppable! | |
| 22 | 21 | 2026-08-30 14:26:02.838698+00 | kiriya_aoi | Unstoppable! | |
| 23 | 17 | 2026-08-29 18:47:25.422047+00 | HibiscusKazeneko | Amazing! | |
| 24 | 15 | 2026-08-30 10:56:46.842915+00 | krefson1 | Amazing! | |
| 24 | 15 | 2026-08-30 10:42:30.297817+00 | raelthelamb | Amazing! | |
| 26 | 14 | 2026-08-30 11:14:22.874422+00 | CDotJDotB | Amazing! | |
| 26 | 14 | 2026-08-29 19:07:27.537295+00 | tigerman325 | Amazing! | |
| 28 | 13 | 2026-08-30 11:14:38.335137+00 | Fabe56 | Amazing! | |
| 28 | 13 | 2026-08-30 07:28:02.589713+00 | magicroundabout | Amazing! | |
| 30 | 12 | 2026-08-30 09:21:54.320239+00 | FFalex | Amazing! | |
| 30 | 12 | 2026-08-29 23:02:51.17636+00 | outsidecontext | Amazing! | |
| 32 | 9 | 2026-08-30 07:14:55.112329+00 | DontMindMe | Great | |
| 33 | 6 | 2026-08-30 08:34:55.500816+00 | dvirtz | Great | |
| 33 | 6 | 2026-08-30 03:32:47.876837+00 | hydralica | Great | |
| 33 | 6 | 2026-08-30 01:25:37.553235+00 | pcrosby9 | Great | |
| 36 | 5 | 2026-08-30 15:08:38.131028+00 | psioner | Great | |
| 36 | 5 | 2026-08-30 13:01:29.382976+00 | VBZPPlNQyJ | Great | |
| 36 | 5 | 2026-08-30 10:50:55.783476+00 | ernstlx | Great | |
| 36 | 5 | 2026-08-30 08:38:54.463074+00 | elQuotho | Great | |
| 36 | 5 | 2026-08-30 00:43:19.093541+00 | mist475 | Great | |
| 41 | 4 | 2026-08-30 10:47:35.477322+00 | riwood | Nice start | |
| 41 | 4 | 2026-08-29 16:27:36.210325+00 | refresh_daemon | Nice start | |
| 43 | 3 | 2026-08-30 15:46:57.707674+00 | Griomo | Nice start | |
| 43 | 3 | 2026-08-30 09:25:43.071077+00 | hasezoey | Nice start | |
| 43 | 3 | 2026-08-30 01:12:31.180115+00 | ibitsu | Nice start | |
| 43 | 3 | 2026-08-29 17:39:10.547867+00 | lurkerbot | Nice start | |
| 47 | 2 | 2026-08-30 15:19:51.069008+00 | HuxP | You can do better than that... | |
| 47 | 2 | 2026-08-30 13:28:24.659202+00 | DenizC | You can do better than that... | |
| 47 | 2 | 2026-08-30 11:34:20.122225+00 | Maxr1998 | You can do better than that... | |
| 47 | 2 | 2026-08-30 05:57:43.767844+00 | flabbergasted | You can do better than that... | |
| 47 | 2 | 2026-08-30 02:15:15.317213+00 | CyanNyan | You can do better than that... | |
| 47 | 2 | 2026-08-29 20:26:12.761802+00 | hatchetation | You can do better than that... | |
| 47 | 2 | 2026-08-29 19:46:01.284678+00 | -Verso- | You can do better than that... | |
| 47 | 2 | 2026-08-29 17:02:16.848508+00 | Hallucyn8 | You can do better than that... | |
| 55 | 1 | 2026-08-30 15:20:42.632752+00 | hemisputnik | You can do better than that... | |
| 55 | 1 | 2026-08-30 14:43:57.777486+00 | dnL | You can do better than that... | |
| 55 | 1 | 2026-08-30 12:39:17.217174+00 | barrymieny | You can do better than that... | |
| 55 | 1 | 2026-08-30 11:23:13.853797+00 | BusterEverett | You can do better than that... | |
| 55 | 1 | 2026-08-30 11:22:29.357247+00 | voidflare1 | You can do better than that... | |
| 55 | 1 | 2026-08-30 08:32:32.273646+00 | bartvaes | You can do better than that... | |
| 55 | 1 | 2026-08-30 07:40:59.929722+00 | Comrade Mike | You can do better than that... | |
| 55 | 1 | 2026-08-30 03:53:44.74913+00 | satellite4ngel | You can do better than that... | |
| 55 | 1 | 2026-08-29 20:42:10.822889+00 | retrodaredevil | You can do better than that... | |
| 55 | 1 | 2026-08-29 20:28:57.581827+00 | PYNAD | You can do better than that... | |
| 55 | 1 | 2026-08-29 20:01:20.804805+00 | Tigggger | You can do better than that... | |
| 55 | 1 | 2026-08-29 19:38:11.172471+00 | Schwarzwalder | You can do better than that... | |
| 55 | 1 | 2026-08-29 19:04:36.47936+00 | zos18 | You can do better than that... | |
| 55 | 1 | 2026-08-29 17:54:02.125936+00 | patagona | You can do better than that... | |
| 55 | 1 | 2026-08-29 17:31:35.702375+00 | 45adapter | You can do better than that... | |
| 55 | 1 | 2026-08-29 17:00:07.465663+00 | tapi0 | You're the worst. | |
| (70 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment