tursodatabase/libsql-python

`not yet implemented: blobs not supported`

Closed this issue · 5 comments

I think this is pretty self explanatory. :)

thread '<unnamed>' panicked at src/lib.rs:453:40:
not yet implemented: blobs not supported
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
Traceback (most recent call last):
rows = cur.fetchall()
pyo3_runtime.PanicException: not yet implemented: blobs not supported

For the context, I build Sqlite using Drizzle/Turso in TypeScript. I have one column that is blob. I am now trying to query from Python and got this error. I switched to the native sqlite3 library and it worked fine (I am using local db.sqlite file while prototyping).

I stumbled upon this as well, in my case I believe was an attribute None which I replaced to an empty string meanwhile.

Meehai commented

My solution (check here my migrate script from local to remote -- later I found out there's a cli for this but nonetheless):

insert into table x(col1, col2, col3) values('x', None, 1)

->

insert into table x(col1, col3) values('x', 1)

seems to work but it'd be nice if it handles python Nones like sqlite3 does.

I think this is fixed. I reviewed the code and everything was handled in 74d33d1. Please validate.

I'm no longer working with the project but the commit seems legit.