Is template information stored in Database? - Wikitech-l - lists.wikimedia.org

List overview All Threads
Download

Is template information stored in Database?

Rather than bad syntax outputting...

Parsing italics/bold

howard chen

10 Nov 2007 10 Nov '07

1:06 p.m.

Hello, A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc. Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database? Thanks. Howard.

Reply

Show replies by date

Thomas Dalton

10 Nov 10 Nov

1:13 p.m.

A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc. Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?

It's stored in the templatelinks table, see: http://www.mediawiki.org/wiki/Templatelinks_table

Reply

howard chen

1:25 p.m.

On Nov 10, 2007 9:13 PM, Thomas Dalton <thomas.dalton(a)gmail.com> wrote:

A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc. Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?

It's stored in the templatelinks table, see: http://www.mediawiki.org/wiki/Templatelinks_table

Great thanks. By the way, I found a schema image: http://upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schem… May I know which tool was being used to generate this? Thanks again.

Reply

jf＠mormo.org

1:37 p.m.

On Sat, Nov 10, 2007 at 09:25:19PM +0800, howard chen wrote:

On Nov 10, 2007 9:13 PM, Thomas Dalton <thomas.dalton(a)gmail.com> wrote:

A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc. Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?

It's stored in the templatelinks table, see: http://www.mediawiki.org/wiki/Templatelinks_table

Great thanks. By the way, I found a schema image: http://upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schem… May I know which tool was being used to generate this?

According to the image description on http://commons.wikimedia.org/wiki/Image:Mediawiki-database-schema.png it was made with DB Designer. jens

Reply

Schneelocke

1:40 p.m.

2007/11/10, howard chen <howachen(a)gmail.com>om>:

By the way, I found a schema image: http://upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schem… May I know which tool was being used to generate this?

The image description page[1] says: "Created by me, using DB designer 4.0.5.6 Beta on windows, but also containing information from MediaWiki's tables.sql file and from the table descriptions at MediaWiki.org (see: mw:Manual:Database layout)." 1. http://commons.wikimedia.org/wiki/Image:Mediawiki-database-schema.png -- schnee

Reply

howard chen

1:50 p.m.

On Nov 10, 2007 9:40 PM, Schneelocke <schneelocke(a)gmail.com> wrote:

2007/11/10, howard chen <howachen(a)gmail.com>om>:

By the way, I found a schema image: http://upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schem… May I know which tool was being used to generate this?

The image description page[1] says: "Created by me, using DB designer 4.0.5.6 Beta on windows, but also containing information from MediaWiki's tables.sql file and from the table descriptions at MediaWiki.org (see: mw:Manual:Database layout)." 1. http://commons.wikimedia.org/wiki/Image:Mediawiki-database-schema.png -- schnee

Nice. Thanks. Howard

Reply

howard chen

13 Nov 13 Nov

4:38 a.m.

On Nov 10, 2007 9:50 PM, howard chen <howachen(a)gmail.com> wrote:

On Nov 10, 2007 9:40 PM, Schneelocke <schneelocke(a)gmail.com> wrote:

2007/11/10, howard chen <howachen(a)gmail.com>om>:

By the way, I found a schema image: http://upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schem… May I know which tool was being used to generate this?

The image description page[1] says: "Created by me, using DB designer 4.0.5.6 Beta on windows, but also containing information from MediaWiki's tables.sql file and from the table descriptions at MediaWiki.org (see: mw:Manual:Database layout)." 1. http://commons.wikimedia.org/wiki/Image:Mediawiki-database-schema.png -- schnee

Nice. Thanks. Howard

One more follow up, how the inter table `links` in your schema was draw using DB Designer, or it is using external program? Howard

Reply

Nick Jenkins

6:32 a.m.

One more follow up, how the inter table `links` in your schema was draw using DB Designer, or it is using external program?

It was entirely drawn using DB designer. If you'd like, you can get the raw data file used to generate the image from http://files.nickj.org/MediaWiki/mediawiki-dbdesigner-schema-data.xml (I tried uploading this data file Commons, but '".xml" is an unwanted file type List of allowed file types: png, gif, jpg, jpeg, xcf, pdf, mid, sxw, sxi, sxc, sxd, ogg, svg, djvu' http://commons.wikimedia.org/wiki/Commons:File_types ) Then install DB designer, run it, go File -> Open, point it at this XML file, and what you see when it loads should match the image. -- All the best, Nick.

Reply

Simetrical

10 Nov 10 Nov

11:52 p.m.

On 11/10/07, Thomas Dalton <thomas.dalton(a)gmail.com> wrote:

A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc. Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?

It's stored in the templatelinks table, see: http://www.mediawiki.org/wiki/Templatelinks_table

Templatelinks only stores the fact that Die Hard includes the movie template, not what its parameters are. To figure out the latter you need to parse the page.

Reply

Lars Aronsson

13 Nov 13 Nov

12:42 a.m.

howard chen wrote:

A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc. Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?

You will be interested in these projects: http://meta.wikimedia.org/wiki/User:LA/Extraktor http://dbpedia.org/ http://freebase.com/ I'm user:LA2 who created the first of these. -- Lars Aronsson (lars(a)aronsson.se) Aronsson Datateknik - http://aronsson.se

Reply

howard chen

15 Nov 15 Nov

3:47 p.m.

On Nov 13, 2007 8:42 AM, Lars Aronsson <lars(a)aronsson.se> wrote:

howard chen wrote:

A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc. Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?

You will be interested in these projects: http://meta.wikimedia.org/wiki/User:LA/Extraktor

Hello, Can't find any information on the above link. Howard

Reply

Lars Aronsson

7:24 p.m.

howard chen wrote:

Can't find any information on the above link.

The correct link should be http://meta.wikimedia.org/wiki/User:LA2/Extraktor -- Lars Aronsson (lars(a)aronsson.se) Aronsson Datateknik - http://aronsson.se

Reply

6018

days inactive

6023

days old

wikitech-l@lists.wikimedia.org

Manage subscription

11 comments

7 participants

tags (0)

participants (7)

howard chen
jf＠mormo.org
Lars Aronsson
Nick Jenkins
Schneelocke
Simetrical
Thomas Dalton