« first day (2124 days earlier)   

12:09 AM
@trogdor eheheh, yeah it is -- it could use a few daggers hidden in it I think, too ;)
 
it probably has those
 
:D
 
can't hardly tell XD
 
12:35 AM
I would hide a stool in it, so i could sit and no one would know.
 
that is a great idea
if I had to wear something like that I would do the same
 
 
2 hours later…
2:13 AM
Anybody know of a good resource for learning to draw complex Venn diagrams?
 
2:52 AM
I know a professor of mathematical philosophy whose work is in "diagrammatic calculus," but I think she's probably not quite what you meant=\
 
Maybe not quite that complex.
BGS says I should draw a relationship map showing the various PCs and NPCs, their personal connections, and the social circles they move in.
 
3:07 AM
I would maybe start with a directed graph, which you could potentially condense down later into Venn diagrams
My brain likes small circles with lots of lines
 
[googles "directed graph"]
 
 
5 hours later…
8:38 AM
I have a question for one of our resident SQL experts.
Say I have a table where every record has a Name, a Type, and a Value. Let's say I've recorded D&D's Armor table: the name, the armor type (non-armor, light, medium, heavy, shield, perhaps other categories) and its purchase price.
I want to write a query that extracts the following:
1. Every Light armor, sorted by value, then
2. Every Medium armor, sorted by value, then
3. Every other armor, sorted by value regardless of its type.
How do you do that, exactly? I can't just sort by type then by value, because that sorts the whole list by type, and I want that remainder of the list ordered regardless of type.
What I imagine right now is I run two separate SQL queries: one to grab Light and Medium armors, sorted by type then value; one to grab all non-Light non-Medium armors sorted by value.
 
9:26 AM
@doppelgreener You can use case statements in the order by.
Typing on phone, but you'd want something like: order by case when type in light, medium then type else value end
No, wait. Rereading your reqs, you actually want: order by case when type = light then 1 when type = medium then 2 else 3 end, value
 
9:59 AM
@Miniman oh boy, i didn't even know this was a thing. that's fantastic.
 
@doppelgreener If you think about it, you can reference a column in an order by, which means anything you can put in a column can go in an order by.
 

« first day (2124 days earlier)