Re: Need advise for database structure for non linear data.

From: Thomas Schmidt <postgres(at)stephan(dot)homeunix(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Need advise for database structure for non linear data.
Date: 2011-01-03 14:07:04
Message-ID: 4D21D808.8020604@stephan.homeunix.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Am 03.01.11 14:14, schrieb Andre Lopes:
> Hi,
>
> Thanks for the reply's. I was tempted to accept the Rodoslaw Smogura
> proposal. There will be about 100 websites to capture data on daily basis.
> Each website adds per day(average) 2 articles.
>
> Thomas talked about the noSQL possibility. What do you think would be
> better? I have no experience in noSQL and that could be a weakness.
>
Imho RDBMS do a very good job in managing data on a relational basis.
However - there are alternatives and use cases for 'em and there is no
holy grail...
Not having any experience is a good point for not using it in production
:-).
However, if you've time to spare, looking into database design
(plain-sql and not-only-sql) will help.

I don't think that you get in trouble with a few hundered rows per day,
but keep in mind, what queries are used.

Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2011-01-03 14:21:04 Merging 2 rows in a table
Previous Message pasman pasmański 2011-01-03 13:47:37 Re: Cursors WITH HOLD