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
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 |