mattn/go-sqlite3

Implement support for busy handler

Open

#290 opened on Mar 24, 2016

View on GitHub
 (10 comments) (0 reactions) (0 assignees)C (1,105 forks)batch import
enhancementhelp wanted

Repository metrics

Stars
 (7,000 stars)
PR merge metrics
 (Avg merge 1d 5h) (9 merged PRs in 30d)

Description

I think it'd be good for these bindings to support https://www.sqlite.org/c3ref/busy_handler.html .

Use case: I'm currently writing an app that causes quite a bit of traffic to an SQLite database and am encountering contention. I wrote my own wrappers around the queries I'm issuing to handle SQLITE_BUSY errors and retry them... but I just discovered that SQLite3 has a built-in mechanism for this via sqlite3_busy_handler. It would be nice if we could register a hook via SQLiteConn or something like that.

Contributor guide

Research direction
Review the implementation of other handler functions like CommitHook or CreateFunction in the codebase, then add the busy handler binding following the same pattern.
Tech stack
goc
Domain
backend
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
GoC
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
70