proposal: database/sql: support a way to perform bulk actions · golang/go#5171

2013-03-31T09:23:39.000Z

The current implementation of database/sql doesn't provide a way to insert multiple rows at once, without getting to the wire upon every call to db.Exec There are APIs outside which either provide a general way for bulk actions cf. SQLBulkCopy of ADO.NET 2.0 [1] or has a specifier upto how many statements should be grouped together cf. Batch Update of ADO.NET 2.0 DataAdapter Object [1] or simply supports an array to be bound to Exec, open which Exec iterates internally, preventing execessive wire communication. [2] [1] Codeproject, "Multiple Ways to do Multiple Inserts" http://www.codeproject.com/Articles/25457/Multiple-Ways-to-do-Multiple-Inserts [2] Python PEP 249 -- Python Database API Specification v2.0 http://www.python.org/dev/peps/pep-0249/#executemany

(19 评论) (57 反应) (0 负责人)Go (19,008 fork)batch import

FeatureRequestProposalhelp wanted

仓库指标

Star: (133,883 star)
PR 合并指标: (30 天内没有已合并 PR)

描述

此议题没有描述。

贡献者指南

研究方向: 研究如何通过研究现有的 Exec 和查询接口在 database/sql 中添加批量操作支持，并回顾其他语言中的类似实现（例如 Python 的 executemany）。提出一种设计，将查询批量处理以减少网络往返。
技术栈: go
领域: database
议题类型: 功能
难度: 2
预计时间: 1-3 小时
活动状态: 活跃
清晰度: 清晰
前置要求: Go
新手友好度: 70

仓库指标

描述

贡献者指南

每天在邮箱收到新鲜 Easy issues。