Re: [GENEAL] dynamically changing table

From: "Will Rutherdale (rutherw)" <rutherw(at)cisco(dot)com>
To: "A B" <gentosaker(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENEAL] dynamically changing table
Date: 2009-03-30 19:17:54
Message-ID: 50A8E1F8D9122546A7F67134915EDB7A3B8E50@xmb-rtp-21a.amer.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible that what you want is a lookup table with a string index,
i.e. attribute-value pairs?

If so, that would be represented as a hash in Perl, or a map in C++. In
a database, you could design a very simple schema for it.

Or do you just have unclear requirements, as others have suggested?

-Will

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of A B
Sent: 30 March 2009 14:51
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] [GENEAL] dynamically changing table

Well, the requirement is: keep a lot of data stored, don't loose any
of it, and you will not know what you will have to store (changing
number of fields and of different types)
But it is not all that bad, the fields will be integers, or text, or
floatingpoint numbers.

One option is, put it in a db as a huge text (or in textfiles, one
per object) and parse it when you need it. That might also work.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-03-30 19:18:51 Re: [GENEAL] dynamically changing table
Previous Message Sam Mason 2009-03-30 19:08:37 Re: [GENEAL] dynamically changing table