SQLite Forum

Unique every N seconds. How?
Login
You could make a 'time' column that is only accurate to N seconds, so you could make a unique constraint base on it.

You might also be able to set up a trigger to detect the condition and reject it