bit masks on SQLite

Question

I saw across this site questions similar to this one and the answers were usually not to use bit masks. One of the strongest reasons not to do that was that it even won't save memory because the SQL server wrapped bit columns to a single byte.
However, to my understanding, there are no bit columns in SQLite so there will be some memory waste.

What do you think? To use or not to use?

Use what? In SQLite you can't at all. – LS_ᴅᴇᴠ Dec 03 '13 at 13:39 — LS_ᴅᴇᴠ, Dec 03 '13 at 13:39

score 1 · Answer 1 · answered Dec 03 '13 at 13:46

1

Use them masked in integers. SQLite internally uses varint to save space, such that smaller values will use less bytes (from The SQLite Database File Format)

answered Dec 03 '13 at 13:46

LS_ᴅᴇᴠ

10,823
1
23
46

bit masks on SQLite

1 Answers1