Dear all,
I use sqlite to store, query and perform simple math operations on large
datasets of small integers -- all values I have in the dataset are -1, 0, 1
and 2. These integers are stored as INTEGER (4 byte). I desperately need a
way to reduce the size of my database because I have dozens of databases
like this with size ~100G which takes too much of my storage. I'd like some
other integer type for {-1,0,1,2} such as "SMALLINT" (
http://www.sqlite.org/datatype3.html). I understand sqlite data types are
dynamic and it does not make a difference to create a field of type
SMALLINT. I wonder if there are something I can do to fulfill my need.
Anyway to hack into the sqlite.c codes?
Please advice. Thank you!
Kindest regards,
Gao Wang
Student in Statistical Genetics, Baylor College of Medicine
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
