Re: [sqlite] Performance of SELECT: What am I doing wrong?

On Wed, Oct 26, 2011 at 5:01 PM, Jay A. Kreibich wrote: >  The use of IS is causing the query optimizer to use a full table >  scan, essentially turning the query into a O(n) operation.  This has >  to do with how IS differs from = in the handling of NULLs.  Since it >  is

Re: [sqlite] Remove from mailing list please.

On 10/26/2011 9:49 PM, G. J. Weinberger wrote: Please remove me from mailing list. One kind person helped me; as for the rest, the issues discussed are way over my head. Every message you get from the list displays a link at the bottom where you can go to edit your membership. Here it is

[sqlite] Remove from mailing list please.

Please remove me from mailing list. One kind person helped me; as for the rest, the issues discussed are way over my head. Cordially, GJW G. J. Weinberger 9 Mulberry Lane Farmington, CT 06032 USA ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Error messages from user-defined functions calling sqlite3_result_error() requires sqlite3_finalize?

Oh, that *is* funny. Peter > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Jean-Christophe Deschamps > Sent: Wednesday, October 26, 2011 6:12 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Error

Re: [sqlite] Error messages from user-defined functions calling sqlite3_result_error() requires sqlite3_finalize?

Funny coincidence in time, I just posted on the same subject while your post was being received! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3_errcode() and sqlite3_errmsg()

Dear list, It seems that after sqlite3_prepare_v2() and sqlite3_step() we have that sqlite3_errcode() returns meaningful result right away when some function invokes sqlite3_result_error() during sqlite3_step(). OK so far. The issue is with sqlite3_errmsg(). If a function post an ad-hoc

[sqlite] Error messages from user-defined functions calling sqlite3_result_error() requires sqlite3_finalize?

This may be a known thing, but I can't find anything on it on-line.  I finally figured out a solution by examining the code to shell.c. OK, I have a user-defined function in an extension that calls sqlite3_result_error() when an out-of-bounds argument is passed in.  I called

Re: [sqlite] Performance of SELECT: What am I doing wrong?

On Wed, Oct 26, 2011 at 11:35:33PM +0200, Tobias Mohrl?der scratched on the wall: > On Wednesday, Oct 26, 2011 at 02:26PM Jay A. Kreibich wrote: > > > On Tue, Oct 25, 2011 at 11:51:46PM +0200, Tobias Mohrl?der scratched on the > > wall: > >> Hello everybody, > >> > >> I strongly believe that

Re: [sqlite] Performance of SELECT: What am I doing wrong?

On Wednesday, Oct 26, 2011 at 02:26PM Jay A. Kreibich wrote: > On Tue, Oct 25, 2011 at 11:51:46PM +0200, Tobias Mohrlüder scratched on the > wall: >> Hello everybody, >> >> I strongly believe that my setup is somehow wrong, I just can't figure >> out how. > > >> sqlite3_prepare_v2(db, "SELECT

Re: [sqlite] Bug in using overloaded functions for virtual tables?

Here are the opcodes generated for each operation using the EXPLAIN command sqlite> explain select offsets(pasta_text), DataPasta from pasta_text where past a_text match 'andamento*'; addr opcode p1p2p3p4 p5 comment -

Re: [sqlite] Corrupt format in sqlite file

On 26 Oct 2011, at 7:05pm, G. J. Weinberger wrote: > Can anyone out there help me? The instructions you quoted are fairly clear. Do you understand what ~/Library/Application Support/GarageSale/garagesale.sqlite means ? '~' means your home folder. Then inside that folder, look for a folder

[sqlite] Corrupt format in sqlite file

Hello. I use GarageSale as my ebay listing tool. Suddenly, I am unable to post, duplicate templates etc., getting this message (screen shot): file://localhost/Users/bill/Desktop/Screen%20shot%202011-10-26%20at%2010.01.20%20AM.pngG. J. Weinberger Garage sale has only sent me this message re some

Re: [sqlite] Using SQLite on Windows 64bit

Not sure what is causing the problem..and thus my suggestion(s) can be labelled as trial and error --- 1. Check the target platform (try with x64 if it is 'any cpu'). Thanks & Regards Taleeb Anwar *Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!* On Wed, Oct 26, 2011 at 11:09 PM, J

Re: [sqlite] Using SQLite on Windows 64bit

J Trahair wrote: > > Works on my development 64bit machine, not on the customer's 64bit. > The most likely cause for it working on your development machine and not on your customer's machine is that you have the Microsoft Visual C++ 2010 Runtime Library installed and your customer does not. > >

Re: [sqlite] Using SQLite on Windows 64bit

HI. There's no SQLite.Interop.dll, anywhere. I downloaded sqlite-netFx40-setup-bundle-x64-2010-1.0.76.0.exe which gave me System.Data.SQLite.dll. Works on my development 64bit machine, not on the customer's 64bit. How do I get the interop? Thank you. Jonathan Trahair - Original

Re: [sqlite] Using SQLite on Windows 64bit

J Trahair wrote: > > However, I have installed the same installation setup.exe on a separate Windows > 64bit computer, and it comes up with the error message 'Could not load file or > assembly System.Data.SQLite.dll or one of its dependencies, the specified module > could not be found.' However,

Re: [sqlite] Performance of SELECT: What am I doing wrong?

On Tue, Oct 25, 2011 at 11:51:46PM +0200, Tobias Mohrlüder scratched on the wall: > Hello everybody, > > I strongly believe that my setup is somehow wrong, I just can't figure > out how. > sqlite3_prepare_v2(db, "SELECT * FROM mytable WHERE MyKey IS ?", -1, , > 0); Don't use "IS", use "=".

[sqlite] Using SQLite on Windows 64bit

Hi. I want to install a VB.Net application onto a customer's Windows 64bit computer. I have my own Windows 64bit laptop with Visual Studio 2010 installed. I have a VB.Net application which uses SQLite successfully, both in the development runtime, and as an 'installed' program in a separate

[sqlite] Performance of SELECT: What am I doing wrong?

Hello everybody, I'm currently experimenting with SQLite (3.7.8) and am a complete newbie in the field of SQL databases. Running performance comparisons between a C++ std::map< int, std::string > and an in-memory SQLite database, I found SQLite to be astonishingly slow when selecting single

Re: [sqlite] Multiple databases in one DB connection. How to let BEGIN TRANSACTION..COMMIT apply to only one of them?

Well, if the statements within your BEGIN TRANSACTION ... COMMIT only really affects one database (hereafter called the main database) only that database should be locked. If you experience otherwise, it could be because: 1. The locking_mode for the databases has been set to EXCLUSIVE (see

Re: [sqlite] triggers : NEW keyword with multiple tables

> You haven't given the view explicit column names How ? > try this instead: > > CREATE VIEW my_view AS SELECT table1.type as table1_type, table2.type > as table2_type FROM Yes this works on latest version. But I wonder why the other syntax is not accepted anymore. Because I'll have to rewrite

Re: [sqlite] triggers : NEW keyword with multiple tables

> Try NEW."table1.type" and NEW."table2.type" This works with my old 3.6 version but not on 3.7.8 I still get : Error: no such column: NEW.table1.type ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Multiple databases in one DB connection. How to let BEGIN TRANSACTION..COMMIT apply to only one of them?

While one of the databases is under a lengthy writing process, I don't want other databases to be locked by the BEGIN TRANSACTION...COMMIT lock. Is this possible? Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org