Support for MySql BINARY(8) and MEDIUMBLOB
- Dominant language
- Python
- Stars
- 3.2k
- Forks
- 389
- PR merge metrics
- No merged PRs in 30d
Description
I have a Mysql database with columns of type BINARY(8) and MEDIUMBLOB.
Tables with these columns are not accessible through blaze. I get warnings of type:
> Blaze does not understand a SQLAlchemy type.
> Blaze provided the following error:
> No SQL-datashape match for type BINARY(8)
> Skipping.
Is there any plan to support such datatypes or are there any workarounds?
I am able to load these columns in Pandas, so I guess it is not an intrinsic sqlalchemy issue.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the warning with a MySQL table containing BINARY(8) and MEDIUMBLOB, then trace how Blaze maps SQLAlchemy types to datashapes. Done means both column types are recognized and tables containing them can be accessed without the reported warnings or skipped columns.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, python, sqlalchemy
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100