I’m taking a sort-of Underpants Gnomes approach to selecting cheesecake themes on Pixiv.
- Collect Cheesecake.
Step 2 in the Pixiv Underpants Gnome Plan is “pick a theme I’ve already downloaded enough images for”. In this case, that’s everything containing the kanji 狐 except where it’s used in a proper name, or: 狐耳 狐娘 キャス狐 狐 狐耳巫女 #キャス狐 アサ狐 乳狐 狐っ娘 狐巫女. That produces a set of 107 images that I already like, and there’s even a pair of red half-rims for an offering.
For amusement, here’s what my theme-discovery process ends up looking like, using the offline DB I build with the API:
% sqlite3 -separator " " pixiv-girls.sqlite3 <<EOF | head -20 select count(i.id),i.tag,t.en from illust i left outer join trans t on i.tag = t.jp where i.tag not like "%users入り" group by tag order by count(id) desc EOF 1010 オリジナル Original 597 女の子 Girl 484 魅惑の谷間 Charming_Cleavage 462 おっぱい Oppai 329 Fate/GrandOrder 258 R-18 242 水着 Swimsuit 237 FGO 230 猫耳 Cat_Girl 228 極上の乳 Superb_Breasts 220 艦これ KanColle 210 尻神様 Butt_Goddess 194 おへそ Belly_Button 194 艦隊これくしょん 167 魅惑のふともも Captivating_Thighs 156 マシュ・キリエライト Mashu_Kyrielight 134 巨乳 Big_Breasts 125 CLIPSTUDIOPAINT 116 下着 Underwear 114 アイドルマスターシンデレラガールズ Idolmaster_Cinderella_Girls
Once I’ve picked a set of tags, I have a little Bash script that does boolean searches on the SQLite DB and opens all the matching images in Preview.app, so I can do things like “(catgirl or foxgirl) and big boobs and not loli”.
The tagging still isn’t 100%, though, because tags are applied to illustration IDs, and it’s common for users to post multiple “pages” of images. Sometimes these are actual manga pages, but it’s also used for “grab-bag of sketches”, “N variations of the same drawing”, “N characters from same series”, and the ever-popular “progressively-more-explicit scene”. So, if a series includes a busty fox-girl, a loli catgirl, and a glasses-wearing robot, the ID will have all of those tags. Similarly, if the final image in a sequence is the aftermath of a gang-bang, the wholesome first image gets all the explicit tags as well.
Markdown formatting and simple HTML accepted.
Sometimes you have to double-click to enter text in the form (interaction between Isso and Bootstrap?). Tab is more reliable.