Re: [sqlite] Report misprint in Documentation

Klaas Van B. wrote: " Indeed, in the page you refer to is missing the operator "<>" documented here: " "

Re: [sqlite] Clarification on "No Isolation On Same Db Connection"

Igor wrote: " On 9/8/2016 1:15 PM, Stephan Mueller wrote: " > " > I'd prefer to commit after each update " > " You can't commit on a single connection either, while there's an " > " unfinalized SELECT statement traversal going on. So you aren't gainin

Re: [sqlite] Clarification on "No Isolation On Same Db Connection"

connection 2 *AND* the Repeatable Read isolation level is ended by committing connection 1 (thus allowing you to see changes made to the database). > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Stephan Mueller

Re: [sqlite] Clarification on "No Isolation On Same Db Connection"

gor Tandetnik <i...@tandetnik.org> wrote: > On 9/7/2016 6:11 PM, Stephan Mueller wrote: > >> I understand that a way to ensure "SELECT is unperturbed" semantics is to >> use separate connections for SELECT and updates. >> > > If you go d

Re: [sqlite] Clarification on "No Isolation On Same Db Connection"

Igor wrote: " On 9/7/2016 6:11 PM, Stephan Mueller wrote: " > I understand that a way to ensure "SELECT is unperturbed" semantics is to " > use separate connections for SELECT and updates. " If you go down that route, make sure you are using WAL journaling mode

Re: [sqlite] Clarification on "No Isolation On Same Db Connection"

on "No Isolation On Same Db Connection" Please reply if you sent this. Thanks. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Stephan Mueller Sent: Wednesday, September 7, 2016 6:12 PM To: sqlite-users@mailinglists.sqlite.o

[sqlite] Clarification on "No Isolation On Same Db Connection"

Hello all; I have a scenario that is well covered by the text at https://www.sqlite.org/isolation.html in the section "No Isolation Between Operations On The Same Database Connection" (relevant paragraphs at end for convenience) but am hoping for a bit more clarity. Here's an overview of my

Re: [sqlite] Bug in CREATE INDEX

Kevin asks: " Does anybody know where the actual defaults and controlling environment " variables are documented, by operating system? Or are they? I believe Section 5.0. near the end of https://www.sqlite.org/tempfiles.html describes what you're looking for. thanks, stephan();

[sqlite] Creating a stable database

> On 9/25/15, Aaron Digulla wrote: >> >> I was wondering if it was possible to create the same database (= no binary >> difference) twice with sqlite. I trust the output of sqldiff, usually with the --primarykey option, to tell me two dbs are equivalent (subject to the caveats listed in