| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Jimmy Thrasibule <thrasibule(dot)jimmy(at)gmail(dot)com>, Chris Travers <chris(dot)travers(at)gmail(dot)com> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL as a triple store |
| Date: | 2014-08-12 15:29:32 |
| Message-ID: | 53EA32DC.60009@iol.ie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/08/2014 15:57, Jimmy Thrasibule wrote:
>> Is there a reason why hstore or json is not an option? That may work a lot
>> better than this approach.
>
> I don't want to move away from SQL common features so I can have a
> test environment using SQLite and deploy on PostgreSQL. This approach
> looks elegant and simple to me. Using a new table per attribute type
> or even per attribute for the values, I can easily index them for
> quick lookups.
What is your test environment? Postgres works quite happily on my rather
low-powered Windows 7 laptop, and so I have all the bells and whistles
available for development.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2014-08-12 15:33:13 | Re: PostgreSQL as a triple store |
| Previous Message | dushy | 2014-08-12 15:25:12 | Postgresql 9.3 tuning advice |