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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Schema for Website Comments

--bcaec548aa39ec063604a7e00d56
Content-Type: text/plain; charset=ISO-8859-1

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

On Sun, Jul 10, 2011 at 10:14 PM, Adarsh Sharma 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.
>
>
> Thanks
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?**
> unsub=aim.prabhat@gmail.com
>
>


--
Best Regards,

Prabhat Kumar
MySQL DBA

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--bcaec548aa39ec063604a7e00d56--

Re: Schema for Website Comments

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

> Today I need to create a schema for my application website that allows us=
er comments too.
> I think we have to maintain hierarchical data and it is very common as al=
l 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.ph p

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


--=20
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general