User:CMedelius-WMF/Database report notes
|
This is a MediaWiki.org user page. If you find this page on any site other than MediaWiki.org, you are viewing a mirror site. Be aware that the page may be outdated, and that the user this page belongs to may have no personal affiliation with any site other than MediaWiki.org itself. The original page is located at https://www.mediawiki.org/wiki/User:CMedelius-WMF/Database_report_notes. |
 |
A collection of notes while I explore how the database reports project can support the Editing team's current goals.
Focus:
- A) determine which database reports from that list are relevant to suggestion mode
- B) see how the reports are generated and how we might generate others
- C) explore similar solutions in wikis other than enwiki
A) Potentially relevant reports
[edit]**note, this is just a static snapshot of the database reports page and won't update automatically.
Articles
[edit]| Report | Size (bytes) | Run frequency | Data as of | notes |
|---|---|---|---|---|
| Articles containing linked e-mail addresses (configuration) | 306 | Weekly | 05:18, 6 September 2025 (UTC) | Historically has not had more than a few results per run. |
| Articles containing links to the user space (configuration) | 4,800 | Weekly | 06:06, 6 September 2025 (UTC) | |
| Linked miscapitalizations (configuration) | 206,480 | Daily | 13:25, 11 September 2025 (UTC) | |
| Linked misspellings (configuration) | 7,158 | Daily | 23:51, 11 September 2025 (UTC) | |
| Orphans with incoming links (configuration) | 1,126 | Daily | 03:01, 9 September 2025 (UTC) | Not sure about this one, as the suggestion wouldn't be to change anything on the page itself. It would still be tangentially relevant to the page in though. |
| Interlanguage link templates need to fix (configuration) | 1,209,781 | Weekly | 03:16, 6 September 2025 (UTC) | |
| Pages containing too many maintenance templates (configuration) | 34,226 | Weekly | 11:54, 3 September 2025 (UTC) | Wouldn't generate newcomer-friendly suggestions |
| Short descriptions containing invalid space characters | 1,831 | Daily | — | It's not listed in the index, but if you follow this one's link you'll find another related report that could be relevant |
| Articles with links to drafts | 4,550 | Daily | — | |
| Biographies of dead people | ||||
| Potential biographies of dead people (1) (configuration) | 832 | Weekly | 06:36, 6 September 2025 (UTC) | Articles that transclude {{BLP unsourced}} that are not categorized in Category:Living people or Category:Possibly living people and are in a "XXXX deaths" category |
| Potential biographies of dead people (3) (configuration) | 142,939 | Weekly | 06:38, 6 September 2025 (UTC) | Articles in a "XXXX deaths" category whose talk pages transclude {{BLP}} |
| Potential biographies of dead people (4) (configuration) | 88,506 | Weekly | 06:38, 6 September 2025 (UTC) | Articles in a "XXXX births" category from over 100-200 years ago that are not also in a deaths category |
| Biographies of living people | ||||
| Biographies of living people containing unsourced statements (configuration) | 15,474 | Weekly | 06:46, 6 September 2025 (UTC) | Pages in Category:Living people that transclude Template:Citation needed
^ Basically generated from pages where the suggestion already exists, so maybe not relevant for a new suggestion. |
| Biographies of living people possibly eligible for deletion (configuration) | 7,555 | Weekly | 06:42, 6 September 2025 (UTC) | Wouldn't be an "edit" check. |
| Potential biographies of living people (1) (configuration) | 3,079 | Weekly | 06:38, 6 September 2025 (UTC) | Articles that transclude {{BLP unsourced}} that are not categorized in Category:Living people or Category:Possibly living people |
| Potential biographies of living people (2) (configuration) | 24,853 | Weekly | 06:39, 6 September 2025 (UTC) | Articles that are in a "XXXX births" category (greater than 1899) that are not in Category:Living people, Category:Possibly living people, or a "XXXX deaths" category (limited to the first 1000 entries) |
| Potential biographies of living people (3) (configuration) | 28,680 | Weekly | 06:39, 6 September 2025 (UTC) | Articles whose talk pages transclude {{BLP}} that are likely to be biographies of living people, but are not in Category:Living people, Category:Possibly living people, or Category:Missing people |
| Uncategorized and unreferenced biographies of living people (configuration) | 386 | Weekly | 06:46, 6 September 2025 (UTC) | |
| Untagged biographies of living people (configuration) | 2,214 | Weekly | 06:47, 6 September 2025 (UTC) | |
Redirects
[edit]| Report | Size (bytes) | Run frequency | Data as of | Notes |
|---|---|---|---|---|
| Broken section anchors (configuration) | 1,881,004 | Monthly | 15:51, 02 September 2025 (UTC) | I need to look more into this one. Can't tell if it's relevant yet. |
There are also some interesting inactive reports we could see about reviving.