On Monday, 11 March, 2019 09:42, heribert wrote:
>it works perfect - but i do not understand why.
See https://sqlite.org/lang_with.html for a description of recursive queries ...
>The 'inital-select' results with the head node - only one result set.
>SELECT *
> FROM Tree
> WHERE ParentID
These docs:
https://sqlite.org/c3ref/expanded_sql.html
The sqlite3_sql and sqlite3_expanded_sql are always be available.
The sqlite3_normalized_sql interface is only available if the
SQLITE_ENABLE_NORMALIZE compile option is used.
---
The fact that there's a Highway to Hell but only a Stair
The current tip of trunk produced the same results demonstrated by Niklas in
his original post for his original testcase for me.
I would have written the query as a simple query with correlated subqueries to
get the concatenated data as it is a "more natural" declaration of what is
wanted (in
Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf
>Sent: Friday, 15 March, 2019 14:44
>To: SQLite mailing list
>Subject: Re: [sqlite] Query planner: Scanning subqueries vs using
>automatic covering index
>
On Sunday, 17 March, 2019 12:30, Yannick Duchêne
wrote:
>Hi people, it’s a long time I did not get there.
>I’m currently to create and use an SQLite DB with the Python biding
>APSW. For each row returned, I always retrieve the description with
>`Cursor.getdescription()`. Surprisingly, during a
On Sunday, 17 March, 2019 15:00, Yannick Duchêne
wrote:
>Aside, what also surprised me just a moment ago and I never
>noticed before, is that although I can refer to ROWID (not aliased)
>anywhere in a query, it seems to not work properly in `using(rowid)`, if
>the ROWID is automatically generat
On Sunday, 17 March, 2019 11:19, niklas wrote:
>I agree that correlated subqueries in general seem more natural and
>are probably also less likely to have the performance pessimizations
>noticed with joins.
>But I might also want to use the column, or in case of a correlated
>subquery, the colu
The trigger program will have update anomalies (violation of the UNIQUE
constraint for example) as well as performance issues unless the data in the
tree is tiny (since it must visit every row in the tree even if it is not being
updated). This will fix those issues (and also requires a "gentle
SQLITE_LOCKED is an immediate return (that is, it returns immediately, it is
not subject to automatic retries or timeouts or the busy/wait handler -- it is
an error indication, not necessarily a transient condition).
You may use the sqlite3_unlock_notify API (assuming that you have compiled y
See also:
https://sqlite.org/unlock_notify.html
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On B
I use .db cuz it is a database. You are free to call your files whatever you
please (as is everyone else). You would have to take a very wide poll of the
millions of users of SQLite3 to discover all the file extensions they use,
since a name is just a name and nothing more than a name and has
https://sqlite.org/walformat.html
The -shm file contains information about in process transactions that are
blocking the checkpoint, but not the processes that are holding them.
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volum
On Wednesday, 27 March, 2019 07:18, Lloyd wrote:
>I wish to build SQLite as a dll in Windows. As per the documentation
>here
>https://www.sqlite.org/howtocompile.html, I have executed the command
>cl sqlite3.c -link -dll -out:sqlite3.dll
>on Visual Studio x86 command prompt.
>It seems that the
On Wednesday, 27 March, 2019 12:04, Thomas Kurz wrote:
>> I wonder whether SQLite is treating each DELETE as a single
>transaction. Could you try wrapping the main delete in BEGIN ... END
>and see whether that speeds up the cascaded DELETE ? Would you be
>able to find timings (either in your c
You mean something like this:
SELECT staff.* FROM staff, contributions
WHERE contributions.staff = staff.email
AND contributions.article IN (SELECT id FROM articles
WHERE publish_date <= CURRENT_TIMESTAMP
ORDER BY publish_date DESC LIMIT ?);
---
The fact that there's a Highway to Hell but only a
On Thursday, 28 March, 2019 13:21, Mark Wagner wrote:
>Imagine I have these two tables and one view defining a join.
>CREATE TABLE t (foo);
>CREATE TABLE s (bar);
>CREATE VIEW v as select * from t join s on (foo = q);
>I appear to be able to do this query:
>select 20 as q, * from t join s on (
On Sunday, 31 March, 2019 14:07, Shane Dev wrote:
>Is it possible to create a view which switches rows and columns of a
>dynamically changing table?
>For example, imagine we have table t1 where both columns and rows
>could change after the view has been created
>sqlite> select * from t1;
>Prod
Works fine for me on Centos ... using the default (ancient) version of SQLite3
# sqlite3 /tmp/test.db "CREATE TABLE test (col1); INSERT INTO test VALUES(1);"
# touch /tmp/test.init
# sqlite3 /tmp/test.db "SELECT * FROM test;" 2>/dev/null
1
# sqlite3 -init /tmp/test.init /tmp/test.db "SELECT * FRO
The disassembled bird will always require more tar to coat than the assembled
bird. This is because the disassembled bird will have a greater surface area
to coat with tar than the assembled bird. This is a fact of physics which,
although you may try as you might, you cannot change (unless of
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
On Tuesday, 9 April, 2019 21:17, John McMahon wrote:
>I have not used extensions before. I understand that some are
>included in the amalgamation source file and that some
CREATE UNIQUE INDEX on H1 (...the unique columns...).
Primary key is (except for the INTEGER PRIMARY KEY in a rowid table) and in
WITHOUT ROWID tables where it is the key of the b-tree, just semantic sugar for
a UNIQUE index ...
---
The fact that there's a Highway to Hell but only a Stairway
The first column is of strings ...
Do you mean a single string as in "KerfufledAllaHasbalah"
Or a "bunch of strings with some implied delimiter" such as
"Kerfufled/Alla/Hasballah" where "/" is the separator between strings?
If the latter, the data needs to be normalized.
---
The fact that ther
the second column is of integers ...
Do you mean the second column in AN integer or that it is a bunch-o-integers
separated by some separator?
If the latter, normalization is required.
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traf
On Wednesday, 10 April, 2019 08:12, Peng Yu wrote:
>On 4/10/19, Keith Medcalf wrote:
>> The first column is of strings ...
>> Do you mean a single string as in "KerfufledAllaHasbalah"
>> Or a "bunch of strings with some implied delimiter" such as
&
On Wednesday, 10 April, 2019 08:28, Joshua Thomas Wise
wrote:
>This is not enough. Because of implicit casting, an integer (a
>precise value) could be passed through a series of operations that
>outputs an integer, satisfying the check constraint, but it still
>could’ve been converted to a floa
d require even more extensive testing.
And thinking about how one would want it to work.
>> On Apr 10, 2019, at 10:55 AM, Keith Medcalf
>wrote:
>>
>>
>> On Wednesday, 10 April, 2019 08:28, Joshua Thomas Wise
>mailto:joshuathomasw...@gmail.com>>
>wrote:
>&
It is far cheaper and much more reliable to just buy some file storage space.
Last I looked 4 TB of NVMe is about $1,000.00.
This is not the old days when a 5 1/2 inch full height 40 MEGABYTE drive cost a
bundle. Geez, I remember when I got a bunch of CDC Wren IV 300 MB drives at
the whoppi
On Wednesday, 10 April, 2019 14:21, Peter da Silva wrote:
>On Wed, Apr 10, 2019 at 3:12 PM Keith Medcalf wrote:
>> Why would anyone fart about with added complication and the
>> concomittant increased unreliability when storage is so damn cheap?
>Embedded systems and mo
Actually you would have to convert the strings to UCS-4. UTF-16 is a
variable-length encoding. An actual "unicode character" is (at this present
moment in time, though perhaps not tomorrow) 4 bytes (64-bits).
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lo
On Friday, 12 April, 2019 09:40, Jim Dossey wrote"
This does not really make a lot of sense at all for the following reasons:
>I have a table define like this:
>CREATE TABLE "sessiond" (
>"journal" VARCHAR(4) DEFAULT '' NOT NULL,
>"session" VARCHAR(16) DEFAULT '' NOT NULL,
>"pid" INTEGER DEFA
On Friday, 12 April, 2019 12:36, Richard Hipp wrote:
>Perhaps the SELECT is running inside of a transaction that was
>started
>before you did the INSERT. For example, perhaps you didn't
>sqlite3_finalize() the previous SELECT, which caused it to hold the
>read transaction open.
Is it not sqlit
On Friday, 12 April, 2019 14:48, Jim Dossey wrote:
>On Apr 12, 2019, at 3:27 PM, Keith Medcalf wrote:
>>> To be a little more specific, the problem happens when I try to do
>>> sqlite3_bind_int() on the prepared statement using the new rowid.
>It
>>> d
sqlite3_value_text and sqlite3_value_bytes will cause the conversion (if
required) to UTF-8, and then return the data requested.
sqlite3_value_text16 and sqlite3_value_bytes16 will cause the conversion (if
required) to UTF-16 and then return the data requested.
So if you call sqlite3_value_text
On Monday, 15 April, 2019 13:31, Mohit Mathur wrote:
>I am working on one sqllite query, in which i am doing left outer
>join between two tables and than using intersect and again doing
>left outer join between two other tablescolumns that i am
>selecting are exactly same in number and dat
Your made up plans are intriguing. The plan you show for the latter query omit
to join a and b. Are you just making things up?
sqlite> select a.rowid from a, b where a.ref=7 and a.rowid in (select rowid
from b);
QUERY PLAN
|--SEARCH TABLE a USING COVERING INDEX aa (ref=? AND rowid=?) (~8 rows
Simon,
There are fields (columns) in your invoices table named 1.23 and 7524? Why did
you do this (or did you just use the wrong quotes around text strings?)
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Origina
nticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf
>Sent: Wednesday, 17 April, 2019 12:38
>To: SQLite mailing list
>Subject: Re: [sqlite] Use cases for sqlite3_value_frombind(
Ticket https://www.sqlite.org/src/info/f00d7b65
Fixed on trunk https://www.sqlite.org/src/info/a2ead8aa4517b63c
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-u
On Friday, 19 April, 2019 18:05, Andy Hegedus
wrote:
>Newbie here so please be gentle.
That's OK. Just to let you know this is a little off topic since it is more
discussing the Python pysqlite2 (sqlite3) wrapper than being about SQLite3
iteself -- however -- I will endeavour to answer your
This is somewhat unclear. You make two conflicting statements:
"I have been testing with 16, 32, and 48 threads/databases at once ..."
and
"time it takes for all of the threads to just open all (millions) of the
databases"
So, are you:
(a) opening one independently and uniquely named database
million database files sitting on my
>filesystem. Each thread will open a previously unprocessed database
>file, do some queries, close the database, and move on to the next
>unprocessed database file.
>
>
>Jason Lee
>
>____
>From: sqlite-user
Interesting. If you can guarantee that you will only have a single thread
accessing a single database only from one single thread, give it a try with
SQLITE_OPEN_NOMUTEX | SQLITE_OPEN_READONLY in the flags parameter of
sqlite3_open_v2 ...
Don't know if it will make a difference, but it might.
I will leave aside the use of SHARED_CACHE which massively trades performance
for memory usage (that is, it "totally kills" performance but also "hugely
reduces" memory requirements) -- it trades a huge reduction in performance for
a huge reduction in memory usage and changes some other things
On Sunday, 28 April, 2019 11:23, Lullaby Dayal asked:
To answer your specific questions:
>So my questions are:-
>1. In auto-commit mode in serialized threading mode, how command
>queueing works?
auto-commit and transactions are an attribute of the connection and have
nothing whatsoever to do
On Thursday, 25 April, 2019 19:10, Lullaby Dayal
wrote:
>We use sqlite3 in an embedded automotive system based on QNX
>hypervisor running multiple virtual machines. Software is
>architectured in a service oriented way.
Interestingly, the default "database" service in QNX is (or at least was a
In date.c at line 83:
/*
** Convert zDate into one or more integers according to the conversion
** specifier zFormat.
**
** zFormat[] contains 4 characters for each integer converted, except for
** the last integer which is specified by three characters. The meaning
** of a four-character format
Actually, the affinity is applied first, however --
c0 has affinity "A" (blob) applied.
c1 has affinity "E" (real) applied, but has the "tryForInteger" set which
results in an integer value
the GLOB function converts its arguments to text, so when it is presented with
the "integer" c1 differen
Again, I think this is a problem with applying affinity when the index is
created. The result of applying real affinity to the string '+/' should
probably be the string '+/' not the real value 0. On the gripping hand, '+/'
looks like a number with "crud" at the end of the string. I believe t
On Wednesday, 1 May, 2019 15:56, Tom Bassel wrote:
>In this page in the docs:
>https://sqlite.org/queryplanner.html#searching
>it says:
>"The rows are logically stored in order of increasing rowid"
>Would this imply that executing a SELECT would always return the rows
>in order or increasing r
Use PRAGMA LEGACY_ALTER_TABLE=ON;
The "Legacy alter table" does not require the database to be "valid/consistent"
after executing the "alter table" command. The non-legacy (default) mode
requires that the database be "transformed" into a "valid/consistent" state in
order for the alter table c
The actual value is 5.7646075230342348e+17 or 5.764607523034235e+17 (depending
on compiler, floating point mode, FPU rounding settings, etc.). This is a
common problem with using = with floating point numbers ...
You can find the actual exact value using:
select printf('%!.20e', c1) from t1;
There is, however, something weird:
SQLite version 3.29.0 2019-05-04 17:32:07
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .version
SQLite 3.29.0 2019-05-04 17:32:07
c2e439bccc40825e211bfa9a88e6a251ff
e-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf
>Sent: Saturday, 4 May, 2019 12:09
>To: SQLite mailing list
>Subject: Re: [sqlite] Problem with REAL PRIMARY KEY
>
>
>There is, however, something weird:
>
>SQLite version 3.29.0 2019-05-04 17:32:07
>En
ing list
>Subject: Re: [sqlite] Problem with REAL PRIMARY KEY
>
>Sorry, I should have anticipated that we get slightly different
>values.
>Shouldn't the query "SELECT * FROM t1 WHERE c1 IN (SELECT c1 FROM
>t1);"
>return a result though?
>
>Best,
>Manuel
>
https://sourceforge.net/projects/mingw-w64/files/?source=navbar
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Beh
Assuming "right folder id" is short-hand for "the id of the rightmost folder"
...
with folderpath(id, rightmost_folder_id, parent_id, path, rank)
as (
select id, rightmost_folder_id, parent_id, name, rank
from folders
union all
select f.id, rightmost_folder_id, f.par
Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf
>Sent: Monday, 13 May, 2019 19:46
>To: SQLite mailing list
>Subject:
On Tuesday, 21 May, 2019 07:55, Richard Hipp wrote:
>On 5/21/19, Patrick Sherrill wrote:
>> I don’t know about ‘valid’ csv, it has been a moving target for
>>decades.
>> White space as far as my recollection should not be considered in
>>parsing a csv.
>I'm going by RFC 4180. https://tools.i
On Wednesday, 22 May, 2019 11:51, sky5w...@gmail.com wrote:
>Please add a note to the omitted page that many basic math functions
>are NOT supported. (sqrt,mod,power,stdev,etc.)
Traditionally "math library" functions provided by the various language
runtimes were not included becase this would
On Wednesday, 22 May, 2019 19:06, Simon Slavin wrote:
>Since there are people posting who appear know about these things …
>Suppose I want SQlite to handle my own type. Or to do its best to
>simulate that. IP address, x/y location, something like that. What
>should I be doing ? Do I store B
On Wednesday, 22 May, 2019 16:56, James K. Lowden
wrote:
>On Wed, 22 May 2019 14:20:11 -0600
>"Keith Medcalf" wrote:
>> (such as was added to DB2 back in the late 80's early 90's, and
>> which I do not think anyone else has implemented as nicely any
t;some kind of a "check function" so that one could write
>
>SELECT CASE WHEN defined('stddev') THEN stddev(foo) ELSE NULL END
>FROM bar
>
>
>- Original Message -
>From: Keith Medcalf
>To: SQLite mailing list
>Sent: Wednesday, May 22, 2019, 22
27;) THEN stddev(foo) ELSE NULL END
>FROM bar
>
>
>- Original Message -
>From: Keith Medcalf
>To: SQLite mailing list
>Sent: Wednesday, May 22, 2019, 22:20:11
>Subject: [sqlite] SQL Features That SQLite Does Not Implement
>
>
>On Wednesday, 22 May, 2019 11:51,
ut it is still very unconvenient. How
>can I define a view based on your suggestion? I want to have
>something like
>
>CREATE VIEW foo AS SELECT {if has stddev then stddev(...) else null}
>FROM ...
>
>- Original Message -
>From: Keith Medcalf
>To: SQLite mailing list
>
On Thursday, 23 May, 2019 02:08, Dominique Devienne wrote:
>On Thu, May 23, 2019 at 7:39 AM Keith Medcalf
>wrote:
>> You can check if what you need is available on a connection and
>either load it if needed or just abort:
>> sqlite> select * from pragma_function_lis
On Thursday, 23 May, 2019 08:35, Dominique Devienne wrote:
>On Thu, May 23, 2019 at 3:50 PM Jose Isaias Cabrera
> wrote:
>
>> I have been working network for a long time, and I have never seen
>> any application that takes "zeroed left-filled" IP addresses. Just
>> sharing...
>> Thanks.
> Works
On Thursday, 23 May, 2019 14:39, Jens Alfke wrote:
>> On May 22, 2019, at 8:16 PM, Keith Medcalf
>wrote:
>> Basically, User Defined Types (UDT) were implemented in a fashion
>analgous to a C++ class (remember that at this time C++ was just a
>pre-processor for C and a
sqlite> select roundhe(3.255, 2);
3.26
sqlite> select printf('%!.18f', 3.255);
3.254893
sqlite> select printf('%!.18f', roundhe(3.255, 2));
3.259787
sqlite> select printf('%!.18f', pow(10.0, 2));
100.0
sqlite> select printf('%!.18f', pow(10.0, 2) * 3.255);
325.5
The good:
https://sqlite.org/c3ref/deserialize.html
https://sqlite.org/c3ref/serialize.html
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sq
D:\Source\SQLite3 contains the fossil checkout of trunk
D:\Source\Bld is an empty directory
D:\Source\Bld>nmake -f ..\sqlite3\makefile.msc sqlite3.c TOP=..\sqlite3
... for the rest of the targets you want
In other words, you point to the makefile.msc wherever it may be found, and set
TOP= t
>Why does the "=" query fail and the "like" query work? There are no
>wildcards involved.
>The behavior is the same in Sqlite command line. There are no
>wildcards involved.
sqlite> create table songfiletable (
...> songfile_id integer primary key,
...> dancename text
...> );
sqlite> in
This is an update to the Schema Information views that I previously posted.
This version has the capability to display information for all available schema
names (attached databases) simultaneously. It requires that the SQL function
"eval" be available since it runs dynamically generated SQL
Improved version that does not execute the eval multiple times. I have not
renamed the columns match the ANSI INFORMATION_SCHEMA views, though I suppose
that might be possible (though I find that schema yucky -- it embodies the
thinking from decades ago where one would embed table names into c
On Sunday, 9 June, 2019 05:20, Manuel Rigger wrote:
>Consider the following example:
>CREATE TABLE t0(c0 TEXT);
>INSERT INTO t0(c0) VALUES (x'41'); -- 'A' if converted to TEXT
>SELECT (+ c0) IS c0 FROM t0; -- expected: 0, actual: 1
>I would expect that a row with a value 0 is returned. I suspe
On Sunday, 9 June, 2019 05:20, Manuel Rigger wrote:
>CREATE TABLE t0(c0 TEXT);
>INSERT INTO t0(c0) VALUES (x'41'); -- 'A' if converted to TEXT
>SELECT (+ c0) IS c0 FROM t0; -- expected: 0, actual: 1
Note also that the only place where + is different from by
itself generally speaking is in an
On Sunday, 9 June, 2019 08:15, Manuel Rigger wrote:
>Hi Keith,
>I don't understand completely. So we agree that +c0 has no affinity.
>However, you argue that c0 has BLOB affinity, if I understood
>correctly.
>Why is that? I'd assume that it has TEXT affinity, since the table
>column is declared
On Wednesday, 12 June, 2019 07:35, Richard Hipp wrote:
>IEEE754 floating point numbers have separate representations for +0.0
>and -0.0. As currently implemented, SQLite always display both
>quantities as just "0.0".
>Question: Should SQLite be enhanced to show -0.0 as "-0.0"? Or,
>would that
On Wednesday, 12 June, 2019 10:02, James K. Lowden
wrote:
>1. Prior art. I can't think of a single programming language that
>displays -0.0 without jumping through hoops.
---//--- t.c ---//---
#include
int main(int argc, char** argv)
{
printf("%f %f\n", -0.0, 0.0);
}
---//--- t.c ---//
t(s) in 0.44s
Running `target\release\demo.exe`
0 0
-0.0 0.0
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqli
Perhaps this should be handled the same way as Inf and -Inf. For the purposes
of conversion to text the value should be 0.0. However, for the purposes of
.dump the actual -0.0 should be output just as Inf and -Inf are output as 1e999
and -1e999 respectively, since the purpose of .dump is to b
On Thursday, 13 June, 2019 11:28, Doug wrote:
>It occurs to me that if there are sqlite applications today requiring
>the functionality of -0.0, they have implemented it so that it works
>for their application. Perhaps, they accomplished that by adding a
>flag bit or by some other means.
>So if
On Thursday, 13 June, 2019 15:01, Donald Shepherd
wrote:
>Given there's been numerous comments to the effect that SQLite now
>supports -0.0 storing and retrieval other than printing, I'm curious
>which version this was implemented in as I wouldn't mind removing my
>custom code when we move to
On Thursday, 13 June, 2019 15:21, Donald Shepherd
wrote:
>On Fri, 14 Jun 2019 at 7:11 am, Richard Hipp wrote:
>> On 6/13/19, Donald Shepherd wrote:
>>> Given there's been numerous comments to the effect that SQLite
>>> now supports -0.0 storing and retrieval other than printing,
>>> I'm cur
n of SQLite Database
>Subject: Re: [sqlite] [SPAM?] Re: [EXTERNAL] Re: Should SQLite
>distinguish between +0.0 and -0.0 on output?
>
>On Fri., 14 Jun. 2019, 7:43 am Keith Medcalf,
>wrote:
>
>> On Thursday, 13 June, 2019 15:21, Donald Shepherd <
>> donald.sheph...@gm
On Monday, 17 June, 2019 17:50, Simon Slavin wrote:
>Can someone please explain this error message to me:
>
>Simple database, journal mode set to 'delete', accessed by two
>simultaneous sessions running the SQLite command-line shell,
>SQLite version 3.28.0 2019-04-15 14:49:49
>
>Session A:
>
>PRA
If you intend to update the database (ie, write to it) during a transaction,
you should begin that transaction with BEGIN IMMEDIATE; This signals that you
intend to WRITE to the database in that transaction and will prevent any other
connection from obtaining an INTENT (to write) lock.
BEGIN
On Monday, 17 June, 2019 18:46, Simon Slavin wrote:
>I think I see my error. I thought that the lock was promoted from
>read to read/write when the INSERT command was processed. At this
>point, SQLite knows that it is going to need to write.
>Instead, although SQLite knows that it is going to
On Monday, 17 June, 2019 18:46, Simon Slavin wrote:
>I think I see my error. I thought that the lock was promoted from
>read to read/write when the INSERT command was processed. At this
>point, SQLite knows that it is going to need to write.
>Instead, although SQLite knows that it is going to
On Monday, 17 June, 2019 21:36, Simon Slavin wrote:
>I understand about the RESERVED lock. I read the documentation. My
>surprise was at this, from further down the same page:
>" No EXCLUSIVE lock is acquired until either the memory cache fills
>up and must be spilled to disk or until the tra
On Tuesday, 18 June, 2019 07:12, Thomas Kurz wrote:
>This has been a very informative and helpful discussion. Thank you.
>So have I understood correctly, that in an application, this kind of
>SQLITE_BUSY handling is sufficient:
>BEGIN
>UPDATE #1
>SELECT #2
>UPDATE #3
>COMMIT <- check for b
sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf
>Sent: Tuesday, 18 June, 2019 08:25
>To: SQLite mailing list
>Subject: Re: [sqlite] Please explain multi-access behaviour to me
>
>
>On Tuesday, 18 June, 2019 07:12, Thomas Kurz
>w
What do you want for trigger info?
The following pragma code will return all the data in the currently loaded
schema for all attached databases (table/index/trigger names). It creates a
new pragma called DATABASE_INFO (and table pragme_database_info) that returns
three columns: schema type na
-
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf
>Sent: Friday, 21 June, 2019 15:
On Wednesday, 26 June, 2019 10:59, a...@zator.com wrote:
>Irreproachable argumentation, which in my humble opinion is little or
>nothing useful to those who want to enter in the diabolic world of
>SQL. Especially, if you have not yet managed to change the chip and
>find out that for example, you
On Friday, 28 June, 2019 07:37, Thomas Kurz wrote:
>> A WAL file left behind is a sign of a problem in the app which
>should be corrected.
>I have exactly this problem and don't like the SHM and WAL files
>being left behind. I have even tried "pragma wal_checkpoint(full)"
>before closing the co
On Tuesday, 2 July, 2019 13:26, Peng Yu :
>I not sure how to use os_unix.c. Are there any easy to follow
>examples in python?
YOU do not use os_unix.c. Perhaps you can state what it is that you are trying
to accomplish.
For example:
I would like to know how I drive a car to the supermarket
On Wednesday, 3 July, 2019 11:59, Peng Yu wrote:
>As I said in my original message "I am trying to understand how lock
>is implemented in sqlite3".
from os_unix.c:
/* The following describes the implementation of the various locks and
** lock transitions in terms of the POSIX advisory shar
On Friday, 5 July, 2019 12:26, Peng Yu :
>There is something shown below that uses SQLite3, but it still does
>not go deeper into reimplementing using the raw code available from
>SQLite3. This implementation merely calls SQLite3.
>https://github.com/pypa/pip/blob/master/src/pip/_vendor/lockfile
On Tuesday, 9 July, 2019 20:34, Andy Bennett wrote:
>However, the wording for WAL mode is confusing me.
>isolation.html says 'all transactions in SQLite show "serializable"
>isolation.' but it also says 'In WAL mode, SQLite exhibits "snapshot
>isolation"'.
>Snapshot Isolation and Serializable
>> I can highly recommend the book “Word by Word: The Secret Life of
>> Dictionaries,” written by one of the editors at Merriam-Webster.
>> The author spends much of her book illustrating why prescriptivist
>> approaches to language are doomed to failure.
Merriam-Webster does not publish a Dictio
301 - 400 of 2009 matches
Mail list logo
