Re: [sqlite] date field with default current date

Hi. 2011/4/22 Pavel Ivanov > >> What does "SELECT sqlite_version()" gives you in python with sqlite3 > >> module? > > [(u'3.5.9',)] > > Well, CURRENT_DATE should work then, it was added in 3.1.0. Could you > show us an exact statement you are trying to execute and the exact > text of error you g

Re: [sqlite] date field with default current date

Hi 2011/4/22 Fabio Spadaro > Hi. > > > 2011/4/22 Pavel Ivanov > >> >> What does "SELECT sqlite_version()" gives you in python with sqlite3 >> >> module? >> > [(u'3.5.9',)] >> >> Well, CURRENT_DATE should work then, it was added in 3.1.0. Could you >> show us an exact statement you are trying to

Re: [sqlite] date field with default current date

Hi. 2011/4/22 Fabio Spadaro > Hi > > > 2011/4/22 Fabio Spadaro > >> Hi. >> >> >> 2011/4/22 Pavel Ivanov >> >>> >> What does "SELECT sqlite_version()" gives you in python with sqlite3 >>> >> module? >>> > [(u'3.5.9',)] >>> >>> Well, CURRENT_DATE should work then, it was added in 3.1.0. Could yo

Re: [sqlite] date field with default current date

From: Fabio Spadaro To: General Discussion of SQLite Database Sent: Fri, April 22, 2011 12:46:53 PM Subject: Re: [sqlite] date field with default current date >In my system is set up with 11:35:07 while I am in the data 9:37:30 >Why? What is the difference

Re: [sqlite] What stack size is required for SQLite to spin?

Aha great. Is 12KB the amount of stack space needed on any x64 platform upon unlimited use (i.e. whatever size and complexity of SQL queries, whatever dataset/DB size etc.) with the default configuration/installation? If not, is there any particular stack size that you would consider a 'safe' thr

Re: [sqlite] What stack size is required for SQLite to spin?

On Fri, Apr 22, 2011 at 8:17 AM, Mikael wrote: > Aha great. > > Is 12KB the amount of stack space needed on any x64 platform upon unlimited > use (i.e. whatever size and complexity of SQL queries, whatever dataset/DB > size etc.) with the default configuration/installation? > > If not, is there a

Re: [sqlite] What stack size is required for SQLite to spin?

Dear Richard, If by recursion you mean a subselect or alike, then the SQL queries we have are of a constant recursion level, generally 0 and 4 or so at max, in any dynamically generated query. Also the depth counted in parentheses of WHERE expressions is constant, 5 or so at max. What varies in t

Re: [sqlite] What stack size is required for SQLite to spin?

On Fri, Apr 22, 2011 at 9:05 AM, Mikael wrote: > Dear Richard, > > If by recursion you mean a subselect or alike, then the SQL queries we have > are of a constant recursion level, generally 0 and 4 or so at max, in any > dynamically generated query. Also the depth counted in parentheses of WHERE

Re: [sqlite] What stack size is required for SQLite to spin?

2011/4/22 Richard Hipp > I do not believe any of these things have any impact on stack depth. But > you should probably double-check by running the experiment. Ok. > Please let us > know if you find me wrong. Yes. Thank you a lot! Kind regards and happy holidays, Mikael > On Fri, Apr 22

Re: [sqlite] date field with default current date

> In my system is set up with 11:35:07 while I am in the data 9:37:30 > Why? http://www.sqlite.org/lang_createtable.html "If the default value of a column is CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP, then the value used in the new row is a text representation of the current UTC date and/or

[sqlite] Sqlite3 Delete using sqlite3_step is very slow.

Hello. I am using Sqlite3 in my applicaiton. I have a simple table: CREATE TABLE doc_cat_link ( id INTEGER PRIMARY KEY, doc_id INTEGER, cat_id INTEGER, [ACTION] TEXTDEFAULT '', is_dirty INTEGER ); the problem is it only has 10 rows, but each time I delete a row usi

Re: [sqlite] Sqlite3 Delete using sqlite3_step is very slow.

On 4/22/2011 10:32 AM, Scott Zhang wrote: > Hello. > I am using Sqlite3 in my applicaiton. I have a simple table: > > CREATE TABLE doc_cat_link ( > id INTEGER PRIMARY KEY, > doc_id INTEGER, > cat_id INTEGER, > [ACTION] TEXTDEFAULT '', > is_dirty INTEGER > ); >

Re: [sqlite] Sqlite3 Delete using sqlite3_step is very slow.

Hello. Thanks for replying. Actually I suddenly realize there is a command "vacuum". After run vacuum on my db, now the sqlite3_step only took 1ms. It is super fast now. I think I should set auto vacuum on. I think wxLogMessageBox doesn't affect the performance actually. Regards. Scott On 4

[sqlite] how to reuse a prepaired statement

I am implementing a dataset update process.  There is a for loop going through the dataset either doing an update on the row or deleting the row.  So there are two statements that are preparied, currently I am using the same basic logic for both. The problem is the second time around I get a SQLIT

Re: [sqlite] how to reuse a prepared statement

Quoth Sam Carleton , on 2011-04-22 23:36:04 -0400: > I am implementing a dataset update process.  There is a for loop going > through the dataset either doing an update on the row or deleting the > row.  So there are two statements that are preparied, currently I am > using the same basic logic for