search

tursodatabase / libsql-experimental-python

libSQL API for Python (experimental)
108 stars 10 forks source link

`not yet implemented: blobs not supported` #62

Open flexchar opened 5 months ago

flexchar commented 5 months ago

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
flexchar commented 5 months ago

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).

isaccavalcante commented 4 months ago

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 1 month ago

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.