[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Chicken-janitors] #675: pastiche needs a better database scheme

From: Chicken Trac
Subject: [Chicken-janitors] #675: pastiche needs a better database scheme
Date: Fri, 26 Aug 2011 14:27:22 -0000

#675: pastiche needs a better database scheme
 Reporter:  mario                      |       Owner:  ckeen
     Type:  defect                     |      Status:  new  
 Priority:  not urgent at all          |   Milestone:  4.8.0
Component:  extensions                 |     Version:  4.7.x
 Keywords:  pastiche sqlite db scheme  |  
 Currently it is not possible to hand out the correct links for annotation
 in the "browse pastes" tab.

 This is because we do not mark a db entry as being an annotation but this
 is detected on the fly when displaying all pastes with a certain hash.
 Annotations are defined to have the same sha1-hash as the original paste
 but a different timestamp.

 So this is easy to do when displaying all entries for one hash and sorting
 them by timestamp, but this fails when we say "get me the last N additions
 to the database".

 A better db scheme is needed

Ticket URL: <>
Chicken Scheme <>
Chicken Scheme is a compiler for the Scheme programming language.

reply via email to

[Prev in Thread] Current Thread [Next in Thread]