Completely distinguish various concepts including "global site ID", "global site key", "site DB name", "site domain"; "site group", "site DB name suffix"
Open, Needs TriagePublic
Actions

Description

NOTE: Consider split interlanguage from the interwiki table.

Completely distinguish "global site ID", "global site key", "site database name", "site domain", "site language code", "site subdomain"

We should completely not using string processing for

"global site ID" / "site ID"
"global site key"
"site database name"
"site domain"
Wikibase Repository sitelink "site-group-language(s)"

and

"site group"
"site DB name suffix"

and

"site language code"
"site interlanguage prefix"
"site DB name language prefix"
"site subdomain"

and

virtual site

For example:

"global site id" / "site id" => (integer)
"global site key" => be_taraskwiki
"site database name" => be_x_oldwiki
"site domain" => be-tarask.wikipedia.org
Wikibase Repository sitelink 'site-group-language(s)" => wikipedia => be-tarask
- Another example => wikipedia => hak + hak-hant + hak-latn

and

"site group" => wikipedia or wikimedia or ...
"site DB suffix" => wiki

and

"site language code" => lzh
"site interlanguage prefix" => lzh (expected) / zh-classical (as for now)
"site DB name language prefix" => zh-classical
"site subdomain" => zh-classical (as for now)

Scope:

Core
- MediaWiki-Site-system
Extensions
- SiteMatrix
- Wikibase

Database and API:

type / data table	Example value	`wg` config variables	`sites`	`site_identifiers`	`interwiki`	`action=sitematrix`	`wb_items_per_site`
site host ID no.	`1`
site host	`wikimedia`
site group ID no.	`3`
site group name	`Wikipedia`					`sitename`
site group code	`wikipedia`
is special site group	`false`
site project ID no.	`3`
site project name	`Wikipedia`					`sitename`
site project code	`wikipedia`
site project legacy code	`wikipedia`		`site_group`
site global ID no.	`2836`
site global key	`wikipedia_nan`		`site_global_key`		`iw_wikiid`		`ips_site_id`
site local ID no.	`1`		`site_id`	`si_site`
site type code	`mediawiki`		`site_type`
site language code	`nan`	`LanguageCode`	`site_language`
site database name	`zh_min_nan_wiki`	`DBname` / `LocalDatabases`				`dbname`
site canonical URL	`https://nan.wikipedia.org`					`url`
site URLs	`https://nan.wikipedia.org`
site protocol	`https://`		`site_protocol`
site domain	`nan.wikipedia.org`	`Server` / `CanonicalServer`
site domain index	`gro.aidepikiw.nan.`		`site_domain`
site is closed	`null/false`					`closed`
site source	?
site data legacy	?
site forward	`1`		`site_forward`
site config	?		`site_config`
virtual sites	`wikipedia_nan-hant`, ...
virtual sites prefixes	`nan`, `nan-hant`, ...	`LanguageCode` + extra		`si_key`	`iw_prefix`

Related Objects
Search...

Status	Subtype	Assigned	Task
Open		None	T102107 Enable Content Translation in Catalan Wikipedia for all logged-in users
Open		None	T116533 ContentTranslation issues that affect people who aren't editors or translators (tracking)
Open		None	T126916 ContentTranslation gray interlanguage links issues (tracking)
Declined		None	T105577 use geolocation to show the gray interlanguage link in ContentTranslation
Invalid		None	T105578 Incorrect language code handling in ContentTranslation (tracking)
Invalid		None	T116466 Simple English Wikipedia issues with ContentTranslation (tracking)
Stalled		None	T110190 Rename "simple" wikis to "en-simple"
Stalled		None	T147164 Site identifier and domain prefix for nowiki should be changed
Invalid		None	T127680 Rename Serbo-Croatian Wikipedia and Wiktionary from sh.wiki* to hbs.wiki*
Stalled		None	T124657 Rename cbk-zamwiki to cbkwiki
Stalled		None	T10217 Wikipedias with zh-* language codes waiting to be renamed (zh-min-nan -> nan, zh-yue -> yue, zh-classical -> lzh)
Stalled		None	T64717 Move oldwikisource on www.wikisource.org to mul.wikisource.org
Stalled		None	T41968 Bhojpuri wikipedia should start with 'bho' instead of 'bh' to avoid confusion with Bihari
Stalled	Feature	None	T36217 Rename emlwiki -> eglwiki
Stalled		None	T31186 Rename Võro Wikipedia, fiu-vro -> vro
Stalled	Feature	None	T28725 Renaming the Aramaic (arc) Wikipedia to the Syriac (syc) Wikipedia
Stalled	Feature	None	T27522 language code change for Samogitian: "bat-smg" to "sgs"
Stalled	Feature	None	T25216 Move the Nourmande Wikipedia from nrm to nrf
Stalled		None	T17988 Rename 'roa-rup' wikis to 'rup'
Stalled		None	T6793 Rename Alemannic Wikipedia from als.wikipedia to gsw.wikipedia
Open		None	T172035 Blockers for Wikimedia wiki domain renaming
Open		None	T109579 [Epic] Give more sister projects access to Wikidata
Open		None	T360048 [EPIC] Drawbacks of 1 sitelink per Item per wiki implementation
Stalled		None	T54971 [Goal] Sitelinks and arbitrary accesses to Incubator, OldWikisource and BetaWikiversity
Open		None	T124286 [Epic] Wikidata language support
Open		None	T329424 Completely distinguish various concepts including "global site ID", "global site key", "site DB name", "site domain"; "site group", "site DB name suffix"
Open		None	T334347 Completely distinguish concepts including "BCP 47 language code", "MediaWiki internal language code", "interlanguage prefix", "site language subdomain", "site DB prefix"
Open		None	T334348 Normalize BCP 47 language codes
Open		None	T334350 Decide whether to make LanguageNameUtils able to support BCP 47 language tags
Open		None	T334349 Reduce exposure of MediaWiki internal language codes
Open		None	T278372 Support for language variants and multiple scripts
Declined		None	T257211 Determine frequency of usage of language variants
Open		None	T278366 Multiple scripts & interlanguage links issue
Open		None	T327008 Make Wikibase site link system more "interlanguage link" + "interproject link"
Open		None	T335054 Research: Language-related configuration options
Open		None	T111876 Figure out how renaming languages without database names is supposed to work with SiteMatrix, and implement for be-x-old -> be-tarask
Open		None	T29002 Completely de-couple the DB name

Event Timeline

Winston_Sung created this task.Feb 11 2023, 3:04 PM

Restricted Application removed a project: Patch-For-Review. · View Herald TranscriptFeb 11 2023, 3:04 PM

Winston_Sung renamed this task from Completely distinguish "global site id / global site key", "site DB name", "site domain"; "site group", "site DB suffix"; "site language code", "site subdomain" to Completely distinguish various concepts including "global site id / global site key", "site DB name", "site domain"; "site group", "site DB name suffix".Feb 11 2023, 3:06 PM

Winston_Sung updated the task description. (Show Details)

Winston_Sung edited projects, added MediaWiki-Site-system, SiteMatrix; removed MW-1.40-notes (1.40.0-wmf.21; 2023-01-30), Wikimedia-Site-requests.Feb 11 2023, 3:47 PM

Winston_Sung moved this task from Backlog to Infrastructure on the Language-strategy board.

deryckchan awarded a token.Feb 11 2023, 8:44 PM

Winston_Sung added a project: MediaWiki-Configuration.Feb 13 2023, 3:29 AM

Winston_Sung moved this task from Backlog to Planning on the MediaWiki-Configuration board.

Winston_Sung added projects: MediaWiki-extensions-Wikibase-Repo, MediaWiki-extensions-Wikibase-Client.Feb 13 2023, 3:37 AM

Maintenance_bot added a project: Wikidata.Feb 13 2023, 3:45 AM

Restricted Application added a project: [DEPRECATED] wdwb-tech. · View Herald TranscriptFeb 13 2023, 3:45 AM

Winston_Sung added a subtask: T278366: Multiple scripts & interlanguage links issue.Feb 13 2023, 6:02 AM

Winston_Sung renamed this task from Completely distinguish various concepts including "global site id / global site key", "site DB name", "site domain"; "site group", "site DB name suffix" to Completely distinguish various concepts including "global site ID", "global site key", "site DB name", "site domain"; "site group", "site DB name suffix".Feb 26 2023, 11:55 AM

Winston_Sung updated the task description. (Show Details)

Winston_Sung updated the task description. (Show Details)Feb 26 2023, 3:28 PM

Winston_Sung updated the task description. (Show Details)

Winston_Sung updated the task description. (Show Details)Mar 30 2023, 7:15 AM

Winston_Sung updated the task description. (Show Details)Mar 31 2023, 9:33 AM

Winston_Sung added a parent task: T124286: [Epic] Wikidata language support.Mar 31 2023, 9:43 AM

Winston_Sung added a subtask: T334347: Completely distinguish concepts including "BCP 47 language code", "MediaWiki internal language code", "interlanguage prefix", "site language subdomain", "site DB prefix".Apr 9 2023, 12:37 PM

Winston_Sung removed a subtask: T278366: Multiple scripts & interlanguage links issue.

Pppery added a subtask: T111876: Figure out how renaming languages without database names is supposed to work with SiteMatrix, and implement for be-x-old -> be-tarask.Apr 9 2023, 8:24 PM

Bugreporter updated the task description. (Show Details)Apr 16 2023, 3:34 AM

Ameisenigel mentioned this in T343094: Change language for Wikifunctions on Special:SiteMatrix from en to wikifunctions.Aug 7 2023, 8:19 PM

nshahquinn-wmf subscribed.Sep 20 2023, 12:37 AM