Types: Add support for BINARY columns and improve support for FLOATs

crate / sqlalchemy-cratedb

SQLAlchemy dialect for CrateDB.

https://cratedb.com/docs/sqlalchemy-cratedb/

Apache License 2.0

3 stars 2 forks source link

Types: Add support for BINARY columns and improve support for FLOATs #12

Open amotl opened 9 months ago

amotl commented 9 months ago

About

Improvements to be mainlined from https://github.com/pyveci/supertask/blob/19316e2/supertask/store/cratedb.py. The support for binary data types is being emulated by serializing them to STRING using base64. In that way, pickled data can be stored and retrieved without further ado.

Backlog

[ ] Documentation
[ ] Software tests

amotl commented 9 months ago

Keep in mind that CrateDB also supports BitString type, but I don't think that's what we want here, right?

Right. Here, it is about providing an emulation for a BLOB-type column. However, expanding type support to include the BIT type will be nice to have for the sake of completeness. So far, I didn't need it, but I am sure others will.