Is there a reason why hstore or json is not an option? That may work a lot better than this approach.
Another approach I have had is a set of additional catalog tables and dynamically adding/removing columns from an extended attributes table. On Tue, Aug 12, 2014 at 6:19 AM, Jimmy Thrasibule < thrasibule.ji...@gmail.com> wrote: > Hello, > > I'm looking into gathering information about geographical locations: > > - Coordinates > - Place name > - Pictures > - etc. > > Since a place can be anything, a specific place may need any kind of data > type to be described. > > I'm therefore looking into using the same method as the semantic Web and > trying to describe a place with triples. > > 1. The "triples" table will reference a subject, attribute and value. > 2. The "attributes" table will have an attribute name, a type and mauve a > table name. > 3. For each attribute type, a new table is created to store the values. > 4. A "resources" table list all the available resources (location, > picture, ...). > > Using this, I can easily add a new resource and describe it by adding new > triples. Every item is identified using UUIDs as primary key. > > This seems too simple to be true so I falling back to you in case you see > any pitfalls here. > > The "triples" table will grow very fast in this setup and may become a > bottleneck. However, I don't see any other way to store information about > something as wide as places around the world. > > Regards, > Jimmy > -- Best Wishes, Chris Travers Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in. http://www.efficito.com/learn_more