Re: [sqlite] Documentation update request

[Jose Isaias Cabrera]

Kevin Benson, on Thursday, August 15, 2019 02:40 PM, wrote...
>
> On Thu, Aug 15, 2019 at 2:33 PM Jose Isaias Cabrera, on
> wrote:

> > Oh! Trickery!
> >
> >
> Dickery (sometimes a nickname for RICHARD ;-)
> Doc (...umentation; the something Richard "Dick" Hipp was doing ;-)

I could never use those words for Dr. Hipp, nor anyone in this list. ;-)

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

Re: [sqlite] Documentation update request

[Kevin Benson]

On Thu, Aug 15, 2019 at 2:33 PM Jose Isaias Cabrera 
wrote:

> Richard Hipp, on Thursday, August 15, 2019 01:32 PM, wrote...
> >
> > On 8/15/19, Simon Slavin, on
> > > On 15 Aug 2019, at 5:20pm, Richard Damon, on
> > >
> > >> You under quote, the faq says it “can not be changed (except under
> > >> extra-ordinary conditions).”, and those extra-ordinary conditions are
> a
> > >> link to the second section you mention.
> > >
> > > I didn't notice that, for some reason.  Thanks for the correction.
> >
> > You didn't notice it because I only added it moments ago, in response
> > to your documentation update request.
>
> Oh! Trickery!
>
>
Dickery (sometimes a nickname for RICHARD ;-)
Doc (...umentation; the something Richard "Dick" Hipp was doing ;-)
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation update request

[Jose Isaias Cabrera]

Richard Hipp, on Thursday, August 15, 2019 01:32 PM, wrote...
>
> On 8/15/19, Simon Slavin, on
> > On 15 Aug 2019, at 5:20pm, Richard Damon, on
> >
> >> You under quote, the faq says it “can not be changed (except under
> >> extra-ordinary conditions).”, and those extra-ordinary conditions are a
> >> link to the second section you mention.
> >
> > I didn't notice that, for some reason.  Thanks for the correction.
>
> You didn't notice it because I only added it moments ago, in response
> to your documentation update request.

Oh! Trickery!

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

Re: [sqlite] Documentation update request

[Richard Hipp]

On 8/15/19, Simon Slavin  wrote:
> On 15 Aug 2019, at 5:20pm, Richard Damon  wrote:
>
>> You under quote, the faq says it “can not be changed (except under
>> extra-ordinary conditions).”, and those extra-ordinary conditions are a
>> link to the second section you mention.
>
> I didn't notice that, for some reason.  Thanks for the correction.

You didn't notice it because I only added it moments ago, in response
to your documentation update request.


-- 
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

[Simon Slavin]

On 15 Aug 2019, at 5:20pm, Richard Damon  wrote:

> You under quote, the faq says it “can not be changed (except under 
> extra-ordinary conditions).”, and those extra-ordinary conditions are a link 
> to the second section you mention.

I didn't notice that, for some reason.  Thanks for the correction.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation update request

[Richard Damon]

> On Aug 15, 2019, at 10:37 AM, Simon Slavin  wrote:
> 
> 
> 
> says that sqlite_master cannot be changed.
> 
> 
> 
> tells you how to change it.
> 

You under quote, the faq says it “can not be changed (except under 
extra-ordinary conditions).”, and those extra-ordinary conditions are a link to 
the second section you mention.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Documentation update request

[Simon Slavin]

says that sqlite_master cannot be changed.



tells you how to change it.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation update

[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

[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

[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

[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

[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

[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

[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

[sqlite] Documentation update

[Don V Nielsen]

"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

[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

[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

[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

[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

[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

[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

[sqlite] Documentation update 2

[William Entriken]

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

[sqlite] Documentation update

[William Entriken]

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

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

Re: [sqlite] Documentation update request

[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

[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

[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

[sqlite] Documentation update request

[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.

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