Build a straw-man DB schema for Multi-Content-Revisions
Closed, ResolvedPublic
Actions

Description

To further advance the discussion on MuCoRe, it would be useful to have a working database schema and a way to convert an existing wiki database to that new schema.

The idea is to take a copy of a wiki database, apply the appropriate patches or scripts, and then experiment with the resulting representation of revisions, slots, etc. Making MediaWiki code work with the new DB schema is beyond the scope of this ticket.

Details

	Subject	Repo	Branch	Lines +/-
	[WIP] Introduce DAO for revision content storage	mediawiki/core	master	+977 -0
	Experiment for multi-content-revision db schema [DNM]	mediawiki/core	master	+190 -0

Customize query in gerrit

Related Objects
Search...

Status	Subtype	Assigned	Task
Resolved		Qgil	T153007 Technical Collaboration annual plan FY2017-18
Resolved		Qgil	T159313 Draft WMF annual plan program about technical events
Resolved		Qgil	T149300 Future of the Wikimedia Developer Summit
Resolved		• Rfarrand	T153996 Wikimedia Developer Summit 2017: Feedback Survey
Resolved		• Rfarrand	T141926 Wikimedia Developer Summit 2017
Resolved		Qgil	T141938 Prepare a program for Wikimedia Developer Summit 2017 to effectively address current high level movement needs
Resolved		cscott	T147602 Facilitate Wikidev'17 main topic "Handling wiki content beyond plaintext"
Resolved		daniel	T149532 Why Multi-Content-Revisions? Use cases and requirements.
Declined		dchen	T118706 Conduct heuristic evaluation of image upload and insert flow in VisualEditor
Open		None	T115858 Design improvements for mw.ForeignStructuredUpload.BookletLayout
Open		None	T115865 Insert image in content immediately after it's uploaded, skipping the "General settings" step
Duplicate		None	T115864 Figure out if the description of the image can be used as the caption on-wiki
Open	Feature	None	T53032 When inserting an image, set its caption by default to be the Commons image description
Open	BUG REPORT	None	T12863 Links on commons upload summaries do not link to commons
Open		None	T5498 Image history is confusing
Stalled		None	T96384 Integrate file revisions with description page history
Duplicate		None	T39535 Wikimedia Commons should support filtering by color
Open	Feature	None	T39534 Wikimedia Commons should support searching by color
Resolved		None	T19503 Provide metadata support on Wikimedia Commons
Open		None	T122038 Moving/Deleting a video file does not move/delete subtitles files, nor does it inform the file mover of their existence
Open		None	T135221 Make TimedText content an integral part of the File page
Open	Feature	None	T2167 Use a dedicated interface for adding meta-data like interwiki links, rather than wikitext
Open		None	T132072 Integrate page meta-data as a new content model revision slot for consistency and atomicity
Resolved		None	T51662 VisualEditor: Use Multimedia/Wikidata's proposed rich structured meta-data in the image insertion dialog
Resolved		None	T68108 [Epic] Store media information for files on Wikimedia Commons as structured data
Open	Feature	None	T14963 allow per-page exceptions to spam blacklist
Open		None	T203157 Make the spam whitelist its own slot
Open	Feature	None	T56140 Move TemplateData to its own JSON-content namespace and associate with Template-namespace, or to its own TemplateData content model and revision slot
Stalled		None	T174043 Deploy Multi-Content Revisions
Open		None	T174022 Implement multi-content revisions
Resolved		Lydia_Pintscher	T146637 Wikidata 2016 Q4 goals
Resolved		Lydia_Pintscher	T150179 Wikidata 2017 Q1 goals
Resolved		• brion	T107595 [RFC] Multi-Content Revisions
Resolved		daniel	T141878 Build a straw-man DB schema for Multi-Content-Revisions

Event Timeline

daniel created this task.Aug 2 2016, 1:42 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 2 2016, 1:42 PM

daniel added a project: Wikidata-Sprint-2016-08-02.Aug 2 2016, 1:42 PM

Lydia_Pintscher moved this task from Proposed to Backlog on the Wikidata-Sprint-2016-08-02 board.Aug 2 2016, 1:53 PM

Change 302056 had a related patch set uploaded (by Daniel Kinzler):
Experiment for multi-content-revision db schema [DNM]

https://gerrit.wikimedia.org/r/302056

Change 302492 had a related patch set uploaded (by Daniel Kinzler):
[WIP] Introduce DAO for revision content storage

https://gerrit.wikimedia.org/r/302492

Lydia_Pintscher moved this task from Backlog to Review on the Wikidata-Sprint-2016-08-02 board.Aug 15 2016, 12:49 PM

thiemowmde added a project: Wikidata-Sprint-2016-08-16.Aug 16 2016, 12:50 PM

thiemowmde moved this task from Proposed to Backlog on the Wikidata-Sprint-2016-08-16 board.Aug 16 2016, 1:04 PM

daniel moved this task from Backlog to Review on the Wikidata-Sprint-2016-08-16 board.Aug 24 2016, 9:35 AM

daniel added a project: Patch-For-Review.Aug 30 2016, 8:14 AM

thiemowmde added a project: Wikidata-Sprint-2016-08-30.Aug 30 2016, 12:43 PM

Tobi_WMDE_SW moved this task from Proposed to Review on the Wikidata-Sprint-2016-08-30 board.Aug 30 2016, 12:49 PM

daniel closed this task as Resolved.Sep 5 2016, 1:29 PM

daniel moved this task from Review to Done on the Wikidata-Sprint-2016-08-30 board.

Straw man was created, discussed, and fiddeled with, see http://sqlfiddle.com/#!9/0b847/7

Change 302056 abandoned by Daniel Kinzler:
Experiment for multi-content-revision db schema [DNM]