Re: [sqlite] Fwd: How can I make this faster?

2017-08-23 Thread J Decker
On Mon, Aug 14, 2017 at 2:34 AM, Rowan Worth wrote: > On 14 August 2017 at 17:11, J Decker wrote: > > > I monitored the process with ProcMon (I'm on windows 7 BTW) > > > > 12:55:34.7416316 AM node.exe 9012 WriteFile > > \Device\HarddiskVolume17\javascript\gun.db\gun.db-wal SUCCESS Offset: > > 18

Re: [sqlite] Documentation Error

2017-08-23 Thread J Decker
https://www.sqlite.org/c3ref/open.html On Wed, Aug 23, 2017 at 10:29 PM, J Decker wrote: > > > If URI filename interpretation is > enabled, and the filename argument begins with "file:", then the filename > is interpreted as a URI. URI filename interpretation is

[sqlite] Documentation Error

2017-08-23 Thread J Decker
If URI filename interpretation is enabled, and the filename argument begins with "file:", then the filename is interpreted as a URI. URI filename interpretation is enabled if the SQLITE_OPEN_URI flag is set in th

[sqlite] Upgrade to SQLite 3.20.0 im Mozilla - Consequences for Mozilla Thunderbird

2017-08-23 Thread Jörg Knobloch
Dear SQLite developer, Mozilla have upgraded to SQLite 3.20.0 and that has caused the Thunderbird test suite some test failures [1] as follows: Assertion failed: (p->flags & MEM_Dyn)==0 || p->szMalloc==0, file sqlite3.c, line 70285 One of the Mozilla developers was of the opinion that the c

Re: [sqlite] pragma pragma_list

2017-08-23 Thread Bart Smissaert
Figured this out. SQLITE_INTROSPECTION_PRAGMAS needs to be a Preprocessor definition in MSVS. Not sure why all the pragma's are duplicated. Is this a bug? RBS On Wed, Aug 23, 2017 at 6:17 PM, Bart Smissaert wrote: > Using the latest 3.20.0 and trying to get this pragma to work. > I am compilin

Re: [sqlite] Compiling spellfix for sqlite3

2017-08-23 Thread Keith Medcalf
On Wednesday, 23 August, 2017 16:28, Dominique Devienne wrote: >On Wed, Aug 23, 2017 at 6:11 PM, Keith Medcalf wrote: >> sqlite> pragma function_list; >> group_concat|1 >> group_concat|1 >> julianday|1 >> julianday|1 >> nullif|1 >> nullif|1 >> sqlite_compileoption_get|1 >> sqlite_compileoption

Re: [sqlite] Compiling spellfix for sqlite3

2017-08-23 Thread Dominique Devienne
On Wed, Aug 23, 2017 at 6:11 PM, Keith Medcalf wrote: > > sqlite> pragma function_list; > group_concat|1 > group_concat|1 > julianday|1 > julianday|1 > nullif|1 > nullif|1 > sqlite_compileoption_get|1 > sqlite_compileoption_get|1 > current_timestamp|1 > current_timestamp|1 > sqlite_compileoption_

[sqlite] pragma pragma_list

2017-08-23 Thread Bart Smissaert
Using the latest 3.20.0 and trying to get this pragma to work. I am compiling in MSVS 12 and added this to the compile options: -DSQLITE_INTROSPECTION_PRAGMAS=1 It compiles fine, but I get no output and I expected a list of pragma's. pragma database_list works fine and gives me the expected outp

Re: [sqlite] Compiling spellfix for sqlite3

2017-08-23 Thread curmudgeon
Thanks for the explanation Keith and the help. I've learned a lot the last few days. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Compiling-spellfix-for-sqlite3-tp70656p97040.html Sent from the SQLite mailing list archive at Nabble.com. __

Re: [sqlite] Compiling spellfix for sqlite3

2017-08-23 Thread Keith Medcalf
Excellent! That format is because the program that gets them is written in Python and the "list" format is the native "tuple" output format of Python (for the returned row objects). For example, if in the command line shell you issue this command: SQLite version 3.21.0 2017-08-21 02:20:57 Ent

Re: [sqlite] SQLite Database Crash

2017-08-23 Thread Brice André
Dear Patel, When does your java program crashes ? At start-up when you open the database ? When you perform DB queries ? Which Java library do you use to interface sqlite ? How do you use it ? Do you perform queries that retrieve big quantity of data ? SQLite can be tuned to use more or less me

[sqlite] SQLite Database Crash

2017-08-23 Thread Vihangi Patel
Hello SQLite Team, I am using SQLite database in Linux with 256MB RAM. With Java program, I am trying to connect with database. But that java process is crashed and giving "out of memory" error. I tried same test with 512MB RAM , and its working properly. Can you give me some solution using

Re: [sqlite] Compiling spellfix for sqlite3

2017-08-23 Thread curmudgeon
Keith, I finally managed to use carray this morning. The C++ builder IDE had a facility for entering conditional defines in Project|Options. I had noticed this before asking the question on the c++ builder forum but hadn't realised the -D part of -DSQLITE_EXTRA_INIT=cor_init wasn't required. Thank