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
-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
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
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
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
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
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
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
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
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
10 matches
Mail list logo