James K. Lowden wrote:
On Fri, 14 Feb 2014 08:32:02 +0400
Max Vlasov max.vla...@gmail.com wrote:
From: Max Vlasov max.vla...@gmail.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Reply-To: General Discussion of SQLite Database
sqlite-users@sqlite.org Date: Fri, 14 Feb
On 17 Feb 2014, at 7:59am, Max Vlasov max.vla...@gmail.com 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 worries me a
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
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
On Mon, Feb 17, 2014 at 6:37 AM, Tim Streater t...@clothears.org.uk 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
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 t...@djii.com wrote:
On Sat, Feb 15, 2014 at 7:29 AM, tejas parekh cntte...@gmail.com 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.
When
On Mon, Feb 17, 2014 at 2:27 PM, Simon Slavin slav...@bigfraud.org wrote:
On 17 Feb 2014, at 7:59am, Max Vlasov max.vla...@gmail.com wrote:
So the nanosec example modified
Select v-v from
(
Select nanosec() as v from TestTable
)
...shows non-zero values for
On 17 Feb 2014, at 11:37am, Tim Streater t...@clothears.org.uk 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 that
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 ... and
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
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
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 itself?
On Mon, Feb 17, 2014 at 11:47 AM, Stephan Beal sgb...@googlemail.comwrote:
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
On 17 Feb 2014 at 14:10, Simon Slavin slav...@bigfraud.org wrote:
On 17 Feb 2014, at 11:37am, Tim Streater t...@clothears.org.uk 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
On Mon, Feb 17, 2014 at 5:57 PM, Tim Streater t...@clothears.org.uk 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 want to
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
On 17 Feb 2014 at 17:01, Stephan Beal sgb...@googlemail.com 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
the
On 2014/02/17 19:01, Stephan Beal wrote:
On Mon, Feb 17, 2014 at 5:57 PM, Tim Streater t...@clothears.org.uk 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
On Mon, Feb 17, 2014 at 6:23 PM, RSmith rsm...@rsweb.co.za 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 information
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 -
Is there a list of available loadable extensions for functions, virtual
tables, etc?
Pete
lcSQL Software http://www.lcsql.com
Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html and
SQLiteAdmin http://www.lcsql.com/sqliteadmin.html
___
On 17 Feb 2014, at 4:57pm, Tim Streater t...@clothears.org.uk 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 up
On 17 Feb 2014 at 18:38, Simon Slavin slav...@bigfraud.org wrote:
On 17 Feb 2014, at 4:57pm, Tim Streater t...@clothears.org.uk 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
On Mon, Feb 17, 2014 at 7:00 PM, RSmith rsm...@rsweb.co.za 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 functions will be called once
On 17 Feb 2014, at 7:08pm, Tim Streater t...@clothears.org.uk 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
On 17 Feb 2014, at 6:33pm, Peter Haworth p...@lcsql.com 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 contributions,
27 matches
Mail list logo