blaze / blaze/blaze

Support for MySql BINARY(8) and MEDIUMBLOB

Open
#1,494 0 comments 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.