Re: [sqlite] Grammar police

2019-07-12 Thread Don V Nielsen
Not to be argumentative with Keith, as I'm have the sinking feeling that slitting my own throat would be a more pleasurable experience. But, here it goes: A *lexicon* is a list of words that belong to a particular language. Sometimes, *lexicon* is used as another word for *thesaurus* (see below)

Re: [sqlite] Grammar police

2019-07-12 Thread Keith Medcalf
>> 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

Re: [sqlite] BLOB and TEXT comparisons

2019-07-12 Thread Clemens Ladisch
Charles Leifer wrote: > SELECT SUBSTR(?, 1, 3) == ? > > However, if I mix the types, e.g. sqlite3_bind_text("abcde") and > sqlite3_bind_blob("abc") then the comparison returns False. > > Fom a byte-to-byte perspective, this comparison should always return True. > > What's going on? Apparently, not

Re: [sqlite] Grammar police

2019-07-12 Thread Jose Isaias Cabrera
Warren Young, on Friday, July 12, 2019 12:53 PM, wrote... > > On Jul 12, 2019, at 10:16 AM, Jose Isaias Cabrera, on > > "an historical oversight" is the correct English syntax, by the way. ;-) > > I can highly recommend the book “Word by Word: The Secret Life of > Dictionaries,” written by one of

Re: [sqlite] Grammar police

2019-07-12 Thread Simon Slavin
Folks, lets return to charter, please. DRH is writing the document. He gets to pick the language to be used. You want something else, write your own. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi

Re: [sqlite] Grammar police

2019-07-12 Thread Carl Edquist
Note here "AN H", not "A H", because when saying "H", it starts with a vowel sound Re: Aitch vs. Haitch: https://www.theguardian.com/science/shortcuts/2013/nov/04/letter-h-contentious-alphabet-history-alphabetical-rosen On Fri, 12 Jul 2019, Stephen Chrzanowski wrote: "an historical oversig

Re: [sqlite] Grammar police

2019-07-12 Thread Stephen Chrzanowski
"an historical oversight" feels dirty to me, mostly because it's an incomplete sentence and can be understood in different ways. It's a "point", or answer to a question. In my verbage, "historical" begins with an H (Note here "AN H", not "A H", because when saying "H", it starts with a vowel soun

Re: [sqlite] Grammar police

2019-07-12 Thread Warren Young
On Jul 12, 2019, at 10:16 AM, Jose Isaias Cabrera wrote: > >>> Here in the Southeastern US (specifically in Charlotte, NC) we really >>> do say "an historical oversight". If you said "a historical >>> oversight", people would look at you funny. > > "an historical oversight" is the correct Engli

Re: [sqlite] Grammar police

2019-07-12 Thread Jose Isaias Cabrera
Warren Young, on Thursday, July 11, 2019 03:13 PM, wrote... > > On Jul 11, 2019, at 10:41 AM, Richard Hipp, on > > > > Here in the Southeastern US (specifically in Charlotte, NC) we really > > do say "an historical oversight". If you said "a historical > > oversight", people would look at you fun

[sqlite] BLOB and TEXT comparisons

2019-07-12 Thread Charles Leifer
I ran into a somewhat surprising result and wanted to just get a little clarification. I'll use the following statement as an example: SELECT SUBSTR(?, 1, 3) == ? And the parameters will be: * "abcde" * "abc" If I bind both parameters using the same type, the comparison returns True: * sqlite

Re: [sqlite] sqlite3_close() drops wal and shm files despite of other processes holding DB open

2019-07-12 Thread Dan Kennedy
On 11/7/62 23:07, Andreas Kretzer wrote: I'm using SQLITE3 (V3.29.0) on an arm embedded linux (2.6.39) on an ext3 filesystem. Several processes hold the DB open and the "-wal" and "-shm" files exist. if I use 'lsof | fgrep ' I can see all processes having all three files open. At least one of t