Re: [sqlite] I keep getting seg faults building my database using python sqlite3

Good feedback. I haven't done a memory check on that machine in a while Next on my list. On Sun, Dec 4, 2016 at 11:25 AM, Keith Medcalf wrote: > > If pressing the CAPS LOCK or NUM LOCK keys on the keyboard does not toggle > the light on the keyboard then you have lost

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

On 7 Dec 2016, at 11:28pm, Jay Weinstein wrote: > Is it correct to say busy timeout will work for two separate processes and > I don't have use fork in C/C++ or ProcessBuilder in java to execute one as > a child and a parent? The timeout setting is attached to the database

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

Hi, Is it correct to say busy timeout will work for two separate processes and I don't have use fork in C/C++ or ProcessBuilder in java to execute one as a child and a parent? Thanks, Jay On Wed, Dec 7, 2016 at 11:02 AM, R Smith wrote: > Yes, multiple access is a feature,

Re: [sqlite] Foreign key child index question

On 7 Dec 2016, at 8:40pm, David Raymond wrote: > Question on making indexes for the child fields of foreign keys. I have a > child table with a number of foreign keys on fields which the majority of the > time are null. I've currently got indexes on the child fields

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

Thanks for the info! On Wed, Dec 7, 2016 at 11:02 AM, R Smith wrote: > Yes, multiple access is a feature, a basic necessity even. > > The answer is here: > http://www.sqlite.org/pragma.html#pragma_busy_timeout > > Explanation: >

[sqlite] Foreign key child index question

http://www.sqlite.org/foreignkeys.html#fk_indexes Question on making indexes for the child fields of foreign keys. I have a child table with a number of foreign keys on fields which the majority of the time are null. I've currently got indexes on the child fields for the purposes of speeding

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

Yes, multiple access is a feature, a basic necessity even. The answer is here: http://www.sqlite.org/pragma.html#pragma_busy_timeout Explanation: https://www.sqlite.org/c3ref/busy_timeout.html and http://www.sqlite.org/tclsqlite.html see the section: The "timeout" method On 2016/12/07 8:54

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

On 7 Dec 2016, at 6:54pm, Jay Weinstein wrote: > I’m running two programs, one written in java and one written in C, which are > both trying to access a sqlite database. I'm getting the error > org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked >

[sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

Hi, I’m running two programs, one written in java and one written in C, which are both trying to access a sqlite database. I'm getting the error org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked) when I run both as separate processes and when the java

Re: [sqlite] SQLITE_OMIT_BUILTIN_TEST renders fix for ticket [da784137] useless

On 12/7/16, Ralf Junker wrote: > > I assumed that > binaries on sqlite.org would omit test code for best performance. We go by the principle of "Fly what you test, and test what you fly". > >> The SQLITE_OMIT_BUILTIN_TEST option is untested and unsupported. > > This was not

Re: [sqlite] SQLITE_OMIT_BUILTIN_TEST renders fix for ticket [da784137] useless

On 07.12.2016 14:21, Richard Hipp wrote: Side note: I notice that the SQLite binaries (Windows, at least) are not compiled with SQLITE_OMIT_BUILTIN_TEST and not affected by the problem. Is there a reason to omit SQLITE_OMIT_BUILTIN_TEST from the builds, as it adds at least some overhead? >

Re: [sqlite] performance issue through Dll upgrade

On 1 Dec 2016, at 7:24am, Stephan Stauber wrote: > SQLite 3.8.5: to INSERT 380.000 records into a in > inMemory Database it takes 10 seconds > SQLite 3.10.0 to INSERT 380.000 records into a in > inMemory Database it takes 35

Re: [sqlite] SQLITE_OMIT_BUILTIN_TEST renders fix for ticket [da784137] useless

On 12/7/16, Ralf Junker wrote: > > Side note: I notice that the SQLite binaries (Windows, at least) are not > compiled with SQLITE_OMIT_BUILTIN_TEST and not affected by the problem. > Is there a reason to omit SQLITE_OMIT_BUILTIN_TEST from the builds, as > it adds at least some

[sqlite] SQLITE_OMIT_BUILTIN_TEST renders fix for ticket [da784137] useless

Alarming side effect of SQLITE_OMIT_BUILTIN_TEST: It renders the fix [005d5b87] for ticket [da784137] useless. Ticket: http://www.sqlite.org/src/info/da7841375186386c Fix, trunk: http://www.sqlite.org/src/info/005d5b870625d175 Fix, 3.15.2: http://www.sqlite.org/src/info/27438fb43db4eae9

[sqlite] performance issue through Dll upgrade

sorry for the delayed response. with 3.15.2 it is even worse ( it takes 1246s to INSERT 380.000 records) with 3.8.5 it took only 10s Best regards Stephan ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Problem with CASE in WHERE clause

>1) SELECT * FROM TEST WHERE posted = 1; >[(‘inv’, 100, 1)] > >2) SELECT * FROM TEST WHERE posted = ‘1’; >[(‘inv’, 100, 1)] > >3) SELECT * FROM TEST WHERE CASE WHEN tran_type = ‘inv’ THEN posted END = 1; >[(‘inv’, 100, 1)] > >4) SELECT * FROM TEST WHERE CASE WHEN tran_type = ‘inv’

Re: [sqlite] Updating multiple records in C#

Wednesday, December 7, 2016, 9:15:57 AM, you wrote: Thanks Ryan, this looks very useful, think I've got what I need now to make it work! Richard >> But how do I do this for multiple records and mutiple fields? I >> imagine I need to use SQLiteTransaction here but I'm not sure about >> the

Re: [sqlite] Updating multiple records in C#

Wednesday, December 7, 2016, 3:12:05 AM, you wrote: >> On Dec 6, 2016, at 5:40 PM, Richard Andersen wrote: >> >> cmd.CommandText = @"UPDATE pdata SET FileName = @fileName WHERE FileName = >> 'filename.zip'"; > You can add other columns to set by adding more “name = value” >

Re: [sqlite] Updating multiple records in C#

On 2016/12/07 3:40 AM, Richard Andersen wrote: I have a table with several thousand records each with multiple fields. One field contains a filename, this is the only unique field so I use it to identify the different records. What I need is a way to update all fields that have changed in any