postgres wise: I use an INT field to store bitwise data. I wrote a class that declares enumerated sets and manages the the bitwise operations, then serializes it to an int. I use an @property to deserialize reads and manually serialize the writes (not enough time/need to integrate with SqlAlchemy deeper)
I haven't had to search on these fields, and likely won't ever need to. My understanding though is that: 1. the planner would perform bitwise operations on an index if the column is indexed 2. you can create partial/function indexes on the bits, and I believe there are some plugins in this area, including a fork of postgis -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.