Re: [sqlite] Loadable extensions

2014-02-17 Thread Simon Slavin
On 17 Feb 2014, at 6:33pm, Peter Haworth wrote: > Is there a list of available loadable extensions for functions, virtual > tables, etc? I've seen some extensions lists on the web but none of them struck me as worth bookmarking. The SQLite site includes a page of

Re: [sqlite] Text column: never used vs. set to empty string

2014-02-17 Thread Simon Slavin
On 17 Feb 2014, at 7:08pm, Tim Streater wrote: > Yes. I'm concluding that there's something fishy with the way my > data-gathering page is operating. I've recently added "use strict"; to my > javascript and that may be exposing something. My web apps involve a hand-off

Re: [sqlite] Once again about random values appearance

2014-02-17 Thread Max Vlasov
On Mon, Feb 17, 2014 at 7:00 PM, RSmith wrote: > > > On 2014/02/17 09:59, Max Vlasov wrote: >> >> . >> So >> >>Select nanosec() - nanosec() from ... >> >> returns non-zero values for most of the times, so there's no guarantee the >> user functions or any other

Re: [sqlite] Text column: never used vs. set to empty string

2014-02-17 Thread Tim Streater
On 17 Feb 2014 at 18:38, Simon Slavin wrote: > On 17 Feb 2014, at 4:57pm, Tim Streater wrote: > >> Thanks. I should perhaps have made it clearer that I'm looking at an issue a >> user has. The application gathers some data from the user via a set of

Re: [sqlite] Text column: never used vs. set to empty string

2014-02-17 Thread Simon Slavin
On 17 Feb 2014, at 4:57pm, Tim Streater wrote: > Thanks. I should perhaps have made it clearer that I'm looking at an issue a > user has. The application gathers some data from the user via a set of fields > they complete in a browser window, which data is then gathered

[sqlite] Loadable extensions

2014-02-17 Thread Peter Haworth
Is there a list of available loadable extensions for functions, virtual tables, etc? Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin ___

Re: [sqlite] Text column: never used vs. set to empty string

2014-02-17 Thread RSmith
Forgot to add: My headache was essentially UTF-8 encoding, but the same would happen with others, though invalid chars do not really exist in UTF7 or ANSI, but in the higher level encodings they are plentiful. On 2014/02/17 19:35, RSmith wrote: Yeah, I too have had real problems with this -

Re: [sqlite] Question regarding guarantees of SQLITE_DETERMINISTIC

2014-02-17 Thread Stephan Beal
On Mon, Feb 17, 2014 at 6:23 PM, RSmith wrote: > The flag is telling SQLite that your function will behave > determinsitcally, i.e. it won't change the output for the same inputs > within a single query. > i figured so, just wanted to be sure. > SQLite then uses this

Re: [sqlite] Text column: never used vs. set to empty string

2014-02-17 Thread RSmith
On 2014/02/17 19:01, Stephan Beal wrote: On Mon, Feb 17, 2014 at 5:57 PM, Tim Streater wrote: complete in a browser window, which data is then gathered up and sent using ajax to be processed by a PHP script, which writes it to an sqlite db. The user complains that some

Re: [sqlite] Text column: never used vs. set to empty string

2014-02-17 Thread Tim Streater
On 17 Feb 2014 at 17:01, Stephan Beal wrote: > FWIW, i have seen a similar problem in a legacy app which uses latin1 > encoding in the DB. Latin1 doesn't always survive round-trip through PHP's > JSON APIs. My case was similar to yours, and we eventually determined that >

Re: [sqlite] Question regarding guarantees of SQLITE_DETERMINISTIC

2014-02-17 Thread RSmith
On 2014/02/17 18:47, Stephan Beal wrote: Hi, all, Regarding SQLITE_DETERMINISTIC: http://www.sqlite.org/c3ref/create_function.html does specifying that flag guaranty that sqlite3 will only call my "deterministic" function one time during any given SQL statement, or must my function actually

Re: [sqlite] Text column: never used vs. set to empty string

2014-02-17 Thread Stephan Beal
On Mon, Feb 17, 2014 at 5:57 PM, Tim Streater wrote: > complete in a browser window, which data is then gathered up and sent > using ajax to be processed by a PHP script, which writes it to an sqlite > db. The user complains that some of this data doesn't make it, so I

Re: [sqlite] Text column: never used vs. set to empty string

2014-02-17 Thread Tim Streater
On 17 Feb 2014 at 14:10, Simon Slavin wrote: > On 17 Feb 2014, at 11:37am, Tim Streater wrote: > >> If I have a text column defined as it might be as MYCOL TEXT (that is with no >> default value), is there a way to distinguish in some row or other

Re: [sqlite] Question regarding guarantees of SQLITE_DETERMINISTIC

2014-02-17 Thread Richard Hipp
On Mon, Feb 17, 2014 at 11:47 AM, Stephan Beal wrote: > Hi, all, > > Regarding SQLITE_DETERMINISTIC: > > http://www.sqlite.org/c3ref/create_function.html > > does specifying that flag guaranty that sqlite3 will only call my > "deterministic" function one time during any

[sqlite] Question regarding guarantees of SQLITE_DETERMINISTIC

2014-02-17 Thread Stephan Beal
Hi, all, Regarding SQLITE_DETERMINISTIC: http://www.sqlite.org/c3ref/create_function.html does specifying that flag guaranty that sqlite3 will only call my "deterministic" function one time during any given SQL statement, or must my function actually guaranty that deterministic behaviour

Re: [sqlite] Once again about random values appearance

2014-02-17 Thread RSmith
On 2014/02/17 09:59, Max Vlasov wrote: Ok, I hope I found the topic, the title was "racing with date('now') (was: Select with dates): one of the links to the archive https://www.mail-archive.com/sqlite-users@sqlite.org/msg79456.html CMIIW, but as I see it, the final modification was

Re: [sqlite] Windows service with SQLITE

2014-02-17 Thread Teg
Hello tejas, You're using windows so, you should be using "Procmon" to watch file IO. You need to add and look at logging. This is sort of trouble-shooting 101. If you can't get the debugger on it, you'll have to debug with logging. I'd generate a log file and log everything to do with

Re: [sqlite] Text column: never used vs. set to empty string

2014-02-17 Thread Clemens Ladisch
Tim Streater wrote: > If I have a text column defined as it might be as MYCOL TEXT (that is > with no default value) All columns have a default value. With no _explicitly_ specified default value, the column's default value is NULL. > is there a way to distinguish ... between ... no data ...

Re: [sqlite] Text column: never used vs. set to empty string

2014-02-17 Thread Simon Slavin
On 17 Feb 2014, at 11:37am, Tim Streater wrote: > If I have a text column defined as it might be as MYCOL TEXT (that is with no > default value), is there a way to distinguish in some row or other between a > column into which no data has ever been entered, and a column

Re: [sqlite] Once again about random values appearance

2014-02-17 Thread Max Vlasov
On Mon, Feb 17, 2014 at 2:27 PM, Simon Slavin wrote: > > On 17 Feb 2014, at 7:59am, Max Vlasov wrote: > > > So the nanosec example modified > > > > Select v-v from > > ( > > Select nanosec() as v from TestTable > > ) > > > > ...shows

Re: [sqlite] Windows service with SQLITE

2014-02-17 Thread Richard Hipp
On Sat, Feb 15, 2014 at 7:29 AM, tejas parekh wrote: > Hi All, > > We have a small issue with sqlite database. > > Program structure: > one windows service calls two windows processes process-1 and process-2. > both processes use common database db1.s3db file to store data. >

Re: [sqlite] Windows service with SQLITE

2014-02-17 Thread tejas parekh
Hi Teg, I tried putting delay of 3 seconds and 30 seconds but nothing happens. Still not able to access database and store anything. When i create a file to store data it stores. Strange.. Need more views please. Thanks, Tejas On Sun, Feb 16, 2014 at 12:35 AM, Teg

Re: [sqlite] Text column: never used vs. set to empty string

2014-02-17 Thread Donald Griggs
On Mon, Feb 17, 2014 at 6:37 AM, Tim Streater wrote: > If I have a text column defined as it might be as MYCOL TEXT (that is with > no default value), is there a way to distinguish in some row or other > between a column into which no data has ever been entered, and a

[sqlite] Text column: never used vs. set to empty string

2014-02-17 Thread Tim Streater
If I have a text column defined as it might be as MYCOL TEXT (that is with no default value), is there a way to distinguish in some row or other between a column into which no data has ever been entered, and a column that might have been set to a string, but later set to the empty string? (or

[sqlite] Explain Query Plan with virtual tables involved

2014-02-17 Thread Dominique Devienne
Would it be possible to have plans for virtual tables more in line with plans for regular tables? With virtual tables, the plan is always a SCAN TABLE, while for regular tables it's either a SCAN TABLE for full scans, and a SEARCH TABLE for an indexed plan. Because I don't yet use idxStr but

Re: [sqlite] Once again about random values appearance

2014-02-17 Thread Simon Slavin
On 17 Feb 2014, at 7:59am, Max Vlasov wrote: > So the nanosec example modified > > Select v-v from > ( > Select nanosec() as v from TestTable > ) > > ...shows non-zero values for the current (3.8.3) and for older (3.6.10) > version. Erm ... that

Re: [sqlite] Once again about random values appearance

2014-02-17 Thread Yuriy Kaminskiy
James K. Lowden wrote: > On Fri, 14 Feb 2014 08:32:02 +0400 > Max Vlasov wrote: > >> From: Max Vlasov >> To: General Discussion of SQLite Database >> Reply-To: General Discussion of SQLite Database >>