Representing one-to-many relations
· ☕ 19 min read · ✍️ River
Several examples of video game mechanics that could be represented as one-to-many relations and how to do table design & queries
cargo
Introducing the SORCERER example wiki
· ☕ 1 min read · ✍️ River
Enjoy beautiful mspaint drawings and learn Cargo!
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.
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.