--- Log opened Thu Sep 06 00:00:46 2012
10:34 < conseo> mcallan: when the track client fetches the update 10s after a kick, how is it supposed to query the db? we have talked about the column for parsed-date, which easily allowed querying for new messages in the db, but then agreed to save sent-date only.
10:35 < conseo> should i just refetch all posts for now or is this too much?
13:06 < mcallan> googling, looks like this was the thread: http://mail.zelea.com/list/votorola/2012-April/thread.html#1329
13:10 < mcallan> so i guess the primary key is a serial number.  that's what client queries for.  send date is what client *sorts* on, but it's just an ordinary column.  (though you might make it indexed column in future, if you need to query on it)
13:11 < mcallan> basically the client says, give me messages newer than M, where M is a serial number, not a date
13:17 < mcallan> conseo: so just use 'serial' instead of 'parsedDate', because date is no good as a primary index
13:19 < conseo> mcallan: ok
13:20 < conseo> it is that way atm. with "serial id primary key"
21:57 < conseo> mcallan: can i use a.count.XCastRelation for the DB? i had my own enumeration but yours is better documented and using a single char is neat
21:57 < conseo> but it has to be stable, because it is stored in the db
22:02 < mcallan> ok.  i have no plans to change it
22:04 < conseo> i would add: OTHER( 'o' ) to the list for the diffmessage relation, if this is ok for your
22:04 < conseo> you
22:09 < mcallan> conseo: http://zelea.com/project/votorola/_/javadoc/votorola/s/gwt/stage/vote/LightableDifference.html
22:10 < mcallan> 'o' is for co-voter.  see REL_UNKNOWN, which uses 'u'
22:12 < conseo> damn, sry
22:12 < conseo> i haven't seen that o is already taken
22:14 < conseo> mcallan: but unknown is not in http://zelea.com/project/votorola/_/javadoc/votorola/a/count/XCastRelation.html
22:14 < mcallan> no, because it's not an actual relation.  it's in the link i just pasted
22:15 < mcallan> (REL_UNKNOWN)
22:20 < conseo> mcallan: yes, i have seen that. should i use votorola.s.gwt.stage.vote.LightableDifference in my server side code?
22:21 < mcallan> true, that would be weird.  maybe add XCastRelation.UNKNOWN (the cast relation is unknown).  more stable that way, too
22:25 < conseo> ok, good
--- Log closed Fri Sep 07 00:00:03 2012