Google Groups Home
Help | Sign in
Message from discussion This is more of a general application design question than a CakePHP question...
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
Jonathan Snook  
View profile
 More options May 11, 9:52 pm
From: "Jonathan Snook" <jonathan.sn...@gmail.com>
Date: Sun, 11 May 2008 21:52:46 -0400
Local: Sun, May 11 2008 9:52 pm
Subject: Re: This is more of a general application design question than a CakePHP question...
My answers below...

On Sun, May 11, 2008 at 9:44 PM, Action <theactionco...@gmail.com> wrote:
> I'm trying to make a "tumblelog" using CakePHP. What this application
> will do is pull in a list of recent activity on services like flickr,
> twitter, delicious, youtube, etc. and display any posts made on them
> in chronological order.

If you're not already, I'd pull all of these items and save them to a
local table, normalising them into a consistent format (date, title,
body).

> The problem I've encountered is how to deal with a comment system.

Each item would have a unique ID and a comment would simply be
attached to that ID.

> comment to the post). The problem here is how do I get a comments
> count next to each post without running a separate query for each post
> title?

You'll need to do one query using COUNT and GROUP BY to sum up comment
totals for each item.

-Jonathan Snook


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google