[sqlite] How do bitwise operators work? Prototype done

2009-07-22 Thread Le Hyaric Bruno
Hi thanks again Igor, I've successfully use sqlite3 on a quite real volume of data with custom bitwise functions for data selection. Here is the script Python 2.5 that serves as a proof of concept : import os import sqlite3 def blob_and(b1,b2): op1 = str(b1) op2 = str(b2) i = 0

Re: [sqlite] How do bitwise operators work? - Example of schema and request

2009-07-21 Thread Le Hyaric Bruno
Can you provide examples of your schema, data, and the types of queries you want to run? This would make it easier to offer suggestions. Rich Of course Richard, In my test I was simply doind something like that : $sqlite3.exe test.db $CREATE TABLE item(id INTEGER PRIMARY KEY

[sqlite] How do bitwise operators work?

2009-07-20 Thread Le Hyaric Bruno
Hi, I'm making some testing with sqlite3. I need to know how bitwise operator work? with which type? Is that possible to use these operators on blob of thousands of bits? To give an idea of the context, I need to store a lot of data (issued from code coverage analysis). I'm trying to store this

Re: [sqlite] How do bitwise operators work?

2009-07-20 Thread Le Hyaric Bruno
Ok, thanks to you guys. But is there someone who can tell me where can I plug my specific operators? And even is that feasible? Bruno. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users