Bind BLOBs as BLOBs instead of strings

duckdb / sqlite_scanner

DuckDB extension to read and write to SQLite databases

https://duckdb.org/docs/extensions/sqlite

MIT License

208 stars 21 forks source link

Bind BLOBs as BLOBs instead of strings #98

Closed asg017 closed 3 weeks ago

asg017 commented 4 months ago

refs #97

When binding a BLOB from DuckDB to SQLite, it would be bound as TEXT instead of a SQLite BLOB. This PR adds a new BindBlob function, which is the same as BindText, but instead uses sqlite3_bind_blob.

I didn't test this locally since I had trouble compiling it myself, but the CI seems to pass just fine?

asg017 commented 3 months ago

Gentle bump - would love to see this get merged! Let me know if there's anything I can do.

Mytherin commented 3 weeks ago

Thanks for the PR! Apologies for the delay, I had not seen it. LGTM