mattn/go-sqlite3

Implement support for busy handler

Open

#290 创建于 2016年3月24日

在 GitHub 查看
 (10 评论) (0 反应) (0 负责人)C (7,000 star) (1,105 fork)batch import
enhancementhelp wanted

描述

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.

贡献者指南

技术栈
gosql
领域
backenddatabase
议题类型
feature
难度面向新贡献者的预计实现难度，1 表示很小改动，5 表示专家级工作。
3
预计时间有经验贡献者完成调查、实现、测试并准备 pull request 的粗略时间范围。
1-2 days
活动状态议题当前的可参与程度：新鲜、活跃、陈旧、阻塞或等待维护者输入。
stale
清晰度议题是否清楚说明期望改动、验收标准和下一步。
clear
前置要求
GoSQLiteCGo
新手友好度1-100 的估计分数，表示该议题对首次贡献者的友好程度。
40
研究方向
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.
Implement support for busy handler · mattn/go-sqlite3#290 | Good First Issue