Re: [sqlite] Documentation update

2018-04-09 Thread Simon Slavin


On 9 Apr 2018, at 11:02am, R Smith  wrote:

> If you prefer "different from" to "different to", it is simply likely that 
> you are American rather than English, in which language the preference (I 
> should say "habit" really) is "different to" rather than "different from", 
> but I gather from sources that "different from" is the preference/habit in 
> American English, plus they have been using the newer variant: "different 
> than" - which got criticized a lot by the old guard, but with no real grounds.

I agree.  This is a UK English vs. US English matter.  And since the document 
maintainers are USAsian, I am quite happy for "different from".

And now I have the Monkees song _Valerie_ running around my head.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update

2018-04-09 Thread Don V Nielsen
I'm adding to my bucket list meeting some of you in person.

On Mon, Apr 9, 2018 at 5:58 AM, Niall O'Reilly  wrote:

> On 9 Apr 2018, at 11:02, R Smith wrote:
>
> > Gentlemen - shall we call pistols at dawn to settle this?
> > Or my favourite duel:  Face-pulling at midnight.  :)
>
> 8-)
>
> /Niall
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update

2018-04-09 Thread Niall O'Reilly
On 9 Apr 2018, at 11:02, R Smith wrote:

> Gentlemen - shall we call pistols at dawn to settle this?
> Or my favourite duel:  Face-pulling at midnight.  :)

8-)

/Niall


signature.asc
Description: OpenPGP digital signature
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update

2018-04-09 Thread R Smith


On 2018/04/09 10:51 AM, Niall O'Reilly wrote:

On 9 Apr 2018, at 2:08, Simon Slavin wrote:


"In unique indices, each NULL value is considered different to every other NULL 
value.  Thus each NULL value is unique."

For the sake of my late English teacher, I hope the revised document will read "... 
different __from__ ...".


Gentlemen - shall we call pistols at dawn to settle this?
Or my favourite duel:  Face-pulling at midnight.  :)

If you prefer "different from" to "different to", it is simply likely 
that you are American rather than English, in which language the 
preference (I should say "habit" really) is "different to" rather than 
"different from", but I gather from sources that "different from" is the 
preference/habit in American English, plus they have been using the 
newer variant: "different than" - which got criticized a lot by the old 
guard, but with no real grounds.


The word "to" is a natural juxtaposition relation indicator. "A is next 
to B", "I prefer coconut to mango" and "Apples are crunchy compared to 
oranges". The same goes for "different to".


All this said, I think the overall tone of the SQLite documentation is 
American (due the origin, no doubt), so I would vote to go with Niall's 
"different from" based on that.




___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update

2018-04-09 Thread Niall O'Reilly
On 9 Apr 2018, at 2:08, Simon Slavin wrote:

> "In unique indices, each NULL value is considered different to every other 
> NULL value.  Thus each NULL value is unique."

For the sake of my late English teacher, I hope the revised document will read 
"... different __from__ ...".

Best regards,
Niall O'Reilly


signature.asc
Description: OpenPGP digital signature
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update

2018-04-08 Thread Simon Slavin
On 9 Apr 2018, at 1:08am, Don V Nielsen  wrote:

> "For the purposes of unique indices, all NULL values are considered [to]
> different from all other NULL values and are thus unique."
> 
> I think it should read "...NULL value are considered different..."
> 
> https://www.sqlite.org/lang_createindex.html

I agree with Mister Nielsen that the original can be better phrased, but  my 
English teacher would not forgive me if I did not suggest an even bigger change:

"For the purposes of unique indices, all NULL values are considered to 
different from all other NULL values and are thus unique."

should be

"In unique indices, each NULL value is considered different to every other NULL 
value.  Thus each NULL value is unique."

Now my teacher is at peace, you may do what what you want.  Since some edits 
are already being made to the page, one might as well suggest ...

-

"Or if no collating sequence is otherwise defined, the built-in BINARY 
collating sequence is used."

Should be

"If no collating sequence is defined for a text column, the built-in BINARY 
collating sequence is used."

-

"There are no arbitrary limits"

should be more like

"There is no arbitrary limit"

though perhaps you might want to leave out the word 'arbitrary'.  Or perhaps 
even leave out the entire sentence, since the spirit of SQLite is that limits 
to all entities are caused only by namespace exhaustion or memory/storage 
limits.

-

"If the optional IF NOT EXISTS clause is present and another index with the 
same name already exists"

Remove the word "optional" since the "if" makes it clear that the clause is 
optional.  Replace "another" with "an".

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update

2018-04-08 Thread Don V Nielsen
"to be", or not "to be"  :)

On Sun, Apr 8, 2018 at 7:08 PM, Don V Nielsen  wrote:

> "For the purposes of unique indices, all NULL values are considered [to]
> different from all other NULL values and are thus unique."
>
> I think it should read "...NULL value are considered different..."
>
> https://www.sqlite.org/lang_createindex.html
>
> dvn
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update 2

2018-01-31 Thread William Entriken
Thank YOU.

Fix looks good now.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update

2018-01-31 Thread R Smith

On 2018/01/31 3:13 PM, Simon Slavin wrote:

I see. It has already been fixed. Sorry for the niggle.
Simon.


It's hard to stay on top of an error in the SQLite universe
They disappear so darn quick.

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update

2018-01-31 Thread Simon Slavin
On 31 Jan 2018, at 1:11pm, Kees Nuyt  wrote:

> On Wed, 31 Jan 2018 13:07:17 +, Simon Slavin
>  wrote:
>> 
>> Can you clarify your correction ?  I don't see a difference.
> 
> It used to be:
> 8.3. I/O while obtaining a lock leads to corruption
> 
> (the word error is missing)

I see.  It has already been fixed.  Sorry for the niggle.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update

2018-01-31 Thread Kees Nuyt
On Wed, 31 Jan 2018 13:07:17 +, Simon Slavin
 wrote:

>
>
>On 30 Jan 2018, at 6:51pm, William Entriken  wrote:
>
>> Hello. Regarding https://www.sqlite.org/howtocorrupt.html, item 8.3.
>> Perhaps this should be
>> 
>>> 8.3. I/O error while obtaining a lock leads to corruption
>
> Can you clarify your correction ?  I don't see a difference.

It used to be:
8.3. I/O while obtaining a lock leads to corruption

(the word error is missing)

-- 
Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update

2018-01-31 Thread Simon Slavin


On 30 Jan 2018, at 6:51pm, William Entriken  wrote:

> Hello. Regarding https://www.sqlite.org/howtocorrupt.html, item 8.3.
> Perhaps this should be
> 
>> 8.3. I/O error while obtaining a lock leads to corruption

Can you clarify your correction ?  I don't see a difference.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update 2

2018-01-30 Thread Richard Hipp
Fixed now (I think).  Thanks for the bug reports

On 1/30/18, William Entriken  wrote:
> Hello again. Regarding https://www.sqlite.org/howtocorrupt.html, item 8.6.
> Currently:
>
>> This race condition had apparently existing in all prior versions of
> SQLite...
>
> Should be:
>
>> This race condition had apparently existed in all prior versions of
> SQLite...
>
> Regards,
> William Entriken
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update request

2013-09-05 Thread Markus Schaber
Hi, Simon,

von Simon Slavin
> On 4 Sep 2013, at 3:05pm, Markus Schaber 
> wrote:
> 
> > Afaics, this applies to partial indices for similar reasons.
> 
> I did not even know partial indices was implemented.  Thank you.

It's new in 3.8.0 :-)


Best regards

Markus Schaber

CODESYS(r) a trademark of 3S-Smart Software Solutions GmbH

Inspiring Automation Solutions

3S-Smart Software Solutions GmbH
Dipl.-Inf. Markus Schaber | Product Development Core Technology
Memminger Str. 151 | 87439 Kempten | Germany
Tel. +49-831-54031-979 | Fax +49-831-54031-50

E-Mail: m.scha...@codesys.com | Web: http://www.codesys.com | CODESYS store: 
http://store.codesys.com
CODESYS forum: http://forum.codesys.com

Managing Directors: Dipl.Inf. Dieter Hess, Dipl.Inf. Manfred Werner | Trade 
register: Kempten HRB 6186 | Tax ID No.: DE 167014915

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update request

2013-09-04 Thread Simon Slavin

On 4 Sep 2013, at 3:05pm, Markus Schaber  wrote:

> Afaics, this applies to partial indices for similar reasons.

I did not even know partial indices was implemented.  Thank you.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Documentation update request

2013-09-04 Thread Markus Schaber
Hi,

von Simon Slavin
> Could the page
> 
> 
> 
> please be updated to reflect the introduction of WAL mode ?  I know this
> doesn't change the format of the database file itself, but it does change the
> format of files on disk, and it does mean that earlier and later versions of
> SQLite won't play nice under some circumstances.

Afaics, this applies to partial indices for similar reasons.


Best regards

Markus Schaber

CODESYS(r) a trademark of 3S-Smart Software Solutions GmbH

Inspiring Automation Solutions

3S-Smart Software Solutions GmbH
Dipl.-Inf. Markus Schaber | Product Development Core Technology
Memminger Str. 151 | 87439 Kempten | Germany
Tel. +49-831-54031-979 | Fax +49-831-54031-50

E-Mail: m.scha...@codesys.com | Web: http://www.codesys.com | CODESYS store: 
http://store.codesys.com
CODESYS forum: http://forum.codesys.com

Managing Directors: Dipl.Inf. Dieter Hess, Dipl.Inf. Manfred Werner | Trade 
register: Kempten HRB 6186 | Tax ID No.: DE 167014915
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users