This is more of a general application design question than a CakePHP question... - CakePHP

Message from discussion This is more of a general application design question than a CakePHP question...

Action

More options May 11, 10:03 pm

From: Action <theactionco...@gmail.com>

Date: Sun, 11 May 2008 19:03:06 -0700 (PDT)

Local: Sun, May 11 2008 10:03 pm

Subject: Re: This is more of a general application design question than a CakePHP question...

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

Yeah, comments would be an afterthought if I had the data locally, so
that's what I originally thought about doing. BUT the problem with
that is that how do I determine when I save that data? Do I just run a
save query 15 times each time a page is loaded (or the cache is
updated) with isUnique set in the model's validation parameters?

On May 11, 9:52 pm, "Jonathan Snook" <jonathan.sn...@gmail.com> wrote:

> 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 to author Forward