-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello,
I'm asking for your opinions here. Do you feel, that new time fields should in general use the new POSIX microseconds format, or is it ok to use seconds, if the extra precision doesn't matter, i.e. no change tracking like done for ticket changes? If I understood correctly, this was the main reason behind the move to microseconds for Trac time field. Current Trac schema is not completely convincing, because it has a mix of both: microseconds (since 0.12): 'time' in 'attachment' 'time' in 'wiki' 'time' in 'revision' 'time' in 'ticket' 'changetime' in 'ticket' 'time' in 'ticket_change' 'due' in 'milestone' 'completed' in 'milestone' 'time' in 'version' seconds: 'time' in 'auth_cookie' 'last_visit' in 'session' In Trac plugins it is much less common. Until now I've found microseconds time fields in 0.12/trunk branches of AnnouncerPlugin WatchlistPlugin RemoteTicketPlugin TracJsGanttPlugin MailPlugin BudgetingPlugin MsSqlBackendPlugin but only WatchlistPlugin using it in the 0.11 branch too. Reason behind is that I plan to add time stamps to VotePlugin [1] for generating lists like 'vote history' etc. [2]. As use cases include reports with SQL JOIN on ticket or wiki table, this might be an argument to go for microseconds. Indirectly this is a question about persistence of support for seconds time fields in trac.util.datefmt, specifically about 'to_timestamp'. That's why I'm not asking at trac-users. Hoping to get some helpful comments here. Sincerely, Steffen Hoffmann [1] http://trac-hacks.org/wiki/VotePlugin [2] http://trac-hacks.org/ticket/7592 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlFQHTsACgkQ31DJeiZFuHe9aQCfRMxL+J1ZBK/dWax6EyxxuNsu HYMAmQGinI2az8OmrSTxQQ3N/C8NFYZP =Zl0j -----END PGP SIGNATURE----- -- You received this message because you are subscribed to the Google Groups "Trac Development" group. To unsubscribe from this group and stop receiving emails from it, send an email to trac-dev+unsubscr...@googlegroups.com. To post to this group, send email to trac-dev@googlegroups.com. Visit this group at http://groups.google.com/group/trac-dev?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
