Re: [sqlite] sqlite3 tool bug

a file > and redirecting to a pipe. Even if the data coming from the first command contained characters that "confused" the "text" mode of Windows, I would expect things to work or fail the same whether the output's being piped or sent to a file. My "shot in the dark

Re: [sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode

Original message From: Dan Kennedy Date: 26/05/2016 18:04 (GMT+00:00) To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode > On UNIX, it's possible to

[sqlite] Destroy all evidence of a database

> ?Well, the best that I can think of is to have your application create a > new, randomly named, directory... I can't help directly (I don't the innards of SQLite) but can hopefully clarify what *I* think Simon's asking: he's already said in his original message that he used to use a temporary

[sqlite] order by not working in combination with random()

And while "SELECT random() AS rr ORDER BY rr" is slightly contrived, the example from J Decker: select ItemName,SoldDate, date('now','-1 month') as z from SoldItemDetails order by SoldDate wrote: > select random() order by random() should definately reprocess the function... Agreed.? But I've

[sqlite] order by not working in combination with random()

Apologies .. I assumed the random() example was a "created to show the effect" query by the OP. ?Your example was the one using the date function. Original message From: J Decker <d3c...@gmail.com> Date: 26/08/2015 11:42 (GMT+00:00) To: Graham Holden ,Ge

[sqlite] How to see SQLite debugging information

If you have, or create, a VB6 standalone EXE that calls SQLite, you should be possible to get it to show stdout/stderr. By default, such EXEs are marked as "GUI" programs: if launched from a command prompt, the prompt returns immediately and they don't have a "console". However, you can change

[sqlite] Error: no such column: When column exists!

Hello Jason, Your second example ends with 0xA0 (a space with the high-bit set; sometimes used as a non-breaking space). Graham Holden Wednesday, July 15, 2015, 8:53:20 PM, you wrote: > So yes, I was missing 'S's, but that is only because I've been hacking at the > tables to get som

Re: [sqlite] Primary key used in compound index

The assertion that AUTOINCREMENT has no effect (here and in another post) is incorrect.  Without it, SQLite MAY reuse a key from deleted rows; with it, this will not happen. Sent from Samsung Galaxy Note Original message From: Simon Slavin Date:

Re: [sqlite] Primary key used in compound index

The assertion that AUTOINCREMENT has no effect (here and in another post) is incorrect.  Without it, SQLite MAY reuse a key from deleted rows; with it, this will not happen. Sent from Samsung Galaxy Note Original message From: Simon Slavin Date:

Re: [sqlite] sqlite3_bind_text issue

I'm not an expert, but I suspect it's the SQL_STATIC that's causing the problem. This means SQLite doesn't take a copy of your data and so when you do the sqlite3_step, all values are the same.  Try SQL_TRANSIENT. Sent from Samsung Galaxy Note Original message From: lyx

Re: [sqlite] Could not open registry key

You almost certainly need to be running with full admin permissions. If it's an MSI in the ZIP, just being logged into an admin account won't be sufficient on Windiws 7+  Open a command prompt by right-clicking and selecting "Run as administrator" and run the MSI from there. Sent from Samsung

Re: [sqlite] Very slow when query max(col) on empty set?

Out of curiosity, why is the "a < INF" clause (or something like "a < " in the original question) there? It doesn't seem to limit the results, and even if the overhead of having it there is minimal, does the fact that no one's suggested removing it mean it's needed/useful? SELECT

Re: [sqlite] Basic SQLite/EF6 question

I've no experience of SQLite with .NET/EF6 but... “Could not load file or assembly ‘System.Data.SQLite, Version=1.0.93.0,  Culture=neutral, PublicKey Token=db937bc2d44ff139’ or one of its  dependencies. An attempt was made to load a program with the incorrect  format.” in my experience indicates

[sqlite] Problem with sqlite3_db_filename

[sqlite] Form-Feed (0x0C) is not a space character in JSON

I've not seen the RFC but you say "JSON only has 5 whitespace characters" and then list only 4, and your patched array only has four 1's. ?Have you missed one, or is the 5 wrong (or am I missing something)? Graham Sent from Samsung Mobile Original message From: Jan Nijtmans

[sqlite] Sqlite good on Windows XP but very very slow on Windows Seven

) to FORCE writes to go through to the underlying disk, whereas later versions do. The speed under Windows 7 is the "real" speed; the apparent speedup under XP was an (unsafe) lie. Graham Holden Tuesday, October 20, 2015, 5:54:06 PM, you wrote: > Hi all, > Thank you for all suggestion

[sqlite] Nuget Sqlite Packages

Original message From: Simon Slavin Date: 17/09/2015 22:18 (GMT+00:00) To: General Discussion of SQLite Database Subject: Re: [sqlite] Nuget Sqlite Packages On 17 Sep 2015, at 8:27pm, R.Smith wrote: > Obligatory Disclaimer: I am not a lawyer

[sqlite] How to order by absolute value ?

Change "select abs(num)" in your second example to "select num" and you should be good. I'm guessing in your first example the ORDER BY only applies to the last SELECT. Graham. Sent from Samsung Mobile Original message From: Domingo Alvarez Duarte

[sqlite] How to enter Unicode character?

In case it helps... In a command-prompt, ALT 156 (hold ALT while pressing 156 on the NUMERIC keypad) uses the current code-page (British pound sign - ? - for me). ?Using ALT 0163 (i.e. preceding the character-code with a zero) uses Unicode (also a ?). I don't have an sqlite3 shell to hand to

[sqlite] Some FTS5 guidance

I've never used FTS, just throwing an off-the-wall idea out: instead of tokenising partial words, could you tokenise/store the reverse of each word (possibly in a separate place if that can be done): enihsnoom enihs enihsnus Then search for "enihs" as well as "shine". If you can't separate the

[sqlite] Random-access sequences

Original message From: Stephan Beal Date: 01/03/2016 12:07 (GMT+00:00) To: SQLite mailing list Subject: Re: [sqlite] Random-access sequences > On Tue, Mar 1, 2016 at 12:59 PM, Matthias-Christian Ott wrote: >> Unfortunately, this limits the

[sqlite] Version 3.13.0 coming soon

Original message From: Richard Hipp Date: 03/05/2016 13:33 (GMT+00:00) To: SQLite mailing list Subject: Re: [sqlite] Version 3.13.0 coming soon > Yes.? Apparently that is the new standard for security on unix systems.? Write lets you create new temp

Re: [sqlite] UPDATE statement without FROM clause

ged fields. See http://stackoverflow.com/a/22481731/2096401 for more details. Graham Holden sql...@aldurslair.com Monday, June 06, 2016, 9:11:14 AM, Hick Gunter <h...@scigames.at> wrote: > Would not > Replace into A () select ,, > from A [cross] join B on( ); > do the trick?

Re: [sqlite] System.data.SQLite documentation

I've seen those symptoms with other CHM files if they're on a network share. If that's the case for you, try copying to a local drive. Graham Sent from my Samsung Galaxy S7 - powered by Three Original message From: Mickey Feldman Date: 23/02/2017 12:45

Re: [sqlite] Linux top command and sqlite

Original message From: Roger Binns Date: 21/02/2017 20:48 (GMT+00:00) To: SQLite mailing list Subject: Re: [sqlite] Linux top command and sqlite On 21/02/17 10:22, Kevin O'Gorman wrote: > Some of my stuff takes

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

-- would I think help. Obligatory typo: Under "High Concurrency" of the "Appropriate Uses For SQLite" page you have "Writer queue up. Each application does...". At a minimum it should be "Writers"; possibly "Writer

Re: [sqlite] Why this query plan?

> So you could benefit from an index for reasons other than the usual reasons > eg assisting the where clause. Yes. Using a "covering index" (that contains all fields in the SELECT clause) is often suggested as a _potential_ optimisation step, so the main row-data does not need to be accessed

Re: [sqlite] date-2.2c tests fail for sqlite-3.16.1 on Fedora / i686

I don't know what the tests are doing, but could it be connected with the fact that a leap-second was added as we changed from 2016 to 2017 and one of expected/got is taking this into account and the other isn't? Graham Original message From: Richard Hipp Date:

Re: [sqlite] QUERY: Usage of malloc and free in SQLite

I've no idea of the internals of SQLite, but two things come to mind: 1. Can your custom allocation routines return the same address in the case of a realloc() call that is either smaller than the original allocation, or (if applicable) is larger but still fits in the original "memory block"?

Re: [sqlite] Help file has no information

Either don't store it on a network drive or right click, select properties and unlock (see https://social.technet.microsoft.com/Forums/en-US/20700886-2000-4c52-b706-aa1fb32d3dfb/cant-view-chm-file-contents?forum=W8ITProPreRel). I think. Graham Sent from my Samsung Galaxy S7 - powered by Three

Re: [sqlite] How to use parameterized queries in SQLite.Net

The main reason you should parameterise queries is to protect against "SQL injection".  "Hardcoded" as below doesn't make much difference, but if the data being used comes in any way from an "untrusted" source, then this is particularly important. If, instead of "234.56" below a malicious user

[sqlite] Incorrect SEARCH link on "c3ref" page

Using the SEARCH function on (at least a couple of) the "c3ref" pages (e.g. "sqlite.org/c3ref/exec.html") sends you to "sqlite.org/c3ref/search?q=xxx" (instead of "sqlite.org/search?q=xxx") and gives a page not found error instead of the search results. Graham

[sqlite] Is this safe use of SELECT in an INSERT?

I want to keep a semi-persistent list of server/port pairs with an associated "index" that can be used to refer to entries elsewhere. Given: create table Servers (    serverName    text,    serverPort       integer,    serverIdx         integer unique,    primary key ( serverName, serverPort ) )

Re: [sqlite] Is this safe use of SELECT in an INSERT?

08:59 (GMT+00:00) To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Is this safe use of SELECT in an INSERT? Graham Holden wrote: > insert or ignore into Servers values (    'MyServer',    12345,    ( select > count (*) from Servers ) ) > > is the "count (*)&q

Re: [sqlite] Version 3.20.0 release candidate 2

Going on the snippet in David's correction only:  That arbitrary SQL was suppose to be run inside a sandbox where it could do ** no ** harm even if exploited It probably should be "was supposed". Graham. Original message From: David Wellman Date:

Re: [sqlite] Proof that a line has been modified

Original message From: Jens Alfke Date: 07/09/2017 19:32 (GMT+00:00) To: SQLite mailing list Subject: Re: [sqlite] Proof that a line has been modified > On Sep 7, 2017, at 10:24 AM, Igor Tandetnik

Re: [sqlite] Unexpected echo when setting locking_mode

I'm not against rationalising the PRAGMA commands, but this wouldn't help with the example you gave. "page_size" is more accurately "the page size I would like it to be" and so can be "successfully" set at any time (providing it's a power of 2). The only time the current setting gets _acted_

Re: [sqlite] Running sums and averages

>>> Is there anything I can do to reduce the time taken? > > < Simon correctly advised > > > Do it in your favourite programming language rather than SQL. > Let me be even more clear : > Memory is cheap and most servers have plenty. > Processors are fast and most servers have

Re: [sqlite] Enabling MMAP in Android

Have you actually got speed issues, or is this just a case of "this should be faster"? If you DO have speed issues, my experience from reading this list is that most can be improved with better SQL, better indices, or better interplay between readers and writers. Only if those have been

Re: [sqlite] Database file with a nonstandard sqlite_seuence schema causes crash.

> The documentation says: > **"Warning: misuse of this pragma can easily result in a corrupt database > file."** But it would be nice if corrupted database didn't crash the application ;) If the database is (or appears) corrupted, terminating immediately or "crashing" is probably the only

Re: [sqlite] clocks in SQLite

issues than the clock itself? It is highly > unlikely that clock happened to jump forward at the time when 1852 > was finishing (at 16:44:11). Time of start of 2283 looks > correct, agrees with my watch, because I started this job manually. > Roman Regards, Graham Holden __

Re: [sqlite] Violated failed foreign key constraint delays the rest of transaction ; Some foreign key violations don't trigger the error at all

Hello Yuri, Friday, August 03, 2018, 12:06:14 AM, Yuri wrote: > On 8/2/18 3:46 PM, Keith Medcalf wrote: >> You are required to have a UNIQUE index on the PARENT KEYS in a foreign key >> relationship. >> >> Depending on whether the PARENT:CHILD is 1:1 or 1:N you need either >> a UNIQUE (1:1) or

Re: [sqlite] Save text file content in db: lines or whole file?

Tuesday, August 07, 2018, 7:36:26 PM, Abramo Bagnarawrote: > I've verified that not only substr(data, start, len) loads entire row, > but with my surprise that also retrieving a sibling column (I've tried > to add another column "info blob not null") loads entire row (i.e. > including whole data

Re: [sqlite] Why some options (ex. SQLITE_ENABLE_EXPLAIN_COMMENTS, SQLITE_ENABLE_DBPAGE_VTAB) are permanently enabled in Makefile.am, but are documented as user-defined?

Presumably the ".am" of "Makefile.am" refers to the single-file amalgamation. However, some of the compile-time options can only be set when building from the cannonical sources or generating the amalgamation... once the amalgamation has been generated, those options are "baked in". Graham.

Re: [sqlite] An artificial query whose outcome is changed after left join reduction

Off-topic addendum minor typo: "They both store content has a sequence" in the first paragraph should be "as". Sent from my Samsung Galaxy S7 - powered by Three Original message From: Richard Hipp Date: 10/04/2018 15:50 (GMT+00:00) To: SQLite mailing list

Re: [sqlite] Fossil Feature Request

Just adding "?ln" seems to add line numbers: https://www.sqlite.org/src/artifact/810fbfebe12359f1?ln Sent from my Samsung Galaxy S7 - powered by Three Original message From: J Decker Date: 30/03/2018 20:48 (GMT+00:00) To: SQLite mailing list

Re: [sqlite] Bug? INSERT OR REPLACE not equivalent to DELETE followed by INSERT

Thursday, March 22, 2018, 7:18:08 PM, Peter Michaux wrote: > I think there are a couple main offenders with >> BEGIN; >> INSERT OR IGNORE ... ; >> UPDATE ; >> COMMIT; > The first is that it is bulky. If this is in the application code then it > has to be repeated for each desired UPSERT

Re: [sqlite] curious discovery about geopoly module

> There are, of course, multiple apps on my system that use sqlite3.dll - > including the Bricscad app that I am running my vba code from.Speculating > somewhat: Have you tried updating the copy Briscad is using? If one version > is already in memory, you _may_ have problems persuading Windows

Re: [sqlite] [EXTERNAL] The "natural" order of the query results.

In particular, there's a not implausible optimisation opportunity that could alter things... In the general case, the execution of "GROUP BY a, b" will "naturally" involve a sort on "a, b" to bring all the "to be grouped" entries together. In the OP's case, there's a primary key on "a, b" so

Re: [sqlite] Drop table error with existing views

See https://www.sqlite.org/lang_altertable.html ... the ALTER TABLE command, by default, now alters references to it in triggers/views. To get the old behaviour, which I believe you need, use: PRAGMA legacy_alter_table=ON Graham Monday, April 01, 2019, 11:23:45 AM, Domingo Alvarez Duarte

[sqlite] Difference between ".import" and tcl/sqlite3 "copy"

I'm using SQLite through Tcl, and am having a problem with the sqlite3/Tcl "copy" command (similar to the shell's ".import" command). Given "test.csv" 1,"aaa","bbb ccc" Using the shell, I get the following -- the double-quotes from the CSV are not stored in the database: create table test ( id

Re: [sqlite] Difference between ".import" and tcl/sqlite3 "copy"

is to use Tcl to "exec" the SQLite shell and have it run ".import". Regards, Graham Holden ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] inconsistent behavior when creating INTEGER NOT NULL column without DEFAULT?

On Wednesday, February 13, 2019, 11:06:07 PM, Thomas Kurz wrote: >> I guess a missing DEFAULT automatically implies DEFAULT NULL, so >> the behavior of ALTER should be correct whilst CREATE seems to >> forget to reject the statement. I suspect the difference is you can CREATE a NOT NULL column

Re: [sqlite] Inconsistent behavior in sqlite3_set_authorizer() and error messages

For the last point, using the SQLITE_OMIT_TEMPDB option, did you compile from the amalgamation or the full cannonical sources? According to  https://www.sqlite.org/compile.html#_options_to_omit_features, many "OMIT" options only work when the cannonical sources are used (my guess if compiling

Re: [sqlite] Built in and enabled Virtual Table extensions in SQLite CLI?

Wednesday, April 10, 2019, 10:28:55 AM, Luuk wrote: > On 10-4-2019 10:28, Kees Nuyt wrote: >> sqlite> select * from pragma_function_list; > sqlite> select * from pragma_function_list; > Error: no such table: pragma_function_list From the help page

Re: [sqlite] Built in and enabled Virtual Table extensions in SQLite CLI?

Wednesday, April 10, 2019, 11:16:07 AM, Shawn Wagner wrote: > It should be pragma_function_list(). Note the parentheses. That doesn't make a difference if the shell hasn't been built with -DSQLITE_INTROSPECTION_PRAGMAS, and they don't appear necessary for a pragma that IS built-in (such as

Re: [sqlite] Problem with SELECT by rowid after INSERT

Friday, April 12, 2019, 7:23:31 PM, Jim Dossey wrote: > I'm doing the INSERT first, without a BEGIN ... COMMIT transaction, > then I'm doing the SELECT. Shouldn't the INSERT do it's own COMMIT > which should make the new row visible to the SELECT? Should I add > a BEGIN ... COMMIT around the

Re: [sqlite] How to set access permissions to protect a database file?

You should probably also make sure that users cannot alter the tcl file through which they access the database file; probably something like: chown reading_room /path/to/reading_room.tcl chmod 644 /path/to/reading_room.tcl (It's possible that you will also need execute permission on the file,

Re: [sqlite] sqlite-users Digest, Vol 138, Issue 4

Throwing a wild idea out: Can you try using single-quotes (e.g. "...where dancename = 'Waltz'..."). Single-quotes are meant to be used for text-literals; double-quotes are meant to "protect" field/table names where they clash with keywords (or contain "odd" characters). Additionally, do you by any

Re: [sqlite] RFE: allow parameters in PRAGMA statements

I suspect this doesn't happen because from an in-expert bit of poking, I don't think PRAGMA commands "really" get compiled to VDBE (which is what I believe "preparing" a statement does). In the transcript below, although the _query_ seems to use VDBE (to return the result in "p4", the two

Re: [sqlite] [EXTERNAL] compressed sqlite3 database file?

Wednesday, April 10, 2019, 2:03:24 PM, Peng Yu wrote: > Given the much larger disk space required, for an occasional search of > the data, it seems that it makes no sense to use sqlite3 if disk space > is a major concern. Whether it "makes sense" to use SQLite or not, probably only you can

Re: [sqlite] dates, times and R

nterface would recognize the "...__date" and turn the value into an R date. Graham Holden ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fastest way to SELECT on a set of keys?

Another possibility... INSERT the keys in a temporary table and do an appropriate JOIN.Sent from my Samsung Galaxy S7 - powered by Three Original message From: Simon Slavin Date: 13/09/2019 17:51 (GMT+00:00) To: SQLite mailing list Subject: Re: [sqlite] Fastest way to

Re: [sqlite] Feature request: import MySQL dumps in CLI

rack changes in MySQL/MariaDB that might break things. Graham Holden ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Proposal: SQLite on DNA

esearchers have made a breakthrough, > enabling them to integrate DNA storage in PostgreSQL, a > popular open source database. " > What would it be ? A VFS ? As in Viral File System? Graham Regards, Graham Holden ___ sqlite-users maili

Re: [sqlite] database disk image is malformed

I've been having problems with my email system... I don't think earlier attempts at sending have made it to the list, but if they did, apologies for any duplication... Monday, November 11, 2019, 5:46:05 PM, Jukka Marin wrote: >> On 11 Nov 2019, at 5:13pm, Jukka Marin wrote: >> >> > The main

Re: [sqlite] Result set column names

Monday, December 09, 2019, 7:25:25 AM, Clemens Ladisch wrote: > The SQL-92 standard actually says: > > |Syntax Rules > | > |9) Case: > | > | b) If the i-th in the does not > | specify an and the of that > | is a single , then the > | of the i-th

Re: [sqlite] Missed index opportunities with sorting?

Monday, December 09, 2019, 1:32:40 PM, Digital Dog wrote: > On Sat, Dec 7, 2019 at 3:50 AM Simon Slavin wrote: >> On 7 Dec 2019, at 2:26am, Shawn Wagner wrote: >> >> > The first one uses the index for all sorting, but the second one only >> uses it for sorting a, not b. I feel like the

Re: [sqlite] sqlite segfault bug report

" this returns an error after the third line: Error: no such column: b Regards, Graham Holden ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Network file system that support sqlite3 well

Wednesday, October 16, 2019, 11:43:25 AM, Peng Yu wrote: > On 10/16/19, Simon Slavin wrote: >> Unfortunately, no. Multiuser SQLite depends on locking being implemented >> correctly. The developers haven't found any Network File Systems which do >> this. Unless one of the readers of this list

Re: [sqlite] Network file system that support sqlite3 well

Wednesday, October 16, 2019, 1:22:58 AM, Gary R. Schmidt wrote: > On 16/10/2019 10:38, Jens Alfke wrote: >> >>> On Oct 15, 2019, at 3:47 PM, Peng Yu wrote: >>> >>> I'd like to use sqlite3 db files on many compute nodes. But they >>> should access the same storage device for the sqlite3 db

Re: [sqlite] Backward compatibility

Tuesday, October 29, 2019, 7:37:40 AM, Thomas Kurz wrote: >> If an earlier version of SQLite attempts to read a database file >> that contains a generated column in its schema, then that earlier >> version will perceive the generated column syntax as an error and >> will report that the

Re: [sqlite] ALTER TABLE ADD COLUMN

Wednesday, October 23, 2019, 1:53:10 PM, x wrote: > From the documentation > “A record might have fewer values than the number of columns in the > corresponding table. This can happen, for example, after an ALTER TABLE ... > ADD COLUMN SQL statement has increased the number of > columns in

Re: [sqlite] Rounding Error

Monday, November 04, 2019, 8:41:48 AM, Adrian Sherwin wrote: > Hi, > I would like to report the following as a bug in SQLITE: > The SQLITE "round" function fails to round between 4.1 and 4.6% of numbers > correctly to x decimal places when held as x+1 decimal places. > The simplest example I

Re: [sqlite] Date time input

Tuesday, October 08, 2019, 7:39:40 PM, James K. Lowden wrote: > OK, but it needs a better name. What better place than here to debate > that? ;-) > SQLOfALot (providing you pronounce SQL as ess-queue-ell and not sequel) Graham ___ sqlite-users

Re: [sqlite] After deleting data from a FTS table and doing VACUUM, unwanted data remains

Tuesday, February 25, 2020, 3:00:09 PM, Luuk wrote: [tests snipped] > So, the index does not grow indefinitely > On 25-2-2020 14:00, Graham Holden wrote: >> It is an interesting problem. And the above is just guesswork... It would >> be good to verify experimentally that the

Re: [sqlite] sqliteDefaultBusyCallback and HAVE_USLEEP

Wednesday, February 26, 2020, 11:15:14 AM, Richard Hipp wrote: > On 2/25/20, Peter Kolbus wrote: >> I noticed that sqliteDefaultBusyCallback() seems to depend directly on the >> OS (behave differently based on SQLITE_OS_WIN||HAVE_USLEEP). Since the >> underlying primitive, sqlite3OsSleep(),

Re: [sqlite] After deleting data from a FTS table and doing VACUUM, unwanted data remains

r deleting some lines? > (2) If there is no way to remove the cruft, does that mean that adding and > deleting lines will constantly inflate the db size? > $ sqlite3 --version > 3.31.1 2020-01-27 19:55:54 > 3bfa9cc97da10598521b342961df8f5f68c7388fa117345eeb516eaa837balt1 > Thank you

Re: [sqlite] Default isolation_level for sqlite3.connect?

of list of "good practices" as explicitly declaring the columns in a SELECT statement (as opposed to using SELECT *) and (depending on the programming language) always using braces in an IF statement, even if there's only one statement to conditionally execute. They're not essential,

Re: [sqlite] Check constrain execution timing change?

Friday, January 31, 2020, 9:39:07 PM, Simon Slavin wrote: > On 31 Jan 2020, at 9:27pm, Keith Medcalf wrote: >> You are however correct that this is an "application consistency" >> problem more than an SQLite problem and it is a lot of change for >> little actual benefit. > How about this ?

Re: [sqlite] New word to replace "serverless"

Tuesday, January 28, 2020, 4:25:49 PM, Richard Hipp wrote: > Since suggesting daemon-less, someone else (I'll have to research who, > exactly) suggested "server-free", which I think I like more. What? A free server with every copy of SQLite? That sounds like a good deal :-) Graham

Re: [sqlite] Behavior change around triggers between 3.19 and 3.30

Thursday, January 30, 2020, 12:24:40 PM, Dominique Devienne wrote: > The strange thing though, is that I can't repro on a small example. > Despite using not_there in the trigger, and doing DML and ALTER TABLE, > still doesn't fail the same way as in production. What could be the cause? > --DD

Re: [sqlite] Sqlite error code 14 when using 3.31.0+

k, then since it's the parent directory of the SQLite file that openDirectory fails on, I would hazard a wild guess that this has something to do with SQLite's handling of journal files, about which that above check-in comment notes "O_NOFOLLOW is always included in open() system calls for jour