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:
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 *
On 23 May 2014, at 1:26pm, Török Edwin edwin+sqli...@etorok.net 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
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
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
-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 of
On Fri, May 23, 2014 at 8:31 PM, Andy Goth andrew.m.g...@gmail.com 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
On Fri, May 23, 2014 at 8:33 PM, Stephan Beal sgb...@googlemail.com 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
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 normal
On Fri, May 23, 2014 at 8:53 PM, Humblebee fantasia.d...@gmail.com 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
On 2014/05/23 20:54, Stephan Beal wrote:
On Fri, May 23, 2014 at 8:53 PM, Humblebee fantasia.d...@gmail.com 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
On 23 May 2014, at 7:53pm, Humblebee fantasia.d...@gmail.com 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
-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:
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]
14 matches
Mail list logo