Project-Id-Version: Trac 0.12
POT-Creation-Date: 2008-01-30 09:20+0100
PO-Revision-Date: 2010-07-19 23:05+0200
Last-Translator: Jeroen Ruigrok van der Werven <>
Language-Team: en_US <>
Plural-Forms: nplurals=2; plural=(n != 1)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Generated-By: Babel 0.9.6

Warning: Can't synchronize with repository "(default)" (Unsupported version control system "git": Can't find an appropriate component, maybe the corresponding plugin was not enabled? ). Look in the Trac log for more information.

Ticket #158 (closed improvement: fixed)

Opened 8 years ago

Last modified 7 years ago

Improve Metadata hangling with one Metadata table

Reported by: sebastian Owned by:
Priority: critical Milestone: 2.4
Component: explorer Version:
Keywords: database Cc:


Improve meta data handling by merging tags, categories, and locations to one table instead of 3 separate tables. Meta data extensions like person would be easier to extend.

Change History

comment:1 Changed 8 years ago by sebastian

If all meta data are stored in one table the search syntax need to be adopted as well. The current search allow to have an binary operand for tags, categories, and locations separately (e.g tag1 OR tag2 with location1 AND location2). This behavior must be dropped for sql query performance reasons.

For further reference I name field as some specialized meta data like tag, category or location. E.g "tag:flower" is a field with meta data of a tag and value "flower".

Suggestion: There are required, optional, and excluded fields. Required fields have a plus sign prefix ("+tag:flower" or "tag:+flower"). Excluded fields have a minus prefix ("-tag:flower" or "tag:-flower").

By default all fields are required. So if you query "tag:flower category:vacation location:italy" all fields are required.

If one tag is required marked by plus sign, all other fields are optional. "+tag:flower category:vacation location:italy" means: tag "flower" is required. Media with category "vatation" and location "italy" are optional but ranked higher if available.

"+tag:flower category:vacation -location:italy" means: tag "flower" is required, category "vacation" is optional and location "italy" is excluded.

comment:2 Changed 7 years ago by sebastian

  • Status changed from new to closed
  • Resolution set to fixed

Resolved in 6204d08

Note: See TracTickets for help on using tickets.