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 (7,000 stars) (1,105 forks)batch import
enhancementhelp wanted

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

Tech stack
gosql
Domain
backenddatabase
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.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
GoSQLiteCGo
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40
Research direction
Examine the existing sqlite3 busy timeout implementation in the codebase to understand how to register a handler. Implement sqlite3 busy handler by creating a Go function compatible with the C callback signature, ensuring thread safety. Refer to the SQLite C API documentation for details. Check the issue comments for any prior work or suggestions.