One-to-many tables & #vardefine
· ☕ 12 min read · ✍️ River
#vardefine doesn’t always play nice with the order in which you need to evaluate code. Here are some solutions.
cargo
Ordering a Cargo field
· ☕ 7 min read · ✍️ River
How can you enforce a sorting order on a Cargo field when displaying tabular data?
List-type fields, for realsies
· ☕ 12 min read · ✍️ River
What are list-type fields? What *aren't* they? How do I query them?
I stored a boolean instead of a timestamp
· ☕ 3 min read · ✍️ River
A Cargo field I was going to store as a timestamp but decided to store as a boolean instead
Optimizing Cargo - query 3
· ☕ 7 min read · ✍️ River
The final of three Cargo queries I recently optimized on Leaguepedia
Optimizing Cargo - query 2
· ☕ 13 min read · ✍️ River
The second of three Cargo queries I recently optimized.
Optimizing Cargo - query 1
· ☕ 16 min read · ✍️ River
A Cargo query I optimized recently on Leaguepedia
A Lua module to print all args
· ☕ 7 min read · ✍️ River
When debugging confusing Cargo queries, a module that just prints everything for you can be incredibly helpful
Setting common match & game keys
· ☕ 27 min read · ✍️ River
A long story about how I corrected one of the biggest mistakes in my initial Cargo database design from two years ago
Escape item["id"]
· ☕ 6 min read · ✍️ River
A funny commit I made today
Gadget - Cargo pagevalues improvement
· ☕ 6 min read · ✍️ River
An improvement to the Cargo pagevalues view using just JS & CSS.
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.
Don't use _pageName
· ☕ 10 min read · ✍️ River
Sometimes it can seem convenient to use the built-in _pageName field that Cargo provides; however, _pageName is a metadata field, and you should take care to use it only as such.