I'm using SQLite as my main database. Is it a bad idea to build queues on top of... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		alexbezhan on Sept 25, 2023 \| parent \| context \| favorite \| on: Choose Postgres queue technology I'm using SQLite as my main database. Is it a bad idea to build queues on top of SQLite?

andrewstuart on Sept 25, 2023 | [–]

SKIP LOCKED guarantees that a row can only be read once. This is critical for queueing systems.

SQLite does not support SKIP LOCKED.

dunno7456 on Sept 25, 2023 | [–]

No

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact