3 ms·
Out of curiosity, is there any kind of support for bitmaps in mainstream databases?
by Yoric 5y ago
Out of curiosity, is there any kind of support for bitmaps in mainstream databases?
- bob1029 5y agoYou can just roll it yourself in the application logic and store as a raw binary column. This all assuming you don't need to make queries along the axis of "give me every user with role X".
- tremon 5y agoYes and no: there is no bitmap SQL type, but at least MSSQL packs multiple BIT-columns on the same table into the same word/byte and then uses bit tests for filtering. I suspect Oracle and Postgresql can do the same, but I don't know for sure.