Re: [sqlite] equality searches and range searches with encrypteddata

2008-08-26 Thread Derek Developer
Thanks for the link. Unfortunatly its a little expensive and probably 50% slower than my implementation. No offense, but C is a language that a lot of us tolerate and is not the panacea that some C developers like to believe it is. Reading C is like reading Chinese. ASM may not be a high

Re: [sqlite] FTS, snippet & Unicode?

2008-08-26 Thread Alexandre Courbot
I know there is a patch at http://www.sqlite.org/cvstrac/tktview?tn=3140,38 that is supposed to improve Unicode support in FTS3. I suspect it to turn any Unicode character into a token - however maybe you can use it as a basis to implement what you need. Alex.

[sqlite] SQLite in memory database concurrency model

2008-08-26 Thread Alex Katebi
There is a lot of information about disk file concurrency model. I have not found much information regarding the in memory database concurrency model. Thanks, -Alex ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] GCC -ffast-math safe version of sqlite3IsNaN

2008-08-26 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brown, Daniel wrote: > In the process of upgrading to 3.6.1 I've run into the error on line 46 > of util.c about int sqlite3IsNaN(double x) not behaving consistently > with the GCC -ffast-math compiler option (which we have enabled), is > there any

Re: [sqlite] GCC -ffast-math safe version of sqlite3IsNaN

2008-08-26 Thread Brown, Daniel
Unfortunately our build system is automated and not particularly agile, it can be done but it would be preferred not to have to do that and to replace the offending function instead but I've never had to write a IsNaN test. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [sqlite] GCC -ffast-math safe version of sqlite3IsNaN

2008-08-26 Thread Michael Ruck
Have you tried to compile the util.c/amalgamation file without -ffast-math and use it with your other sources (compiled with -ffast-math)? Mike > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von Brown, Daniel > Gesendet: Mittwoch, 27. August

[sqlite] GCC -ffast-math safe version of sqlite3IsNaN

2008-08-26 Thread Brown, Daniel
Good afternoon list, In the process of upgrading to 3.6.1 I've run into the error on line 46 of util.c about int sqlite3IsNaN(double x) not behaving consistently with the GCC -ffast-math compiler option (which we have enabled), is there any alternative function I could use that would be

Re: [sqlite] create table if not exists & virtual table?

2008-08-26 Thread Dennis Cote
Petite Abeille wrote: > > Is it possible to use 'if not exists' in conjunction with the creation > DDL for a virtual table? > No, its not possible. The syntax of a "create table" statement is shown here http://www.sqlite.org/lang_createtable.html and that for a "create virtual table"

Re: [sqlite] Get transaction number

2008-08-26 Thread Kees Nuyt
On Tue, 26 Aug 2008 20:11:05 +0400, you wrote: >Hello! > >? ? ?? Tuesday 26 August 2008 18:59:55 Igor Tandetnik ???(?): >> > I don't know method to set triggers on begin and commit transaction >> > events. >> >> You could log begin/end transaction (along with any other statements) by

[sqlite] FTS, snippet & Unicode?

2008-08-26 Thread Petite Abeille
Hello, % sqlite3 -version 3.5.9 FTS's snippet seems to truncate Unicode sequences at time. For example, given the following text: Motto: ძალა ერთობაშია (Georgian) "Strength is in Unity" FTS's snippet would return the extract bellow for 'Unity, Freedom, Work': “… ��ია (Georgian) "Strength

[sqlite] create table if not exists & virtual table?

2008-08-26 Thread Petite Abeille
Hello, Is it possible to use 'if not exists' in conjunction with the creation DDL for a virtual table? For example: create table if not exists document( content text ) vs. create virtual table if not exists document using fts3( content text ) The first statement works as advertise, but the

Re: [sqlite] Get transaction number

2008-08-26 Thread Alexey Pechnikov
Hello! В сообщении от Tuesday 26 August 2008 21:24:24 Igor Tandetnik написал(а): > > Thanks, it's better way for my task. But is it safe to logging > > uncommited changes? > > You tell me. Aren't your triggers doing that already? Well, if I'm writing log to other database in single transaction

Re: [sqlite] Get transaction number

2008-08-26 Thread Igor Tandetnik
Alexey Pechnikov <[EMAIL PROTECTED]> wrote: >> By the way, see sqlite3_update_hook. Perhaps you could use that in >> lieu of your triggers. > > Thanks, it's better way for my task. But is it safe to logging > uncommited changes? You tell me. Aren't your triggers doing that already? Igor

Re: [sqlite] Get transaction number

2008-08-26 Thread Alexey Pechnikov
Hello! В сообщении от Tuesday 26 August 2008 18:59:55 Igor Tandetnik написал(а): > > I don't know method to set triggers on begin and commit transaction > > events. > > You could log begin/end transaction (along with any other statements) by > installing sqlite3_trace hook. > > Another approach

Re: [sqlite] Get transaction number

2008-08-26 Thread Igor Tandetnik
Alexey Pechnikov <[EMAIL PROTECTED]> wrote: > ÷ ÓÏÏÂÝÅÎÉÉ ÏÔ Tuesday 26 August 2008 16:44:56 Igor Tandetnik > ÎÁÐÉÓÁÌ(Á): >>> Can I group logged queries by any transaction id? >> >> Well, BEGIN TRANSACTION and END TRANSACTION are themselves queries, >> and thus will presumably appear in your log.

Re: [sqlite] Get transaction number

2008-08-26 Thread Alexey Pechnikov
Hello! В сообщении от Tuesday 26 August 2008 16:44:56 Igor Tandetnik написал(а): > > Can I group logged queries by any transaction id? > > Well, BEGIN TRANSACTION and END TRANSACTION are themselves queries, and > thus will presumably appear in your log. Any queries in between would > then belong

Re: [sqlite] Get transaction number

2008-08-26 Thread Igor Tandetnik
"Alexey Pechnikov" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Â ñîîáùåíèè îò Tuesday 26 August 2008 15:58:56 Jeffrey Becker > íàïèñàë(à): >> I dont believe sqlite supports named transactions. As such there >> wouldnt be any identifier to get. > > Can I group logged queries by

Re: [sqlite] Get transaction number

2008-08-26 Thread Alexey Pechnikov
Hello! В сообщении от Tuesday 26 August 2008 15:58:56 Jeffrey Becker написал(а): > I dont believe sqlite supports named transactions.  As such there > wouldnt be any identifier to get. Can I group logged queries by any transaction id? Best regards, Alexey.

Re: [sqlite] Get transaction number

2008-08-26 Thread Jeffrey Becker
I dont believe sqlite supports named transactions. As such there wouldnt be any identifier to get. On Tue, Aug 26, 2008 at 4:47 AM, Alexey Pechnikov <[EMAIL PROTECTED]> wrote: > Hello! > > How can I get transaction identifier or number (my programm lang is tcl)? > > Best regards, Alexey. >

[sqlite] Get transaction number

2008-08-26 Thread Alexey Pechnikov
Hello! How can I get transaction identifier or number (my programm lang is tcl)? Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users