[00:07:12] No, MW doesn't store that in the DB [00:16:24] In the olden days there was a custom table created on the Wiki Replicas that was populated with those namespace mappings, but that was removed circa 2018. [00:17:26] The recommended practice today is to fetch that data from the Action API and merge it into your sql query results externally. [02:17:29] It would actually kind of be cool if we had some sort of custom formatter function, where you can do makeTitle( page_namespace, page_title ) and it would turn it into a human readable string. Just thinking from the perspective of making reports on quarry [08:50:06] [[Tech]]; NewGuy8; /* Squeeze cat in a shoe */ new section; https://meta.wikimedia.org/w/index.php?diff=26335821&oldid=26293573&rcid=30258750 [09:54:53] [[Tech]]; ArielGlenn; Undo revision [[Special:Diff/26335821|26335821]] by [[Special:Contributions/NewGuy8|NewGuy8]] ([[User talk:NewGuy8|talk]]); https://meta.wikimedia.org/w/index.php?diff=26335939&oldid=26335821&rcid=30259113 [15:01:19] Hi, regarding ApiQueryPageProps, how can I decipher a "templatedata" property value? I guess the "templatedata" property value is compressed somehow, the question is with which algorithm(s). [15:01:43] i.e., https://en.wikipedia.org/w/api.php?action=query&formatversion=2&prop=pageprops&titles=Template:Track%20listing [15:07:21] Guest89: you probably want to use action=templatedata instead https://en.wikipedia.org/w/api.php?action=templatedata&titles=Template%3ATrack%20listing&formatversion=2 [15:08:10] (https://gerrit.wikimedia.org/g/mediawiki/extensions/TemplateData/+/d3acc6e119/includes/TemplateDataCompressedBlob.php looks like it should be gzip-compressed but I can’t seem to decompress what the API returns) [15:09:40] (the API probably doesn’t like returning byte streams that aren’t actually well-formed UTF8) [15:09:45] thanks, I know about action=templatedata. Yeah, I tried various compression algorithms, including gzip, to no avail. [15:11:05] I appreciate your quick reply. [15:11:46] np [15:11:55] I’m not really sure why action=templatedata is an action and not a query prop, tbh [15:12:16] then you could still combine it with other data in the same request (if that’s what you were interested in) [15:12:25] but the underlying page prop doesn’t look like it’s meant for public consumption :) [15:13:42] I don't mind using action=templatedata, just trying to reduce load on the api servers (; [15:39:36] [[Tech]]; Polygnotus; /* OOUI\Exception: OOUI\Theme::singleton was called with no singleton theme set. */ new section; https://meta.wikimedia.org/w/index.php?diff=26337101&oldid=26335939&rcid=30261809 [15:54:32] [[Tech]]; Polygnotus; /* OOUI\Exception: OOUI\Theme::singleton was called with no singleton theme set. */; https://meta.wikimedia.org/w/index.php?diff=26337171&oldid=26337101&rcid=30261933 [15:55:00] [[Tech]]; Polygnotus; /* OOUI\Exception: OOUI\Theme::singleton was called with no singleton theme set. */; https://meta.wikimedia.org/w/index.php?diff=26337173&oldid=26337171&rcid=30261935