[sqlite] 100% CPU utilization sqlite running in VMWare

Have a market data extractor running tick tapes and saving data to sqlite db. All coded in C++ and previously ran fine and fast on bare metal. Processes tick tapes from NAS and saved to local sqlite db's on c drive. We moved program onto VMWare VM's... same nas tick tapes. Writing db's to a

Re: [sqlite] Select into outfile C API

On 6/4/2012 3:48 PM, Patrick wrote: Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? No. But in your C program, you can always write code that reads results from SQLite, then writes them to a file in the format of your choice. I see the sqlite3 binary has an

Re: [sqlite] Select into outfile C API

On 4 Jun 2012, at 8:48pm, Patrick wrote: > Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? > I see the sqlite3 binary has an interactive .output parameter. Anything > similar in the C API? Nope. Sorry. You have to write your own C code

[sqlite] Select into outfile C API

Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? I see the sqlite3 binary has an interactive .output parameter. Anything similar in the C API? TIA Pat... ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] group_concat() on a JOIN problem

On Mon, Jun 04, 2012 at 09:13:51PM +0200, Gert Van Assche scratched on the wall: > SELECT DISTINCT > group_concat( [TB].[F2],' ') AS [Groep] > FROM [TA] JOIN [TB] ON [TA].[Groep] = [TB].[Groep]; > > I get this as a result: > Groep > 1 2 *3 3* > > but I would like to get > Groep > 1 2 *3* > >

Re: [sqlite] group_concat() on a JOIN problem

> SELECT DISTINCT > group_concat( [TB].[F2],' ')  AS [Groep] > FROM [TA] JOIN [TB] ON [TA].[Groep] = [TB].[Groep]; You probably want to do the following here: SELECT group_concat([F2],' ') AS [Groep] FROM ( SELECT DISTINCT [TB].[F2] AS [F2] FROM [TA] JOIN [TB] ON [TA].[Groep] = [TB].[Groep] );

[sqlite] group_concat() on a JOIN problem

All, I'm sure this is not an SQLite bug, but I hope I can get rid of it: CREATE TABLE "TA"([Groep], F1); CREATE TABLE "TB"([Groep], F2); INSERT INTO [TA]([Groep], [F1]) VALUES('1', 'ABC'); INSERT INTO [TA]([Groep], [F1]) VALUES('2', 'DE'); INSERT INTO [TA]([Groep], [F1]) VALUES('3', 'F');

Re: [sqlite] (no subject)

On 4 Jun 2012, at 6:39pm, Jörgen Hägglund wrote: > What I am trying to accomplish is an update from the source data. If the > entry is already there, just ignore it. Otherwise add the new data. If any unique key (including the primary key) of the existing row and

Re: [sqlite] Trigger, syntax question

Am 04.06.12 19:36, schrieb Igor Tandetnik: > > http://sqlite.org/lang.html > http://sqlite.org/syntaxdiagrams.html > I just found the case expression. I did not know it before. Thank you for pointing me to that direction! Wolfgang ___ sqlite-users

Re: [sqlite] (no subject)

Hi! Thank You for replying Stefanos! Unfortunately, the errors were typos on my part. Sorry about that. As I wrote, everything works fine the first time around. What I am trying to accomplish is an update from the source data. If the entry is already there, just ignore it. Otherwise add the new

Re: [sqlite] Trigger, syntax question

Am 04.06.12 19:31, schrieb Michael Schlenker: > Am 04.06.2012 19:25, schrieb Wolfgang Meiners: >> Am 04.06.12 18:59, schrieb Igor Tandetnik: >>> On 6/4/2012 12:33 PM, Wolfgang Meiners wrote: this trigger does work but i think it is not in accordance with the syntax diagram of TRIGGER on

Re: [sqlite] Trigger, syntax question

On 6/4/2012 1:25 PM, Wolfgang Meiners wrote: Am 04.06.12 18:59, schrieb Igor Tandetnik: On 6/4/2012 12:33 PM, Wolfgang Meiners wrote: this trigger does work but i think it is not in accordance with the syntax diagram of TRIGGER on http://sqlite.com/lang_createtrigger.html Which part do you

Re: [sqlite] Trigger, syntax question

Am 04.06.2012 19:25, schrieb Wolfgang Meiners: > Am 04.06.12 18:59, schrieb Igor Tandetnik: >> On 6/4/2012 12:33 PM, Wolfgang Meiners wrote: >>> this trigger does work but i think it is not in accordance with the >>> syntax diagram of TRIGGER on >>> http://sqlite.com/lang_createtrigger.html >> >>

Re: [sqlite] Trigger, syntax question

Am 04.06.12 18:59, schrieb Igor Tandetnik: > On 6/4/2012 12:33 PM, Wolfgang Meiners wrote: >> this trigger does work but i think it is not in accordance with the >> syntax diagram of TRIGGER on >> http://sqlite.com/lang_createtrigger.html > > Which part do you feel is in violation of the diagram?

Re: [sqlite] Trigger, syntax question

On 6/4/2012 12:33 PM, Wolfgang Meiners wrote: this trigger does work but i think it is not in accordance with the syntax diagram of TRIGGER on http://sqlite.com/lang_createtrigger.html Which part do you feel is in violation of the diagram? -- Igor Tandetnik

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

Hi Simon… project was cancelled… if it get's resurrected, and I still have the problem, I'll get back to you. Thank you for your time… Regards, Rolf On Jun 4, 2012, at 7:29 AM, Simon Slavin wrote: > > On 4 Jun 2012, at 3:24pm, Rolf Marsh wrote: > >> "Could you possibly

[sqlite] Trigger, syntax question

Hi, I have written the following trigger with ideas from stackoverflow: (OSX 10.6.8, SQLite 3.6.12) This is for a book library. If i delete a bookexemplar from the library, this should not be possible if this bookexemplar is on loan, which means ausleihen.rueckgabe IS NULL. Otherwise every

Re: [sqlite] The "sessions" branch

On Mon, Jun 4, 2012 at 10:50 AM, Marco Bambini wrote: > I am sorry Dr. Hipp, I am probably doing something wrong, but I just > retried and no sessions code is in-line in the final sqlite3.c file. > > I downloaded: > >

Re: [sqlite] The "sessions" branch

I am sorry Dr. Hipp, I am probably doing something wrong, but I just retried and no sessions code is in-line in the final sqlite3.c file. I downloaded: http://www.sqlite.org/src/zip/SQLite-d07b7b67d1b3bf65.zip?uuid=d07b7b67d1b3bf65cfe8d96d45a7f1d387bea7ce then cd SQLite-d07b7b67d1b3bf65

Re: [sqlite] The "sessions" branch

On Mon, Jun 4, 2012 at 10:34 AM, Marco Bambini wrote: > I just tried to download: > http://www.sqlite.org/src/info/d07b7b67d1 > from the session branch. > > Then: > ./configure; make sqlite3.c > but no session module is included in the amalgamation sqlite3.c file. > All of the

Re: [sqlite] The "sessions" branch

I just tried to download: http://www.sqlite.org/src/info/d07b7b67d1 from the session branch. Then: ./configure; make sqlite3.c but no session module is included in the amalgamation sqlite3.c file. >From the executed cp command: cp -f ./src/alter.c ./src/analyze.c ./src/attach.c ./src/auth.c

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

On 4 Jun 2012, at 3:24pm, Rolf Marsh wrote: > "Could you possibly reduce your database to just a few records -- just enough > that it correctly reproduces your problem ? You can use the SQLite shell > tool to .dump the database which will let you post a complete copy for

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

Simon… did you get my response to your last question? "Could you possibly reduce your database to just a few records -- just enough that it correctly reproduces your problem ? You can use the SQLite shell tool to .dump the database which will let you post a complete copy for our testing. "

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

On 4 Jun 2012, at 6:14am, YAN HONG YE wrote: > I have a sqlite db file in my pc, and now I wanna to copy my db file to my > ipad. The format of SQLite databases is identical on every platform. You can make a database on one platform and read it on another. > I need