{"shas":[["da9736a8b23b7f176866367094f5888aa5e98bb1","36e4b53f67bcc3a12389373471c58fd7d8710935@gmail.com","Hide NSFW links from logged in under 18 users.","Brian Simpson"],["165c3d12d625424fcfffbb2684282b1bd266c6c3","822ec91a7ef82248fd36162ca8ac3283eba70848@reddit.com","Remove unnecessary conditions from some queries.\n\nPG9 doesn't like the query from _load_link_comments\nin comment_tree.py.\n\nthing.py will automatically filter deleted and spam items\nout of thing queries if no rules are specified for those\ncolumns. To get around this, some queries, including the\n_load_link_comments one, will specify a rule\nlike _spam == (True, False). This rule was left in the ruleset,\ndespite the fact that it's completely unnecessary from the\nSQL's standpoint. Its presence then triggered the need of a\njoin against the thing table when only the data table was\ntruly necessary. The query planner in PG9 doesn't like this\nparticular query when it requires a join and will force a\nfull table scan as a result.\n\nThis patch notes the special case of _spam/_deleted ==\n(True,False) and turns off the default filtering but removes\nthe rules from the query. This saves some WHERE clauses\nand more importantly removes the need for a JOIN in queries\nlike this one.","Neil Williams"],["f8c21e4f7d69b3b3c8edad012b0f66f75f3e9133","36e4b53f67bcc3a12389373471c58fd7d8710935@gmail.com","Remove the ability for mods to approve a deleted link. This prevents the deleted\nthen approved link from becoming visible.","Brian Simpson"],["f8efeb60f33eac0d8e1de2b21eb1dafc60667807","822ec91a7ef82248fd36162ca8ac3283eba70848@reddit.com","Update to pycassa 1.1.0 for 0.8 compatibility.","Neil Williams"],["ddc3bafee06de71bf9643f4f253beab6e9dff9fe","822ec91a7ef82248fd36162ca8ac3283eba70848@reddit.com","Move SubredditPopularityByLanguage to models.","Neil Williams"],["40eedd012d9bfd1910cc5bb834bb790ac7dfba2a","822ec91a7ef82248fd36162ca8ac3283eba70848@reddit.com","Add --proctitle to paster run.\n\nWhen the setproctitle module is available and --proctitle is passed,\npaster run will set the process title (as seen by ps, top, etc.) to the\nspecified value.","Neil Williams"],["b7e6aa008aa2b3d616c7a45ecabc1c66251f5daa","9169b987e48e9167d1d5d71384ac7bb14b4f5719@gmail.com","Options expandos on links, cleaned up old parts of CSS, added icons","Paradox"],["9bbf7081af0602c537d8dd456ef4512dafb1b0cb","9169b987e48e9167d1d5d71384ac7bb14b4f5719@gmail.com","Added options-expando to comments","Paradox"],["12c521c2741a18c38c17d9c141f23fd1cb0f346f","9169b987e48e9167d1d5d71384ac7bb14b4f5719@gmail.com","Moved domain link from options expando to tagline","Paradox"],["3142bee4463dad94761b1e8a04b3ad3d850cf7fa","9169b987e48e9167d1d5d71384ac7bb14b4f5719@gmail.com","Added a touch/hover state to options expandos","Paradox"],["ecb4a3d456fc1722d06a4b706408b4a32437bba2","9169b987e48e9167d1d5d71384ac7bb14b4f5719@gmail.com","Prepared SASS file for sprites.\n\nAdded sprite declarations\n\nChanged output style to :compact, for single-line CSS output","Paradox"],["ef5e77a28927cb68183049030a84b08a1a2e12d1","0706025b2bbcec1ed8d64822f4eccd96314938d0@reddit.com","Add sprite for compact.css to the make process.","Max Goodman"],["2d845c4ed0a9a728e18bf46a94c2739415e9c06e","0706025b2bbcec1ed8d64822f4eccd96314938d0@reddit.com","Hack nymph.py to handle sprite comments anywhere in a line.","Max Goodman"],["d8ac604a0f92cbf27ee5cd03074a89b683625d07","0706025b2bbcec1ed8d64822f4eccd96314938d0@reddit.com","Don't affect leading whitespace on sprite rules.","Max Goodman"],["0c683aea6544632a754b6a9647b5d1aa2377a4dc","0706025b2bbcec1ed8d64822f4eccd96314938d0@reddit.com","Strip surrounding quotes on sprite paths.","Max Goodman"],["dd72dd1bca5f040cf15d55199218e6731c0e1d13","9169b987e48e9167d1d5d71384ac7bb14b4f5719@gmail.com","Set up messages and inbox to use options-expandos","Paradox"],["b47984ce075670b2301709899d79763738030d56","9169b987e48e9167d1d5d71384ac7bb14b4f5719@gmail.com","Fixed arrows to use css, fixed options button in menu bar to use sprited images now","Paradox"],["b29f6347dffaeebc86be2f84990294f0a6396ce3","9169b987e48e9167d1d5d71384ac7bb14b4f5719@gmail.com","Changed options expandos spacing to look better","Paradox"],["141a68151e9bcbe0215c2e3bd341ec27d874a5d6","9169b987e48e9167d1d5d71384ac7bb14b4f5719@gmail.com","Created new SCSS mixin for working with mako sprites. Converted old sprites to new syntax","Paradox"],["e9d52238a62b5222b0e089d4a31f66b4c91a24a5","9169b987e48e9167d1d5d71384ac7bb14b4f5719@gmail.com","Fixed .tagline order to make admins, followed by moderators, submitters, then friends","Paradox"]],"ref":"refs/heads/master","size":130,"head":"e88adc7e5b32fae6208bbf2dae95f6542d7ca10d","push_id":40847892}