On Sat, May 17, 2014 at 9:41 PM, Scott Robison wrote:
> On May 17, 2014 8:40 PM, "Simon Slavin" wrote:
> > Just want to check: this is what it sounds like, right ? Your user has
> a window open where they are scrolling through the table, ordered by
> SomeColumn. You need to know whether the win
I had the misconception that a View contains stored data - come to
think of it, it would not be practical if the result set was really
large.
Thank you everyone for giving me a better understanding of what a view
really is about.
Cheers.
On 5/24/14, Simon Slavin-3 [via SQLite]
wrote:
>
>
>
> On
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 23/05/14 05:26, Török Edwin wrote:
> Would it be possible to show a message when someone creates a useless
> index
There was a ticket from two years requesting a "lint" mode to catch
various issues that keep cropping up over the years:
http://ww
On 23 May 2014, at 7:53pm, Humblebee wrote:
> I have a question: "so every time you run a query against a view,
> that view's query is run/updated if not cached ".
>
> Does this mean that if the View is Temporary, then it's not cached?
> and for normal views, it's cached?
The data associated
On 2014/05/23 20:54, Stephan Beal wrote:
On Fri, May 23, 2014 at 8:53 PM, Humblebee wrote:
Does this mean that if the View is Temporary, then it's not cached?
and for normal views, it's cached?
No - a TEMP VIEW means the view is automatically destroyed when you close
the db connection, and
On Fri, May 23, 2014 at 8:53 PM, Humblebee wrote:
> Does this mean that if the View is Temporary, then it's not cached?
> and for normal views, it's cached?
>
No - a TEMP VIEW means the view is automatically destroyed when you close
the db connection, and that view is ONLY visible to that specif
Many Thanks Ryan. I'm learning so much in the last 2 days
(Normalization,Grouping,CTEs, Views,..)
I have a question: "so every time you run a query against a view,
that view's query is run/updated if not cached ".
Does this mean that if the View is Temporary, then it's not cached?
and for norma
On Fri, May 23, 2014 at 8:33 PM, Stephan Beal wrote:
> FWIW, you can also use [table] instead of "table".
>
With, apparently, some corner-cases:
sqlite> create table [t] (a,b,c);
sqlite> insert into [t] values(1,2,3);
But...
sqlite> .dump [t]
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT
On Fri, May 23, 2014 at 8:31 PM, Andy Goth wrote:
> CREATE TABLE "table"
(id INTEGER PRIMARY KEY, a, b, c);
>
"table" in the KEY of C won't cause any confusion in the context of music,
will it ;)
> So that's what double quotes means. Single quotes, on the other hand,
> are used to enter stri
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 5/22/2014 5:23 PM, RSmith wrote:
> On 2014/05/22 17:25, Humblebee wrote:
>> I would like to order the grouping of the Persons in a
>> particular order. So the sequence of the result is based on the
>> TeamPersonTable's order field.
>
> First a word
At table creation time, when column types are not declared explicitly, or
are produced by an expression, column affinity defaults to NONE, with the
result that indexes added afterwards often go unused in joins because of a
column affinity mismatch.
Adding casts around the expressions is an effecti
On 2014/05/23 04:48, Humblebee wrote:
CTEs seems like another magic ball. I just read up a little bit about
them. The bag of tricks is getting more colorful.
I would love to use this new feature, sadly the version of Sqlite is 3.7.7.1,
you mentioned views, is this something that I can use for
On 23 May 2014, at 1:26pm, Török Edwin wrote:
> Also it might be nice to show a message (or a warning via SQLITE_CONFIG_LOG)
> when you run 'explain query plan'
> and there are indexes (either manual or implicit), but they were rejected for
> "some reason".
The index that was rejected might b
Hi,
Would it be possible to show a message when someone creates a useless index
such as index 'x' below?
(at least if you have a logger defined via SQLITE_CONFIG_LOG)
sqlite> create table foo(a int, b int);
sqlite> create index x on foo(a,b) where a=0 and b=0;
sqlite> explain query plan select *
Hi Joe,
Could you please tell me the date by which it will be available. We are all
eager to use the same. Also since Microsoft has dropped support to SQLCE,
this is the only option for us to develop DB centric apps. Please assist
--
View this message in context:
http://sqlite.1065341.n5.nabb
15 matches
Mail list logo