[sqlite] Sqlite and we7 local time issue

you just need to define SQLITE_MSVC_LOCALTIME_API. But i think it should do this automatically if defined(_WIN32_WCE) && _WIN32_WCE >= 0x800 Regards, Gunnar Roth

[sqlite] whish list for 2016

ode is bad, but I do use it on the command line client now and then. Regarding views, I don't know how sqlite handles them but I know that they can drastically slow down queries in MySQL for example. gr., Gunnar On 01/05/2016 03:56 PM, Scott Hess wrote: > Maybe one option would be to add a la

[sqlite] whish list for 2016

col_name1 [_AFTER_ col_name2 | FIRST] Gr., Gunnar On 12/24/2015 05:14 PM, Simon Slavin wrote: > On 24 Dec 2015, at 3:12pm, John McKown > wrote: > >> ?I'm curious as to why. Doing so would, most likely, require rewriting the >> entire table. If you want a SELECT * to

[sqlite] whish list for 2016

I would like a less limited 'alter table' statement, to be able to drop columns and to add columns at a position of my own choice instead of always at the end.

[sqlite] Database corrupt after hard reboot. Can it be repaired?

a bit more sophisticated interface. On 10/22/2015 03:29 PM, Simon Slavin wrote: > On 22 Oct 2015, at 11:16am, gunnar wrote: > >> It's good to know there are so many possibilities to repair when it is >> really needed! > But it's worth noting that these a

[sqlite] Database corrupt after hard reboot. Can it be repaired?

Hi Paul, thanks! It's good to know there are so many possibilities to repair when it is really needed! On 10/19/2015 10:21 PM, Paul Sanderson wrote: > Gunnar > > If the data is very important then don't do anything that will change > the computer. > > If you have somet

[sqlite] Database corrupt after hard reboot. Can it be repaired?

Thanks a lot Simon! We'll try it. (BTW I also got an email from alexa, but looking in the sqlite mailing list I can see that I'm not the only one) On 10/19/2015 06:20 PM, Simon Slavin wrote: > On 19 Oct 2015, at 5:13pm, gunnar wrote: > >> We run sqlite with PRAGMA synchronous=OF

[sqlite] Database corrupt after hard reboot. Can it be repaired?

, Gunnar

[sqlite] Query containing correlated subquery gets "stuck"

Hi Clemens, It works perfect and fast with a covering index!! (I didn't know this concept but after you mentioned it, read about it here: http://www.sqlite.org/queryplanner.html#covidx Perhaps also interesting for others to read about) Thank you very much! Gunnar On 09/29/2015 09:33 AM

[sqlite] Query containing correlated subquery gets "stuck"

No I didn't. I will try it. And thank you very much for your help!! Gunnar Harms T +31 (0)20 53 53 487 F +31 (0)20 42 08 852 I www.hiqinvest.nl HiQ Invest Rembrandt Tower ? 9th floor Amstelplein 1 1096 HA Amsterdam On 09/29/2015 09:33 AM, Clemens Ladisch wrote: > gunnar wrote: >>

[sqlite] Query containing correlated subquery gets "stuck"

Hi, I thought "distinct(column)" is somewhat same as "group by column". I devised the query in steps and forgot to take away the distinct part. thanks, Gunnar On 09/29/2015 09:37 AM, Clemens Ladisch wrote: > gunnar wrote: >> select distinct(server_order

[sqlite] Query containing correlated subquery gets "stuck"

t I am not sure yet, so will keep investigating. Perhaps someone knows a way how I can speed up the original query (I prefer not to make a temp table and make a join after that, although I know that works). Regards, Gunnar On 09/25/2015 05:04 PM, Clemens Ladisch wrote: > gunnar wrote: >&

[sqlite] Query containing correlated subquery gets "stuck"

to try the query tonight in the fifteen minutes that we're not inserting records into the table. Thanks! Gunnar The problematic one: /dev/sdb: ATA device, with non-removable media Model Number: INTEL SSDSC2BB240G4 Serial Number: BTWL342202LD240NGN Firmware Revision

[sqlite] Query containing correlated subquery gets "stuck"

typo: should have been "around 700MB and 500MB" On 09/25/2015 03:58 PM, gunnar wrote: > Hi Clemens, > > Here are some of the settings and the integrity check that we always > prints at start up of our process: > > [query:PRAGMA synchronous=OFF][changes:0][tota

[sqlite] Query containing correlated subquery gets "stuck"

e answered and I should just try it. We'll check the disk for bad sector(s). Thanks for your help! Gunnar On 09/25/2015 03:40 PM, Clemens Ladisch wrote: > gunnar wrote: >> (select uuid from session where date = (select max(date) from session)) > This can be optimized to >

[sqlite] Query containing correlated subquery gets "stuck"

cached On 09/25/2015 01:27 PM, Clemens Ladisch wrote: > gunnar wrote: >> the sqlite client is stuck with the following stack traces > According to these stack traces, the client is not stuck but is > busy searching and reading data from the database. > > What is th

[sqlite] Query containing correlated subquery gets "stuck"

ex6 ON ordercallback (cb_uuid); On the machine where the query gets stuck there is more variation in values for the 'ext_account' column. Could that have to do with it? Regards, Gunnar [hiq at hiqserver2 ~]$ pstack 96660 #0 0x0034f020e530 in __read_nocancel () from /lib64/libpthread.so.0

[sqlite] Query containing correlated subquery gets "stuck"

PM, gunnar wrote: > Tomorrow I'll also try to make a stack trace of sqlite_shell with > pstack at the moment its stuck. > > > > Gunnar Harms > > > HiQ Invest > Rembrandt Tower ? 9th floor > Amstelplein 1 > 1096 HA Amsterdam > > > On 05/27/2015 05:23 PM,

[sqlite] Query containing correlated subquery gets "stuck"

Tomorrow I'll also try to make a stack trace of sqlite_shell with pstack at the moment its stuck. Gunnar Harms HiQ Invest Rembrandt Tower ? 9th floor Amstelplein 1 1096 HA Amsterdam On 05/27/2015 05:23 PM, gunnar wrote: > Hello Simon, > > I'm not 100% sure that I understand what

[sqlite] Query containing correlated subquery gets "stuck"

and each has its own sqlite database with an ordercallback table in which they insert records. With only one of them we have this issue, but that is also the one that inserts much and much more records into its ordercallback table than the others. Regards, Gunnar On 05/27/2015 04:48 PM, Simon

[sqlite] Query containing correlated subquery gets "stuck"

_OK) { fprintf(stderr, "OrderCallbackStorage::%s: SQL error: %s\n[failed query:%s]\n", method, errMsg, query); sqlite3_free(errMsg); return false; } fprintf(stdout, "[query:%s][changes:%d][total changes:%d]\n", query, sqlite3_changes(Mdb), sqlite3_t

[sqlite] Query containing correlated subquery gets "stuck"

WHERE server_order_id=cb.server_order_id AND sessionuuid=cb.sessionuuid AND working=1); Regards, Gunnar

[sqlite] Complex insert query to normalised database

recipe_category_id1, recipe_category_id2, ... recipe_category_id5 fields to recipe_data. And 5 foreign keys. On 02/19/2015 10:08 AM, gunnar wrote: > You should make the relation the other way around. > Remove the foreign key from category and add to recipe_data a field > recipe_ca

[sqlite] Complex insert query to normalised database

FOREIGN KEY(recipe_id) REFERENCES recipe_data(recipe_id) FOREIGN KEY(category_id) REFERENCES category(category_id) something like that. Gunnar On 02/19/2015 09:26 AM, Flakheart wrote: > Here is something I don't understand. From my reading of foreign keys, it > points to the uni

[sqlite] Complex insert query to normalised database

://www.sqlite.org/foreignkeys.html and with the definitions of your foreign keys pay attention to the 'on update cascade ...'and 'on delete cascade ...' gr., Gunnar On 02/18/2015 12:38 PM, Flakheart wrote: > Apologies in advance folks, please forgive the question and the formatting. > &g

[sqlite] Behaviour when subquery behind comparison operator in where-clause returns empty result

Ah indeed! thanks! On 02/18/2015 12:22 PM, Clemens Ladisch wrote: > gunnar wrote: >> The subquery will always return one result or no result. So I only >> have to UNION it ALL with the SELECT NULL part. >>>> Clemens Ladisch wrote: >>>>> ... WHERE cb_s

[sqlite] Behaviour when subquery behind comparison operator in where-clause returns empty result

a performance penalty I can even leave it out since sqlite already treats the empty result of the subquery as NULL as you pointed out) I think my question has been answered! Thanks, Gunnar Gunnar Harms T +31 (0)20 53 53 487 F +31 (0)20 42 08 852 I www.hiqinvest.nl HiQ Invest Rembrandt Tower ? 9th floor

[sqlite] Behaviour when subquery behind comparison operator in where-clause returns empty result

Thanks a lot Clemens! I will use your suggestion and add the 'UNION'. Then I only need to make sure that the comparison "[some number] > NULL" in my WHERE clause always return an empty set. Thanks again! Gunnar Gunnar Harms T +31 (0)20 53 53 487 F +31 (0)20 42 08 852 I www.hiqi

[sqlite] Behaviour when subquery behind comparison operator in where-clause returns empty result

may be undefined and could change in the future. I also searched a lot on this subject on the web, but all that I find is that it is said that the subquery is expected to return exactly one result which gives me the impression that everything else may perhaps be undefined. Thanks, Gunnar

Re: [sqlite] Version compatibility

http://www.sqlite.org/onefile.html Am 23.07.2010 um 11:25 schrieb Andy Chambers: > Hi, > > I've been reading about version compatibility between different > versions of sqlite at the > link below: > > http://www.sqlite.org/formatchng.html > > It states the expected behaviour for old and new

Re: [sqlite] Unicode searches

Keith Stemmer schrieb: > Yes, I can add a custom collation which works for ASCII chars LOL. > Plain wrong > If you don't understand the problem, just don't reply. > > Plain unreasonable carefulle read ( and understand) this http://sqlite.org/c3ref/create_collation.html and this

Re: [sqlite] Version 3.3.15

. Is there a reason why the sqlite3.def and the shell.c file is missing from the zip distribution file? And is there an easy way to get the def file when using msvc? regards, gunnar - To unsubscribe, send email to [EMAIL

Re: [sqlite] Version 3.3.14

influences not only per process concurrency but also thread concurrency. regards, gunnar - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Is there an inverse for .import?

Anderson, James H (IT) schrieb: I need to "export" a table to a file in the same format as used by .import, but I don't see any such cmd. Am I missing something, or does such a cmd just not exist? Maybe its dumb but its called .dump ;-) regar

Re: [sqlite] journal - "Unable to open the database file"

<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sr/sr/monitored_file_extensions.asp> Dr Hipp, Nice to see that i am not the only one you read drh as Dr. H. ;-) in fact his name is D. Richard Hipp. But i have never seen before the habit to abreviate the first surname. Rega

Re: [sqlite] developers mailing list

lemon -DNDEBUG=1 -DHAVE_FDATASYNC=1 -DNOTCL parse.y NOTCL != NO_TCL you see? regards, gunnar - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] lemon issue

> PtCalculatorParser > what't wrong? who can help me? > thanks. > learn about c++ name mangling and about the extern "C" declaration. regards, gunnar - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] so many warnings on vc6 with warning level 4

not doubt, as i have used it for my private project since some years). Is there any chance this warnings will be fixed sometime in the future? How are others dealing with this problem at work? regards, gunnar - To unsubscribe

Re: [sqlite] documentation on the webserver

(or disabled) for each database connection using the sqlite3_extended_result_codes() API. please notice the version 3.3.8 or later statement. regards gunnar

[sqlite] are there known software patents concerning sqlite?

Hello list, as software patents become a more and more important issue ( one could also call it a pain in the *ss) I would like to know if anyone has done a patent research for sqlite. Or does anyone know about people who claimed that sqlite would violate therir patens? kind regards, gunnar

Re: [sqlite] how to unsubscribe this mail list

ou find these headers among others: List-Id: SQLite Users Mailing List List-Post: <mailto:sqlite-users@sqlite.org> List-Help: <mailto:[EMAIL PROTECTED]> List-Unsubscribe: <mailto:[EMAIL PROTECTED]> List-Subscribe: <mailto:[EMAIL PROTECTED]> Most of mailing lists add these headers to each mail. regards, gunnar

Re: [sqlite] Reading a damaged database file?

[EMAIL PROTECTED] schrieb: Gunnar Roth <[EMAIL PROTECTED]> wrote: Well what happens if i write the db to a compact flash card and remove it while writing and put it back again? The database should recover automatically. Actually i have tried that on our ce device

Re: [sqlite] Reading a damaged database file?

or. so on open the journal file had been used. is this right? regards, gunnar

Re: [sqlite] Reading a damaged database file?

quot; you can check if the repair succeeded. regards, gunnar

Re: [sqlite] why I can't find the implementation of functions in IoMethod structure?

.pMethod. regards, gunnar