Help:Cargo

Extension:Cargo on Mediawiki

The Cargo MediaWiki extension is designed to enhance MediaWiki's capabilities by providing a structured way to store and query data within wiki templates, particularly useful for managing data in infoboxes or similar structured data representations.

Cargo stands out as a powerful tool for those looking to leverage MediaWiki not just for content but for structured data management, offering a balance between complexity and usability for wiki administrators and developers. Its integration with MediaWiki's templating system makes it particularly useful for creating dynamic, data-driven content within wiki environments.

Functionality

• Data Storage: Cargo allows data to be stored in database tables, which can be either within MediaWiki's database or in a separate database for performance or security reasons. This data is typically derived from template calls, where each template invocation can define a row in a table.
• Querying Data: Users can query this data using SQL-like syntax through special pages or parser functions provided by Cargo, like #cargo_query. This allows for dynamic content generation based on the data stored.

• Parser Functions:

1. cargo_declare: Defines the schema for a table, placed within the <noinclude> part of a template.
2. cargo_attach: Specifies that a template adds rows to a table declared elsewhere.
3. cargo_store: Stores data into a Cargo table, usually within the <includeonly> part of a template.

Features

• Data Types: Cargo supports various data types including simple types like strings, dates, and numbers, to more complex ones like hierarchies, coordinates, and wikitext.

Field Type	Description	Unindexed?
Page	Holds the name of a page in the wiki (default max size: 300 characters)
String	Holds standard, non-wikitext text (default max size: 300 characters)
Text	Holds standard, non-wikitext text; intended for longer values	✔
Integer	Holds an integer
Float	Holds a real, i.e., non-integer, number
Date	Holds a date without time
Start date, End date	Similar to Date, but are meant to hold the beginning and end of some duration. A table can hold either no Start date and no End date field, or exactly one of both.
Datetime	Holds a date and time
Start datetime, End datetime	Work like Start date or End date, but include a time.
Boolean	Holds a Boolean value, whose value should be 1 or 0, or 'yes' or 'no' (see this section for Cargo-specific information on querying Boolean values)
Coordinates	Holds geographical coordinates
Wikitext string	Holds a short text that is meant to be parsed by the MediaWiki parser (default max size: 300 characters)
Wikitext	Holds longer text that is meant to be parsed by the MediaWiki parser	✔
Searchtext	Holds text that can be searched on, using the MATCHES command (requires MySQL 5.6+ or MariaDB 5.6+)
File	Holds the name of an uploaded file or image in the wiki (similar to Page, but does not require specifying the "File:" namespace) (default max size: 300 characters)
URL	Holds a URL (default max size: 300 characters)
Email	Holds an email address (default max size: 300 characters)
Rating	Holds a "rating" value, i.e., usually an integer from 1 to 5

• Special Pages: Cargo includes special pages like Special:CargoQuery for direct querying and Special:Drilldown for interactive data exploration.
• Integration with MediaWiki: It integrates seamlessly with MediaWiki's existing structure, allowing for data to be linked with pages, categories, and other MediaWiki features.
• Customization: Through settings like $wgCargoDefaultStringBytes or $wgCargoMaxQueryLimit, administrators can control how Cargo behaves in terms of data storage limits or query performance.

Advantages

• Ease of Use: Compared to other extensions like Semantic MediaWiki, Cargo might be simpler to install and use for basic to intermediate data management needs within MediaWiki.
• Performance: By potentially using a separate database, Cargo can help in managing performance issues related to data queries, especially on large wikis.
• Flexibility: Its design allows for complex data structures and queries, making it suitable for wikis where structured data management is crucial.

Community and Development

• Development: Cargo has seen contributions through programs like Google Summer of Code, indicating active development and community involvement.
• Support: There's community support through forums, documentation, and the MediaWiki extension repository, where users can find help or contribute to its development.

Special pages

• Special:CargoQuery
• Special:CargoTableDiagram
• Special:CargoTables
• Special:Drilldown

Map examples

Table

Name	Location	Department
Bryan	38.89814, -77.03666	IT
Josh	41.90218, 12.45393	European Sales
Juanita	40.71181, -74.01337	Marketing
Mary	32.70663, 35.30482	HR • Marketing
Peter	38.8977, -77.03655	HR

Dynamic table

Name	Location	Department
Name	Location	Department
Bryan	38.89814, -77.03666	IT
Josh	41.90218, 12.45393	European Sales
Juanita	40.71181, -74.01337	Marketing
Mary	32.70663, 35.30482	HR • Marketing
Peter	38.8977, -77.03655	HR

Open Layers

[{"name":"Bryan","title":"\u003Ca href=\"\/wiki\/Bryan\" title=\"Bryan\"\u003EBryan\u003C\/a\u003E","lat":38.89814,"lon":-77.03666,"otherValues":{"Department":"\u003Ca href=\"\/w\/index.php?title=IT&amp;action=edit&amp;redlink=1\" class=\"new\" title=\"IT (page does not exist)\"\u003EIT\u003C\/a\u003E"}},{"name":"Josh","title":"\u003Ca href=\"\/wiki\/Josh\" title=\"Josh\"\u003EJosh\u003C\/a\u003E","lat":41.90218,"lon":12.45393,"otherValues":{"Department":"\u003Ca href=\"\/w\/index.php?title=European_Sales&amp;action=edit&amp;redlink=1\" class=\"new\" title=\"European Sales (page does not exist)\"\u003EEuropean Sales\u003C\/a\u003E"}},{"name":"Juanita","title":"\u003Ca href=\"\/wiki\/Juanita\" title=\"Juanita\"\u003EJuanita\u003C\/a\u003E","lat":40.71181,"lon":-74.01337,"otherValues":{"Department":"\u003Ca href=\"\/w\/index.php?title=Marketing&amp;action=edit&amp;redlink=1\" class=\"new\" title=\"Marketing (page does not exist)\"\u003EMarketing\u003C\/a\u003E"}},{"name":"Mary","title":"\u003Ca href=\"\/wiki\/Mary\" title=\"Mary\"\u003EMary\u003C\/a\u003E","lat":32.70663,"lon":35.30482,"otherValues":{"Department":"\u003Ca href=\"\/w\/index.php?title=HR&amp;action=edit&amp;redlink=1\" class=\"new\" title=\"HR (page does not exist)\"\u003EHR\u003C\/a\u003E \u003Cspan class=\"CargoDelimiter\"\u003E&bull;\u003C\/span\u003E \u003Ca href=\"\/w\/index.php?title=Marketing&amp;action=edit&amp;redlink=1\" class=\"new\" title=\"Marketing (page does not exist)\"\u003EMarketing\u003C\/a\u003E"}},{"name":"Peter","title":"\u003Ca href=\"\/wiki\/Peter\" title=\"Peter\"\u003EPeter\u003C\/a\u003E","lat":38.8977,"lon":-77.03655,"otherValues":{"Department":"\u003Ca href=\"\/w\/index.php?title=HR&amp;action=edit&amp;redlink=1\" class=\"new\" title=\"HR (page does not exist)\"\u003EHR\u003C\/a\u003E"}}]

Leaflet

[{"name":"Bryan","title":"\u003Ca href=\"\/wiki\/Bryan\" title=\"Bryan\"\u003EBryan\u003C\/a\u003E","lat":38.89814,"lon":-77.03666,"otherValues":{"Department":"\u003Ca href=\"\/w\/index.php?title=IT&amp;action=edit&amp;redlink=1\" class=\"new\" title=\"IT (page does not exist)\"\u003EIT\u003C\/a\u003E"}},{"name":"Josh","title":"\u003Ca href=\"\/wiki\/Josh\" title=\"Josh\"\u003EJosh\u003C\/a\u003E","lat":41.90218,"lon":12.45393,"otherValues":{"Department":"\u003Ca href=\"\/w\/index.php?title=European_Sales&amp;action=edit&amp;redlink=1\" class=\"new\" title=\"European Sales (page does not exist)\"\u003EEuropean Sales\u003C\/a\u003E"}},{"name":"Juanita","title":"\u003Ca href=\"\/wiki\/Juanita\" title=\"Juanita\"\u003EJuanita\u003C\/a\u003E","lat":40.71181,"lon":-74.01337,"otherValues":{"Department":"\u003Ca href=\"\/w\/index.php?title=Marketing&amp;action=edit&amp;redlink=1\" class=\"new\" title=\"Marketing (page does not exist)\"\u003EMarketing\u003C\/a\u003E"}},{"name":"Mary","title":"\u003Ca href=\"\/wiki\/Mary\" title=\"Mary\"\u003EMary\u003C\/a\u003E","lat":32.70663,"lon":35.30482,"otherValues":{"Department":"\u003Ca href=\"\/w\/index.php?title=HR&amp;action=edit&amp;redlink=1\" class=\"new\" title=\"HR (page does not exist)\"\u003EHR\u003C\/a\u003E \u003Cspan class=\"CargoDelimiter\"\u003E&bull;\u003C\/span\u003E \u003Ca href=\"\/w\/index.php?title=Marketing&amp;action=edit&amp;redlink=1\" class=\"new\" title=\"Marketing (page does not exist)\"\u003EMarketing\u003C\/a\u003E"}},{"name":"Peter","title":"\u003Ca href=\"\/wiki\/Peter\" title=\"Peter\"\u003EPeter\u003C\/a\u003E","lat":38.8977,"lon":-77.03655,"otherValues":{"Department":"\u003Ca href=\"\/w\/index.php?title=HR&amp;action=edit&amp;redlink=1\" class=\"new\" title=\"HR (page does not exist)\"\u003EHR\u003C\/a\u003E"}}]

Related

• Help:Class - Defining a new Cargo template
• Help:Cargo (Overview)

Resources

Links

• https://community.fandom.com/wiki/Help:Cargo
• https://community.fandom.com/wiki/Help:Cargo/recreating_tables
• https://community.fandom.com/wiki/Help:Cargo/customizing_tables

Example wikis

• https://www.mediawiki.org/wiki/Extension:Cargo/Sites_that_use_Cargo
• https://wikiapiary.com/wiki/Extension:Cargo
• https://lol.fandom.com/wiki/League_of_Legends_Esports_Wiki
  • https://lol.fandom.com/wiki/Help:Cargo_Style_Guide
  • https://lol.fandom.com/wiki/Help:Cargo_table_recreation_order
  • https://lol.fandom.com/wiki/Leaguepedia:Dev_Blog/2018
  • https://lol.fandom.com/wiki/Special:CargoTables
• https://wiki.squirrelslair.ca/index.php?title=Main_Page
  • https://wiki.squirrelslair.ca/index.php?title=Special:CargoTables
  • https://wiki.squirrelslair.ca/index.php?title=Template:Project
  • Template:Project
• https://wikispore.wmflabs.org/
  • https://wikispore.wmflabs.org/wiki/Special:CargoTables
• https://pathofexile.fandom.com/wiki/Path_of_Exile_Wiki
  • https://pathofexile.fandom.com/wiki/Special:CargoTables
• https://eyewiki.org/Main_Page
  • https://eyewiki.org/w/index.php?title=Intermediate_Uveitis&action=formedit
• https://www.wikilawschool.org/
  • https://www.wikilawschool.org/w/index.php?title=Chevron_U.S.A.,_Inc._v._Nat._Res._Def._Council,_Inc.&action=formedit
  • https://www.wikilawschool.org/wiki/Template:Clerk-Note
  • https://wiki.oroboros.at/index.php?title=Robinson_2019_Am_J_Physiol_Cell_Physiol&action=formedit