[Mystara Database] Tagging

Home of Thorf's myriad Secret Projects.

Moderators: Havard, agathokles, Thorf

Post Reply
User avatar
Andaire
Stone Giant
Posts: 743
Joined: Sat May 24, 2008 11:21 pm
Gender: male
Location: Paris, France
Contact:

[Mystara Database] Tagging

Post by Andaire » Mon Jul 07, 2008 6:59 pm

With all that talk of a Mystara DB, and seeing how detailed it is going to be, it resurrects my old dream of assigning keywords to everything Mystaran, notable every article we ever wrote. Today, we'd call that tagging.
Information Wants To Be Free
Hervé Musseau http://www.facebook.com/profile.php?id=1223372668

User avatar
Thorf
Cartomancer
Posts: 2482
Joined: Fri May 23, 2008 2:41 am
Gender: male
Location: Akita, Japan
Contact:

Re: Tagging

Post by Thorf » Tue Jul 08, 2008 2:32 am

Yes, absolutely! :D

We are already talking about including Vaults articles as sources, so the framework is already mostly in place. All we would need to do is work out what the tags are, and implement them in a series of tables. Probably something like this:

mdb_source_tag
id
tag_name
description

mdb_source_tag_linkage
id
mdb_source_id @
mdb_source_tag_id @

That would probably be enough - just define the tags and link them to sources.

On the other hand, we could also make it a little more flexible by having tag hierarchies, such as:

mdb_source_tag
id
tag_name
mdb_source_tag_id @
description

The self-reference allows us to define a parent tag, so we could have Outer World containing Known World, rather than having both separate. Then you just add the most detailed tag, and it automatically implies all the parent tags too.

Actually, this is how I sort my photos, my maps, and my fantasy art database. There's an excellent program called IMatch with some very powerful functions built around this.

Post Reply

Return to “Thorf's Projects”