zlacker
[parent]
[thread]
2 comments
1. alexbe+(OP)
[view]
[source]
2023-09-25 07:27:16
I'm using SQLite as my main database. Is it a bad idea to build queues on top of SQLite?
replies(2):
>>dunno7+c
>>andrew+Va
◧
2. dunno7+c
[view]
[source]
2023-09-25 07:29:04
>>alexbe+(OP)
No
◧
3. andrew+Va
[view]
[source]
2023-09-25 09:18:59
>>alexbe+(OP)
SKIP LOCKED guarantees that a row can only be read once. This is critical for queueing systems.
SQLite does not support SKIP LOCKED.
[go to top]