Re: Article on MySQL vs. Postgres - Mailing list pgsql-hackers

From Chris Bitmead
Subject Re: Article on MySQL vs. Postgres
Date
Msg-id 3963C913.423D8F4E@nimrod.itg.telecom.com.au
Whole thread Raw
In response to Re: Article on MySQL vs. Postgres  (Benjamin Adida <ben@mit.edu>)
List pgsql-hackers
Benjamin Adida wrote:

> Some recursion? That is interesting. Do you mean multiple queries to the
> database? I don't see any reason to have multiple queries to the database to
> show nested messages in a forum. Using stored procedures to create sort keys
> at insertion or selection time is the efficient way to do this. Ah, but
> MySQL doesn't have stored procedures.

Can you be more specific on how you would support arbitrary nesting and
correct sorting of a threaded discussion in postgres? I've thought about
this problem but didn't come up with anything except to re-implement the
old recursive " retrieve* " from the old postgres.


pgsql-hackers by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: Proposed new libpq API
Next
From: Peter Eisentraut
Date:
Subject: Re: Per-database/schema settings