AnswerDotAI / AnswerDotAI/sqlite-minutils
m2m & lookup functions need safeguards to protect against race conditions
Open
- Dominant language
- Python
- Stars
- 17
- Forks
- 9
- PR merge metrics
- No merged PRs in 30d
Description
Current methodology for both functions relies on last_rowid, which won't suffice under high loads. We need to modify both to run off return values from insert/update/upserts.
Contributor guide
No contributing guide indexed for this repository
Research direction
Locate the m2m and lookup functions and inspect how each currently uses last_rowid. Trace the return values from their insert, update, and upsert operations, then verify that concurrent use no longer depends on last_rowid.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sqlite
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100