SQLite Forum

Unique every N seconds. How?
I believe that would only slice things into predetermined 10 second windows. So if one entry was in the last second of its window, and the next entry was in the first second of the next window then it would let them in despite their being 1 or 2 seconds apart.

I can't think of any way of doing this without having a trigger check it.