I'm trying to use db-to-sqlite to convert a set of MySQL DDL files into an SQLite database. Some of my tables use the BIT(1) type to encode boolean values but the resulting SQLite database ends up with BLOB columns where I think INTEGER would be more natural for SQLite.
This is new territory for me but things I've picked up while researching my issue are:
MySQL doesn't have a full-fledged boolean type, similar to SQLite
People either use TINYINT or BIT(1) to store bools in a space-efficient way
TINYINT(1) may have even been an alias for BIT(1) at some point (source) but is no longer
I think it would be nice if db-to-sqlite could turn BIT(1) fields into INTEGER rather than BLOB because the current behavior is harder to query than it needs to be.
I'm happy to submit a PR for this with tests covering this and any related behavior.
I'm trying to use
db-to-sqlite
to convert a set of MySQL DDL files into an SQLite database. Some of my tables use theBIT(1)
type to encode boolean values but the resulting SQLite database ends up withBLOB
columns where I thinkINTEGER
would be more natural for SQLite.This is new territory for me but things I've picked up while researching my issue are:
I think it would be nice if
db-to-sqlite
could turnBIT(1)
fields intoINTEGER
rather thanBLOB
because the current behavior is harder to query than it needs to be.I'm happy to submit a PR for this with tests covering this and any related behavior.