aio-libs / aio-libs/aiomysql

Inserting large binary blobs

未關閉
#450 2 則留言 0 個 reaction 已指派 0 人 在 GitHub 檢視
bug
主要語言
Python
星號
1.9k
分支
272
PR 合併指標
30 天內沒有已合併 PR

描述

I'm trying to insert a large binary blolb (column type `LONGBLOB`) into a local mariadb instance using `aiomysql` version 0.0.20 (https://pypi.org/project/aiomysql/).

I pass the blob inside a python `str` object via `INSERT` using the `%` syntax: `execute('INSERT INTO blah VALUES (%s)', (large_blolb))`.

The blob is rather large (~500million character, so probably ~0.6 to 1GB), but certainly bellow the 4GB limit of `LONGBLOB`

The insert seems to fail due to network errors... How may I go about doing this ? Is there an option doing with with aiomysql ? What would be the easiest async alternative (e.g. starting an async sub-process and having mariadb read from a file)

貢獻指南

開啟貢獻指南

評估

這個 Issue 還沒有評估資料。

把新 issue 寄到你的電子郵件信箱

精選適合新手參與的 GitHub issue 摘要。