[sqlite] System.Data.SQLite: Add [app|web].config file to NuGet package

o the NuGet package? Thanks for considering. Felix Obermaier ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite3 FTS4 matchinfo() problem

. I tdidn't found anything regarding this problem on the web. Consequently I do not have any clue how to fix it. Maybe it is because PHP has problems in dealing with BLOBs? I hope that you guys can help me and I would be very glad for a precise answer. Kind regards, Felix

Re: [sqlite] Can DBI supply a more specific foreign key mismatch error? -- Mea culpa

hopefully wiser and more open monded. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman & rocket surgeon / fe...@crowfix.com GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fer

Re: [sqlite] Can DBI supply a more specific foreign key mismatch error?

proaches. If you don't know the answer, you could either say so or say something useful or say nothing. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman & rocket surgeon / fe...@crowfix.com GPG = E987 4493 C860 246C 3B1E 6477 7838 7

[sqlite] Can DBI supply a more specific foreign key mismatch error?

hanism (which I once used ages ok and remember as being meant for DBI/DBD developers rather than mere SQL hackers :-) -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman & rocket surgeon / fe...@crowfix.com GPG = E987 4493 C860 246C 3

[sqlite] Get extent of RTree quickly

Hello everyone, is there a faster way to get the spanning bounds of an RTree virtual table than querying its min/max values? thanks Felix Obermaier -- Ingenieurgruppe IVV GmbH & Co. KG Dipl.-Ing. Felix Obermaier Oppenhoffallee 171 52066 Aachen Tel

[sqlite] bug with sqlite

hi why isnt it possible to create a database file with the name "con" ? i just doesnt work. no matter what file extension im taking. regrets Felix ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailma

[sqlite] Query optimizer with attached databases

Hello, I have come across several situations in which the sqlite query optimizer chooses clearly suboptimal query plans when a query spans several attached databases. If I copy all involved tables into one sqlite database file, a better query plan is chosen. The difference can be quite dramatic (o

[sqlite] SQLite and signal handlers

Hi, What is a recommended way of handling signals in daemon processes using sqlite database ? Is calling sqlite3_interrupt() in SIGTERM handler considered good enough ? Thanks. Felix. -- View this message in context: http://www.nabble.com/SQLite-and-signal-handlers-tp15306961p15306961

[sqlite] Number of elements in IN clause

Hi, Is there any limitation on the number of elements in IN clause ? Can one have, e.g. thousands of elements ? Also, can having to many elements become inefficient at some point and one has to use some other technique, i.e. comparing elements one by one in a loop ? Thanks in advance. Felix

Re: [sqlite] SQLITE_MAX_EXPR_DEPTH

Hi, Is there any limitation on the number of elements in IN clause ? Thanks. Felix Radensky Embedded Solutions Ltd. drh-2 wrote: > > Jerry Krinock <[EMAIL PROTECTED]> wrote: >> My query: >> >> DELETE FROM `table1` WHERE (`id`=1 OR `id`=2 OR `id`=3 OR ... OR

[sqlite] sqlite for 16 bits microcontroler x186

Hello, I would use sqlite in an embedded DOS system ( intel 16 bits processor ) . Do you think that is possible or sqlite work only on 32/64 bits systems? Do you know an alternative to sqlite? Thank you for your help. Felix

[sqlite] SQLite and SumTotal ToolBook

I would like to use SQLite with ToolBook, (an educational authoring environment running on Windows). I have searched the web and various archives, but nobody seems to have done this before. There is no SQLite wrapper for the OpenScript language that is part of TB. I have linked the SQLite DLL i

[sqlite] What happens with ROWID when doing a "INSERT INTO somenewdb SELECT * FROM someolddb"

advance! Felix

Re: [sqlite] page size and record packing

O. But still, it does ilustrate that chunk size can have a pretty visible impact on performance. Felix

Re: [sqlite] More columns vs. several tables

Am 02.05.2006 um 18:46 schrieb [EMAIL PROTECTED]: Felix Schwarz <[EMAIL PROTECTED]> wrote: I'm wondering whether there is a big performance hit for a simple SELECT binarydata FROM entries WHERE somehash = 27817298; when I use CREATE TABLE entries(

[sqlite] More columns vs. several tables

CTing of data in the second example? Or does it just use SELECTs under the hood itself, i.e. without any caching of data? Thanks in advance for any feedback. Felix

[sqlite] sqlite3_finalize() thread-safety (was: Re: [sqlite] Direct use of SQLite btree functions / performance)

Am 19.04.2006 um 15:31 schrieb [EMAIL PROTECTED]: Felix Schwarz <[EMAIL PROTECTED]> wrote: Hi, I have just discovered these old message on the SQLite Yahoo! Group: http://groups.yahoo.com/group/sqlite/message/2115 http://groups.yahoo.com/group/sqlite/message/2117 This does soun

[sqlite] Direct use of SQLite btree functions / performance

(and do this real quick), how big is the difference between using SQLite or its btree functions directly? Does anybody have experience with this? Thanks in advance! Felix