Re: [Fofredux-devel] cache_time on feeds

[Evan R. <eva...@gm...>]

The cache_time has an attribute of 'ON UPDATE CURRENT_TIMESTAMP'.  This is
obviously new in redux, since the original FoF did not use cache_time.  i
was doing some tests last night, and it seems that the first TIMESTAMP fiel=
d
in a table gets this attribute automagically from ADODB (which was also not
included in FoF, iirc).

when you are reading an item, it is ok, since the field value is correct.
when you mark it read or save or do anything else to the record, this
attribute triggers, and cache_time is rewritten to the time of the update.
Thus, we lose the information when we stored this bit of data.

If you ask me, i'd be of the opinion that we need 3 dates:
when was it published -> taken from RSS
when was it cached -> on insert
when was it changed -> on update (ie. read, unread, saved, etc...)

one could argue that the cache_time is not important, since we have publish
time...but often they are largely different for me:
1.  being in germany, and reading mostly stuff from the homeland...i am
dealing with 6-9 hrs difference, which could not come through.  ie.
published at 12:00 local time EST, but cached at 18:00 local time CET.
2.  and the most important point for me...often times there is a delay from
when content is published to when it shows up in an rss feed.  hence, we ge=
t
a new item 2 hrs after it was really published, and therefore, it won't sho=
w
on the top of the list.

i'd prefer to be able to sort my items by cache_time, rather than
publish_time, to see the new items (to me!) always at the top.

On 4/21/06, Kevin <ke...@dr...> wrote:
>
> Evan Roth wrote:
> ...
> > in the end it's not absolutely necessary, but the auto-timestamping on
> > cache_time needs to go.  i suspect that the adodb stuff adds it, when
> > we add the field, as it's the first timestamp in the table.
> I still don't understand.   What about the handling of the cache_time
> field is wrong?   Could you provide a test case so I can reproduce it?
>
> -Kevin
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronim=
o
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> Fofredux-devel mailing list
> Fof...@li...
> https://lists.sourceforge.net/lists/listinfo/fofredux-devel
>