[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? Prototype done

2009-07-22 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Since the solution is now specific to Python, I suggest continuing on the pysqlite/APSW mailing list - http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite and http://news.gmane.org/gmane.comp.python.db.pysqlite.user Le Hyaric Bruno

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

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

2009-07-21 Thread Igor Tandetnik
Le Hyaric Bruno bruno.le-hya...@fr.thalesgroup.com wrote: My wish is to be able to select an item like that : $SELECT id FROM item WHERE bits 1'X'; (where X is a random value from 0 to 20...) If you go custom function route for this, you may benefit from incremental blob API - see

[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 Igor Tandetnik
Le Hyaric Bruno wrote: I need to know how bitwise operator work? Same as in C or C++. with which type? With integers. Is that possible to use these operators on blob of thousands of bits? Not to my knowledge. For something like that, consider writing a custom function. Igor Tandetnik

Re: [sqlite] How do bitwise operators work?

2009-07-20 Thread John Machin
On 20/07/2009 11:05 PM, Le Hyaric Bruno wrote: 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

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

Re: [sqlite] How do bitwise operators work?

2009-07-20 Thread Rich Shepard
On Mon, 20 Jul 2009, Le Hyaric Bruno wrote: But is there someone who can tell me where can I plug my specific operators? And even is that feasible? 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

Re: [sqlite] How do bitwise operators work?

2009-07-20 Thread Igor Tandetnik
Le Hyaric Bruno bruno.le-hya...@fr.thalesgroup.com wrote: But is there someone who can tell me where can I plug my specific operators? You cannot provide your own operations, but you can provide your own functions: http://sqlite.org/c3ref/create_function.html Then you can write something