Thread: Schema for Website Comments

Dear all,

Today I need to create a schema for my application website that allows
user comments too.

I think we have to maintain hierarchical data and it is very common as
all sites are supporting this feature.

Can somebody suggest me some guidelines to follow and some links too.


Thanks

On Sun, Jul 10, 2011 at 10:14 PM, Adarsh Sharma
<adarsh.sharma@orkash.com> wrote:
> Dear all,
>
> Today I need to create a schema for my application website that allows user
> comments too.
>
> I think we have to maintain hierarchical data and it is very common as all
> sites are supporting this feature.
>
> Can somebody suggest me some guidelines to follow and some links too.
>

PostgreSQL supports WITH RECURSIVE as of 8.4 and higher.

http://www.postgresql.org/docs/8.4/static/queries-with.html

Best Wishes,
Chris Travers

http://www.ferdychristant.com/blog//archive/DOMM-7QJPM7




--
Best Regards,
 
Prabhat Kumar
MySQL DBA
 
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

On Jul 12, 2011, at 7:54 PM, Prabhat Kumar wrote:

> Today I need to create a schema for my application website that allows user comments too.
> I think we have to maintain hierarchical data and it is very common as all sites are supporting this feature.
> Can somebody suggest me some guidelines to follow and some links too.

I think you would like to go through following thread:
http://archives.postgresql.org/pgsql-sql/2010-04/msg00006.php

Presentation:
http://wiki.postgresql.org/images/9/91/Pguswest2008hnd.pdf

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blogs: http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com