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。