> All true. But why start with this scenario?
While trying to explain operational aspects of SQLite’s isolation
implementations, serial execution seemed like the easiest to start with.
Figured it might be easy to grasp first, before looking at interleaved
operations followed by complications
On Fri, 25 Jan 2019 at 13:21, Rahul Jayaraman
wrote:
> > 1. "In the above case, since all transactions are started with
> IMMEDIATE,” -- the diagram is actually using EXCLUSIVE transactions not
> IMMEDIATE
> > 2. "they behave as writers, and concurrent transactions are blocked" —
> this implies
> 1. "In the above case, since all transactions are started with IMMEDIATE,” --
> the diagram is actually using EXCLUSIVE transactions not IMMEDIATE
> 2. "they behave as writers, and concurrent transactions are blocked" — this
> implies to me that all transactions are blocked, and conflicts with
On Tue, 22 Jan 2019 at 17:24, Rahul Jayaraman
wrote:
> From an operational perspective, which describes algorithms used and
> implementation details. I think it’s useful to understand algorithms
> because different algorithms give rise to different `busy` scenarios, and
> having a better mental
The sensible permissions in this case would probably be rw-rw-r-- with the
same group as the service and owned by the service group. That is how group
permissions were designed to work.
>
>
___
sqlite-users mailing list
https://github.com/mackyle/sqlite/compare/master...d3x0r:TableAliasColumnInfo#diff-ba6bba0411f943cb54c02ee6f03e9a72R1666
Someone at smoe point mentioned "I know know... that's like grabbing memory
from some place untraced right and "
All the other META INFO comes from the same thing.
pTab =
Is there a rough idea of when 3.27 might be released?
We’d like to incorporate the fix for "Incorrect results for OR query where both
OR terms are different indexed expressions”* into the next release of Couchbase
Lite, but we’re uncomfortable with using an interim unblessed build of SQLite.
Thanks for the hint about pragma QUERY_ONLY, that might work but we will
have to rethink the database file management. The database is currently
owned by root and has sensible unix permissions of rw, r, r (ie only root
has write permission)
We can't run the intended service as root because that
Hi,
I see, thanks for the explanation.
I still don't understand how the whole skip-scan optimization works though.
My use-case involves a table pretty much like this one:
CREATE TABLE `rolling` (
`source1`TEXT NOT NULL,
`source2`TEXT NOT NULL,
`ts`INTEGER NOT NULL,
Thanks Richard.
From: sqlite-users on behalf of
Richard Hipp
Sent: Thursday, January 24, 2019 3:09:33 PM
To: SQLite mailing list
Subject: Re: [sqlite] pragma database_list
On 1/24/19, x wrote:
> Forgetting the temp db, Is the list guaranteed to be in the
The pkgIndex.tcl which is generated when using
--enable-tcl contains an absolute path to the shared library.
That is not portable.
It's better to use the $dir variable, which is automatically
created by the package loading process, to locate the
library file, e.g. change lines 1419-1420 in
On 1/24/19 4:17 AM, Peter da Silva wrote:
Sounds like something is using fork when it should be using vfork?
No idea. My only concern is getting the sources to build clean and then
to pass the testsuite. Which it doesn't due to one single itty bitty test.
So how does one run a single test
On 1/24/19, Gerlando Falauto wrote:
> What is the purpose of ANALYZE sqlite_master; ?
Causes the content of sqlite_stat1 to be reloaded into the query
planner after making out-of-band changes using UPDATE.
--
D. Richard Hipp
d...@sqlite.org
___
Thank you!
There's one thing I don't understand though:
What is the purpose of ANALYZE sqlite_master; ?
Thank you!
Gerlando
On Thu, Jan 24, 2019 at 4:07 PM Richard Hipp wrote:
> On 1/24/19, Gerlando Falauto wrote:
> > Hi,
> >
> > I read about the skip-scan optimization:
> >
> >
On 1/24/19, x wrote:
> Forgetting the temp db, Is the list guaranteed to be in the same order the
> databases were attached in?
No
There might not be a counter example in the current implementation,
but that could change at any moment.
--
D. Richard Hipp
d...@sqlite.org
On 1/24/19, Gerlando Falauto wrote:
> Hi,
>
> I read about the skip-scan optimization:
>
> https://www.sqlite.org/optoverview.html#skipscan
>
> is there a way to check whether it is being used for a given query, or not?
>
> Explain query plan does not seem to give any insight...
In the output
Forgetting the temp db, Is the list guaranteed to be in the same order the
databases were attached in?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Hi,
I read about the skip-scan optimization:
https://www.sqlite.org/optoverview.html#skipscan
is there a way to check whether it is being used for a given query, or not?
Explain query plan does not seem to give any insight...
I tried both before and after running ANALYZE; / DROP TABLE
Am Mi., 23. Jan. 2019 um 18:23 Uhr schrieb Jens Alfke :
>
>
> > On Jan 23, 2019, at 8:27 AM, Carsten Müncheberg <
> carsten.muencheb...@gmail.com> wrote:
> >
> > A host application (which is a black box for me I cannot change) is
> loading
> > my plugin binaries which each have SQLite linked
Sounds like something is using fork when it should be using vfork?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
20 matches
Mail list logo
