| 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: | Whole Thread | Raw Message | 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 |