Yuletide 2017 Tag Set OPEN

Sep. 26th, 2017 10:33 pm
morbane: uletide mod image of guinea pig among daisies (mod)
[personal profile] morbane posting in [community profile] yuletide_admin
The 2017 tag set is open! If you can’t load it because of demand, try this downloadable version of the page (3MB) instead.

Statistics! )

Corrections )

Challenges )

sqlite the miracle DB

Sep. 25th, 2017 11:24 pm
mindstalk: (Default)
[personal profile] mindstalk
At work today, Boss suggested I look at sqlite a bit, since our client code uses it. What I thought might be a brief glance turned into hours of reading, as it became rather fascinating. For those who don't know, it's an embedded SQL database, with not much code, unlike the client/server databases of Oracle or anything else you've probably heard of. As their docs put it, they're not competing with such databases, they're competing with fopen() and other filesystem access.

They call their testing "aviation grade", possibly without hyperbole: 100% branch coverage, 100% coverage of something stronger than branches, 700x more testing code than actual library code and a lot of that generates tests parametrically... it sounds pretty nuts. They worship Valgrind but find compiler warnings somewhat useless; getting warnings to zero added more bugs than it solved. https://www.sqlite.org/testing.html

They claim "billions and billions of deployments", which sounded like humorous hyperbole until they added being on every iPhone or Android phone, every Mac or Windows 10 machine, every major browser install... There are over 2 billon smartphones, so just from the phone OS and the phone browser, you've got 4 billion installs...

They also make a pitched case for consider a sqlite database any time you'd be considering some complex file format. With almost no code to write, you'd get consistency robustness, complex queries, machine and language independence, and at least some ability to do partial writes[1], compared to throwing a bunch of files into a zipfile.

https://www.sqlite.org/appfileformat.html
https://www.sqlite.org/affcase1.html

They also had a nicely educational description of their rollback and write-ahead models. https://www.sqlite.org/atomiccommit.html
https://www.sqlite.org/wal.html

[1] I do wonder about this. One odd thing about sqlite is a looseness about types, and AIUI cramming numeric values into the smallest range that will hold them. So I'd think that if you UPDATED a value 100 to a value 1000000000000, you'd have to shuffle the trailing part of the file, compared to a format that e.g. reserved 8 bytes for a numeric type. But maybe they do buffer numeric or string storage. And not having to write the whole file, or not having to read the whole file (e.g. to decompress it) seem like at least partial wins.

building affordable housing

Sep. 25th, 2017 08:39 pm
mindstalk: (Default)
[personal profile] mindstalk
A longish article on cities (or a country) that have built their way to affordable housing, contrary to the claims of many market-allergic leftists.

http://www.sightline.org/2017/09/21/yes-you-can-build-your-way-to-affordable-housing/

Money-quote paragraph:

"Houston, for example, can be Cascadia’s model for how easy it ought to be to get permits to build homes—if we believed, as Houston does, that building homes is in itself a good thing, our permitting processes would encourage rather than discourage it through endless months of hoop-jumping and politicized reviews. Tokyo, meanwhile, reminds us that placing control over development at senior levels of government, and making development of urban property a right of its owner, helps to elevate the broad public interest in abundant housing choices over parochial opposition to change. (Leaders in California have recently succeeded in passing a raft of new laws to act upon this lesson.) Chicago teaches that a pro-housing political orientation can provide abundant housing even under conventional zoning in a deep blue city, while Montreal offers Cascadia a model of a cityscape no longer of single-family homes but of three-story rowhouses, walk-up apartments, and condominiums on quiet, tree-lined streets close to transit and neighborhood centers. Singapore’s lesson is the promise of erecting high-density, park-like “new towns” on underused city land. And Germany shows us that a future is possible where housing is no longer an investment vehicle but “a very durable consumption good that provides a stream of housing services, not a ticket to financial gain.”"


Relatedly, Vienna and Singapore as two examples of massive public housing: https://www.shareable.net/blog/public-housing-works-lessons-from-vienna-and-singapore
Also useful if anyone tries to tout Singapore as a free-market miracle...

(no subject)

Sep. 25th, 2017 06:42 pm
seventhe: (Default)
[personal profile] seventhe
to be perfectly honest with you all, I fucking love grocery delivery and I'm probably never going back

Nominations Queries Post Five

Sep. 25th, 2017 10:20 pm
morbane: Utena Shadow Girls Santa picture with text "absolute destiny apocalypse yuletide" (Utena)
[personal profile] morbane posting in [community profile] yuletide_admin
We have been working on the tag set for 216 hours, and there are now 3196 approved fandoms in the tag set. We’re nearly there!

Please help us with the following issues:

17th Century CE RPF - We would like help to narrow this fandom down, as it is presently too broad. The characters nominated are:
  • Ben Jonson

  • Esme Stewart 1st Duke of Lennox

  • George Villiers 1st Duke of Buckingham

  • James VI and I

  • John Donne (17th Century CE RPF)

  • Robert Carr

  • Robert Carr 1st Earl of Somerset
-are these Robert Carrs the same? Esme Stewart 1st Duke of Lennox died before 1600; nominator, which person did you mean?

Chronicles of the Raven - James Barclay - Ry Darrick only seems to appear in the sequel trilogy; is that incorrect, or does this fandom label cover both trilogies? We’d also appreciate a little more information on the Unknown Warrior.

The Dark Tower - Stephen King - this is approved, and includes both 'The Man in Black' and 'Marten Broadcloak'. Nominators, would you prefer they are merged, or kept separate?

NaPolA | Before the Fall (2004) - Two characters, Albrecht Stein and Friedrich Weimer, are characters in the film; the other two, Florian Stetter and Martin Goeres, are actors. Nominator, could you please confirm whether you wanted to nominate the movie, or to nominate an RPF canon of the movie’s actors?

Never Too Wanted - The Composed Faucet Collection (Commercial) - We can’t figure out which character you’ve identified as the US Marshall - pointers, please? (Anyone?)

New York Yankees RPF - this has been approved, with characters Aaron Judge, Didi Gregorius, Gary Sánchez, and Greg Bird. However, Baseball RPF has also been approved, with characters Adam Lind, Anthony Rendon, Bryce Harper, Ian Kinsler, James McCann, Jayson Werth, José Iglesias, Michael A. Taylor, Miguel Cabrera, Sean Doolittle, Trea Turner, and Wilmer Difo. Yankees nominator, would you prefer your nomination was folded into Baseball RPF or that it was kept separate? (NB: this is possibly the last year ‘Baseball RPF’ is eligible under its current label.)

No Game No Life - Kamiya Yuu - we're a little confused by the character 『 』| Kuuhaku | Blank. Could the nominator please give their reasoning for nominating this character separately?

Smosh - the characters nominated are Keith Leak Jr., Noah Grossman, Olivia Sui, and Shayne Topp. Could the nominator please clarify if this is a nomination for RPF, or for fictionalized characters that share the names of the real people?

Star Wars: Marvel Comics - this nomination combines characters from multiple different series. The characters nominated are Captain Tolvan, Eneb Ray, Lando Calrissian, Queen Trios, and Terex. Could each nominator please choose one title for us to approve?

刀剣乱舞 | Touken Ranbu - Unfortunately, we made a mistake when we sent this through. Sorry. While we’re happy to approve this, we’d like some help: could each nominator please tell us which characters they nominated and under which label? We’d particularly like to hear from the Katsugeki!-specific nominator.

Zero | Project Zero | Fatal Frame Series - this seems to be a nomination for characters from two separate games, with Hinasaki Miu, Kozukata Yuuri, and Kurosawa Hisoka from Fatal Frame V, and Kurosawa Rei from Fatal Frame III. Could the nominator please either clarify, or pick just one game? (Fatal Frame IV is in the tag set separately.)


All Media Types fandoms
We need clarification from the person (or people) who nominated the following fandoms. Please specify a single version of the canon and provide a link to your nominations page so we can confirm the nomination. If these aren't answered, the fandoms will be rejected:
  • Kino no Tabi | Kino's Journey - All Media Types, characters: Kino (Kino no Tabi)

  • Kizoku Tantei, characters: unnamed main character (Kizoku Tantei)

  • A Room With a View - All Media Types, characters: Charlotte Bartlett, Eleanor Lavish



If you are commenting about your own nomination to say what you would like done with characters or fandoms, please link your nominations page! It is the page you get by clicking ‘My Nominations’ from the tag set.

If you notice any problems with your nominations - mis-spellings, etc - feel free to comment on this post.

Nominations Queries Post Four

Sep. 25th, 2017 02:07 am
morbane: uletide mod image of guinea pig among daisies (mod)
[personal profile] morbane posting in [community profile] yuletide_admin
We have been working on the tag set for 195 hours, and the number of individual fandom nominations has gone down from 5058 to 43. (Many of which 43 are mentioned below.) There are 3171 approved fandoms now in the tag set. We’re nearly there! Please note, though - the tag set won’t open the moment we hit zero. We’ll need a break to catch a breath & some of our own mistakes.


Please help us with the following issues:

Barcelona (album) - this is nominated only with characters Boy and Girl. Could the nominator please confirm what album they mean (the one by Freddie Mercury?) and what is meant by the characters? It seems like they might appear in just one song, The Golden Boy. Please clarify.

Battle: Los Angeles (2011) - By fandom name, this appears to be a nomination for the movie, but one character, Lee Imlay, appeas to be specific to the tie-in game. Could the nominator please confirm that all characters appear in the same canon, and confirm which canon they mean?

Carly Rae Jepsen (Musician) - This is nominated with the characters Alana Haim and Carly Rae Jepsen. We’re not really sure what the connection between the two is - could the nominator please clarify or suggest another fandom label?

CNN Pundits RPF - It’s not clear to us that The Magic Wall (anthropomorphic) belongs in an RPF nomination. Could the nominator please explain their reasoning?

Chronicles of the Raven - James Barclay - Ry Darrick only seems to appear in the sequel trilogy; is that incorrect, or does this fandom label cover both trilogies? We’d also appreciate a little more information on the Unknown Warrior.

Devil’s Cub - Georgette Heyer and These Old Shades - Georgette Heyer - these have been approved separately, with characters Dominic Alastair, Justin Alastair, Léonie de Saint-Vire, and Mary Challoner, and Hugh Davenant, Justin Alastair, Leonie, and Rupert Alastair, respectively. However, it’s been pointed out that they form a series. If (and only if) both nominators are willing, we will merge the nominations as the Alistair-Audley series. Nominators, how do you feel about that?

The Katering Show - We’re a bit confused by the nomination of The Thermomix as a character. Could the nominator please give their reasoning?

King Arthur: Legend of the Sword (2017) - This fandom has already been approved, but we’d like to hear from anyone who nominated the tag The Mage | Guinevere. This is the canonical tag on AO3 (and Yuletide’s use of it is unlikely to change that; if you have strong opinions please refer them to Support). However, one person who nominated The Mage has argued that they are separate. Would the other nominator also be OK with changing The Mage | Guinevere to just The Mage? If so, we will change it; if not, we will leave it as The Mage | Guinevere.

NaPolA | Before the Fall (2004) - Two characters, Albrecht Stein and Friedrich Weimer, are characters in the film; the other two, Florian Stetter and Martin Goeres, are actors. Nominator, could you please confirm whether you wanted to nominate the movie, or to nominate an RPF canon of the movie’s actors?

Nemocnice na kraji města | The Hospital on the Outskirts of the City (TV) - This title seems to refer to several different versions & reboots of a show. The character Eliška Králová seems to only appear in the 2003 sequel show, Nemocnice na kraji města po dvaceti letech | Hospital at the End of the City Twenty Years On, while the other nominated character Ina Blažejová is in both the 1978 and 2003 shows. Could the nominator please clarify what canon is covered by the title they’ve nominated?

Never Too Wanted - The Composed Faucet Collection (Commercial) - We can’t figure out which character you’ve identified as the US Marshall - pointers, please?

No Game No Life - Kamiya Yuu - we're a little confused by the character 『 』| Kuuhaku | Blank. Could the nominator please give their reasoning for nominating this character separately?

The Scarlet Pimpernel - Takarazuka Revue - The nominated characters Chauvelin (Ryuu Masaki) and Chauvelin (Yuzuki Reon) appear to come from separate runs of this production, in 2008 and 2010. Nominator, could you please share your reasoning on nominating them together?

Smosh - the characters nominated are Keith Leak Jr., Noah Grossman, Olivia Sui, and Shayne Topp. Could the nominator please clarify if this is a nomination for RPF, or for fictionalized characters that share the names of the real people?

Southpaw Regional Wrestling - we can’t find confirmation that a “Swamp Monster” appeared in this canon. Could the nominator please clarify and confirm?

Star Wars Legends: X-wing Series - Aaron Allston & Michael Stackpole - We have approved this nomination. However, we have also approved a nomination for Star Wars Legends: X-wing Series - All Media Types, with characters Derek "Hobbie" Klivian (X-Wing), Plourr Ilo (X-Wing), Rial Pernon (X-Wing), and Wes Janson (X-Wing). Could the nominator of the Allston & Stackpole series please confirm if it is okay to combine their nomination with the All Media Types nomination?

Trial and Error (TV 2017) - We can't find the character Anne Cox. Could the nominator please confirm and give us pointers to when she appeared? (Did you mean Dan Cox?)

决对争锋 | Duì Jué Zhēn Fēng | Beloved Enemy - We can't tell if this refers to the audio drama, the web series, or both, and if both, we'd appreciate a further comment on why they should be grouped together, please. This was nominated with the characters Gu Qing Pei, Peng Fang, Wang Jin, and Yuan Yang.


All Media Types fandoms
We need clarification from the person (or people) who nominated the following fandoms. Please specify a single version of the canon and provide a link to your nominations page so we can confirm the nomination. If these aren't answered, the fandoms will be rejected:

  • Kino no Tabi | Kino's Journey - All Media Types, characters: Kino (Kino no Tabi)

  • Kizoku Tantei, characters: unnamed main character (Kizoku Tantei)

  • Kurosagi - All Media Types, characters: Kashina Masaru, Katsuragi Toshio, Kurosaki (Kurosagi), Yoshikawa Tsurara

  • A Room With a View - All Media Types, characters: Charlotte Bartlett, Eleanor Lavish




If you are commenting about your own nomination to say what you would like done with characters or fandoms, please link your nominations page! It is the page you get by clicking ‘My Nominations’ from the tag set.

If you notice any problems with your nominations - mis-spellings, etc - feel free to comment on this post.

And that's a wrap!

Sep. 24th, 2017 12:01 am
press_start_mod: (Default)
[personal profile] press_start_mod posting in [community profile] press_start_comm
Assuming things all went as they should, creators should now be revealed!

It appears that we achieved one last trophy: I've Seen A Million Gifts and I Commented On Them All. Nice work, everyone!

What did you think of this year's exchange? Anything you'd like to see happen again next year? Anything you'd like to change? Feel free to let me know! Otherwise, well done everyone, and I hope to see you all in Chocolate Box 2018!

Nominations Queries Post Three

Sep. 22nd, 2017 10:16 pm
morbane: Utena Shadow Girls Santa picture with text "absolute destiny apocalypse yuletide" (Utena)
[personal profile] morbane posting in [community profile] yuletide_admin
We have been working on the tag set for 144 hours, and the number of individual fandom nominations has gone down from 5058 to 618. There are 2779 approved fandoms now in the tag set. We’re in the home stretch! (The not very fast home stretch.)


Please help us with the following issues:

2017 Oscars RPF / Academy Awards RPF - These were each submitted with the same character nominations: Andrew Garfield and Dev Patel. Nominators, do you have a strong preference as to what fandom label is used?

Chronicles of the Raven - James Barclay - Ry Darrick only seems to appear in the sequel trilogy; is that incorrect, or does this fandom label cover both trilogies? We’d also appreciate a little more information on the Unknown Warrior.

Dallas Stars (Hockey RPF) - Justin Courtnall does not appear to belong in this category; please comment, or we will either move him to another category (if an appropriate one exists) or reject him. It is not clear to us that Katie Hoaldridge is a celebrity in her own right; could the nominator please give their reasoning?

動物戦隊ジュウオウジャー | Doubutsu Sentai Zyuohger - the character Insarn does not seem to belong here. Did you mean Naria?

Element of Fire - Martha Wells - this is nominated with the characters Giliead (Ile-Rien), Ilias (Ile-Rien), and Tremaine Valiarde. The characters don’t seem to match the fandom. Nominator, would you prefer to change the fandom or the characters?

Forgotten Realms - for Khelben Arunsun, is Khelben "Blackstaff" Arunsun or Khelben Arunsun the Younger meant, please?

Giant Robo - This is nominated with the characters Alberto (Giant Robo), Ginrei (Giant Robo), Hanzui (Giant Robo), Ivan (Giant Robo), Kenji Murasame (Giant Robo), Shokatsuryou Koumei, Sunny the Magician, Taisou (Giant Robo), Tetsugyu (Giant Robo), and Youshi (Giant Robo). As far as we can tell, this is a mix of 1960 and 1990s anime. Nominators, could you please confirm which media you want and if they should be separated out or sent through together?

合法ドラッグ | Gouhou Drug | Legal Drug - the character Watanuki Kimihiro doesn’t seem to belong here. Nominator, could you please clarify?

No Game No Life - Kamiya Yuu - we're a little confused by the character 『 』| Kuuhaku | Blank. Could the nominator please give their reasoning for nominating this character separately?

Numbers (Anthropomorphic) - There are multiple sets of nominations for this fandom. Going by fandom spelling, respectively, the characters nominated are:
  • -1, 0, 1, 2, 3, 7, Golden Ratio, Pi

  • -128, -i, 0.5, 12, 16, 256, i, sqrt(2)

  • 666, e, j, k

The last set in particular is confusing us. Do j and k together (without i?) refer to components of a unit vector? Or, if j and k refer to unrelated concepts, is j being used as notation for the square root of negative one, or something else, and what is k? Is this meant to denote 1000? Nominators, please elaborate on your thinking.

Smosh - the characters nominated are Keith Leak Jr., Noah Grossman, Olivia Sui, and Shayne Topp. Could the nominator please clarify if this is a nomination for RPF, or for fictionalized characters that share the names of the real people?

Trial and Error (TV 2017) - We can't find the character Anne Cox. Could the nominator please confirm and give us pointers to when she appeared?

You Could Make a Life Series - Taylor Fitzpatrick - we can’t find the characters Mason Draper and Nate Wozniak. Could the nominator(s) give us pointers, please?



All Media Types fandoms
We need clarification from the person (or people) who nominated the following fandoms. Please specify a single version of the canon and provide a link to your nominations page so we can confirm the nomination. If these aren't answered, the fandoms will be rejected:
  • Kino no Tabi | Kino's Journey - All Media Types, characters: Kino (Kino no Tabi)

  • Kurosagi - All Media Types, characters: Kashina Masaru, Katsuragi Toshio, Kurosaki (Kurosagi), Yoshikawa Tsurara

  • The Martian - All Media Types, characters: Beth Johanssen, Chris Beck, Mark Watney (The Martian - All Media Types)

  • Paint Your Wagon, characters: Ben Rumson, Elizabeth (Paint Your Wagon), Schermerhorn (Paint Your Wagon), Sylvester Newel. Did you want the movie or the musical, please?

  • Rookies - Morita Masanori & Related Fandoms , characters: Aniya Keiichi, Kawatou Kouichi, Mikoshiba Tooru, Shinjou Kei

  • A Room With a View - All Media Types, characters: Charlotte Bartlett, Eleanor Lavish

  • 屍者の帝国 | Shisha no Teikoku | Empire of Corpses - All Media Types, characters: Alexei Karamazov, Friday, John Watson (Shisha no Teikoku), Nikolai Krasotkin

  • XCOM (Video Games) & Related Fandoms, characters: Firebrand, Lily Shen (XCOM), The Commander (XCOM)



Ensemble characters
We will accept labels like “the Council” or “the hunters” for characters in cases where the ensemble does not have different distinct characters in it. For the following fandom, please either confirm that there are no distinct characters in the group, or pick a single character out of the group you’ve nominated:
  • Compendium of World Knowledge - John Hodgman - Hobos, possibly also Cryptozoologists (?)




If you are commenting about your own nomination to say what you would like done with characters or fandoms, please link your nominations page! It is the page you get by clicking ‘My Nominations’ from the tag set.

If you notice any problems with your nominations - mis-spellings, etc - feel free to comment on this post.

Sidetracks - September 21, 2017

Sep. 21st, 2017 06:45 pm
helloladies: Gray icon with a horseshoe open side facing down with pink text underneath that says Sidetracks (sidetracks)
[personal profile] helloladies posting in [community profile] ladybusiness
Sidetracks is a collaborative project featuring various essays, videos, reviews, or other Internet content that we want to share with each other. All past and current links for the Sidetracks project can be found in our Sidetracks tag. For more links and commentary you can follow us on Twitter, Tumblr. You can also support us on Patreon.


Read more... )

Expand Cut Tags

No cut tags