Your URL bar is a CLI
· ☕ 9 min read · ✍️ River
When working with wikis, you can use your URL bar as a CLI-like interface for navigation, making your life a lot easier and more efficient!
leaguepedia
CompoundRole
· ☕ 18 min read · ✍️ River
A bunch of things I did wrong because learning is fun!
How to rename Cargo tables safely
· ☕ 8 min read · ✍️ River
Cargo actually provides a way to cleanly rename tables without any "downtime," but it's not obvious or documented how to do this.
Use cases for Highlight Links in Category
· ☕ 7 min read · ✍️ River
Highlight Links In Category has a number of incredibly nice use cases; here I give some examples.
Adventures in caching primary keys
· ☕ 15 min read · ✍️ River
The pattern of store -> query -> store -> query can lead to caching nightmares when working with Cargo or SMW in MediaWiki. This is the story of how I dealt with one.
The Anti-Thanos Snap That Wasn't
· ☕ 9 min read · ✍️ River
The story of the April Fools Day joke for 2020 that I didn't do, and the "Snap" that we may or may not still do.
Determining team members from roster change data: A Leaguepedia case study
· ☕ 9 min read · ✍️ River
Managing complexity using Cargo with MediaWiki to track League of Legends esports roster changes.
New Roster Changes
· ☕ 24 min read · ✍️ River
An overview of the process I used to create our single-source-of-truth roster change database tables on Leaguepedia.