Exact, never approximate
Ranks run 1, 2, 3 — no gaps, no ties, no estimates. Two players on the same score are separated by whoever got there first, so nobody is ever shown as joint fourth.
| Rank | Player | Score | From | |
|---|---|---|---|---|
| 1st | nyx-91c4 | 184,920 | source | |
| 2nd | quill-7b0e | 172,310 | source | |
| 3rd | sable-4d13 | 168,004 | source | |
| 4 | wren-2a88 | 151,775 | source | |
| 5 | orin-b350 | 140,612 | source | |
| 6 | juno-cc17 | 132,889 | source | |
| 7 | pike-05fd | 121,450 | source | |
| 8 | thea-e9a2 | 118,236 | source | |
| 9 | you | 88,150 | source |
168,004 is a score somebody already has. Submit it and you come fourth, not joint third. Remove anyone with ✕ and everybody below them moves up at once — a rank is counted rather than stored, so there is nothing to recompute and nothing to miss. A score you submit and one loaded from your database are ranked by the same tree, which is what From is telling you.
Your database, not a copy
Give it a query against your PostgreSQL, MySQL or MongoDB — or an endpoint you already serve — and it stays in step. Nothing to dual-write, so there is never a second answer to disagree with the first.
select player_id, best_score, updated_at from scores where season = 4 order by best_score desc limit 500000
Player
player_id
Score
best_score
Set at
updated_at
Your query, sent as you wrote it — nothing to dual-write, so there is never a second answer to disagree with the first. The connection string is encrypted before it is stored and no read gives it back; that fingerprint is how you tell one credential from another.
Find me, instantly
“Where am I and who is just ahead” is one call, however deep they are — and so is page 400. Both are a walk down a tree rather than a scan, so a ten-million-player board answers as fast as a hundred-player one.
| Among these | Player | Score | Overall |
|---|---|---|---|
| 1 | tess-1b07 | 1,902,640 | 96 |
| 2 | mira-3f21 | 1,284,500 | 412 |
| 3 | bo-7e55 | 1,284,500 | 413 |
| 4 | koa-88de | 984,120 | 3,119 |
| 5 | rhys-c440 | 512,300 | 21,884 |
Not on this board yet: finn-9a12
Overall is out of the 1,204,918 players on this board. One call, whoever you ask about — Plany stores no groupings, so a guild, a lobby or a friends list is the same read. Every rank here came from the same load of the board, which is what stops two of them coming back fourth.
Seasons that end cleanly
Close a season and open the next in one call. The board keeps its name, its id and everyone’s access — no migration, and no recreating anything.
Window
1 June → 1 September 2026
Season openPlayers ranked
1,204,918
Unchanged throughout
projects/arcade/locations/eu-west-2/leaderboards/weeklylb_8f3c21a0Scores are being accepted. Every rank is exact and every one of them is live.
Friends lists, in one read
Ask for nine players and get both ranks back: among themselves and on the whole board. All from one moment, so a lobby can never show two people in the same position.
Cheats come off
Remove a score and everyone below moves up correctly, straight away. Rank is computed rather than stored, so there is nothing to recompute and nothing that can be missed.
What you get
- Exact ranks, dense and unique, at any size
- Reads PostgreSQL, MySQL, MongoDB or your own endpoint
- Top X, a player’s position, and the window around them
- Guild, region and season boards without a board per filter