Re: [sqlite] The SQL Guide to SQLite

2009-07-22 Thread Guido Ostkamp 
Robert Citek  wrote:
> Anyone know of a way to preview the index, the table of contest, or
> some sample chapters?  I tried viewing form the Lulu site, but no
> luck.

It appears it has not been scanned by Google yet. However a limited
preview of the other book "The Definite Guide to SQLite" can be found
at


Regards

Guido

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

Re: [sqlite] The SQL Guide to SQLite

2009-07-20 Thread John Elrick 
John Machin wrote:
> On 20/07/2009 12:08 AM, P Kishor wrote:
>   
>> unfortunately, we get either advertisements nowadays
>>
>> 
>
>   
>> or a signature twice the length of the message warning us that the
>> contents of the particular email are confidential and meant only for
>> the recipient, and if I am not the recipient then I should promptly
>> destroy the message.
>> 
>
> The screamingly funny bit is that they should say "*intended* recipient" 
> but often they don't -- if I receive it, whether intended or not, I am 
> the recipient :-)
>
>   
>> In my view, those who attach such warnings and disclaimers to their
>> emails should be fired from their jobs for breach of security and
>> protocol
>> 
>
> Out there in enterprise land, it is not the individuals who are 
> attaching the warning/disclaimer -- admins are directed by the HigherUps 
> to configure the mail software to attach the e-bumf automatically
>   

With "ignorance is bliss" and "worshiping at the alter of blind 
stupidity" thinking like that going on, the recent economic meltdown not 
only becomes predictable, it becomes inevitable.


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

Re: [sqlite] The SQL Guide to SQLite

2009-07-19 Thread Robert Citek 
On Sun, Jul 19, 2009 at 11:23 AM, Rick
Ratchford wrote:
> Anyway, when I've gathered enough info from the book I'll share my thoughts
> on it. It will be from the perspective of a person new to SQLite and SQL.

Anyone know of a way to preview the index, the table of contest, or
some sample chapters?  I tried viewing form the Lulu site, but no
luck.

http://www.lulu.com/content/7251432

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

Re: [sqlite] The SQL Guide to SQLite

2009-07-19 Thread Simon Slavin 

On 19 Jul 2009, at 3:32pm, John Machin wrote:

> On 20/07/2009 12:08 AM, P Kishor wrote:
>>
>> unfortunately, we get either advertisements nowadays
>>
>
>> or a signature twice the length of the message warning us that the
>> contents of the particular email are confidential and meant only for
>> the recipient, and if I am not the recipient then I should promptly
>> destroy the message.
>
> The screamingly funny bit is that they should say "*intended*  
> recipient"
> but often they don't -- if I receive it, whether intended or not, I am
> the recipient :-)

Actually, the screamingly funny bit is that under both UK and US law,  
not only is there no legal force behind the implied threat, but that  
intentionally using the same boilerplate message to send non- 
confidential messages invalidates all use of the boilerplate text.  In  
other words by using that text on all messages, whether confidential  
or not, you are implicitly admitting that you don't regard any of your  
messages as particularly confidential.

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

Re: [sqlite] The SQL Guide to SQLite

2009-07-19 Thread Rick Ratchford 
LOL!

I didn't intend for the thread to get out of hand like this.

Anyway, the question was answered regardless. And to EVERYONE who had a
comment, thanks.

The book is VERY THICK. Just the way I like them. For the cost, it better
be.

Why such a book on SQL for SQLite when SQLite is 'easy'? I think I can
answer that. Because you have people like me who find it very time consuming
to find answers to most of the questions needing answers by surfing the net,
and you don't want to keep bothering folks on this wonderful list on every
little issue due to being a novice to begin with (yep, that's me. Newbie
SQLite programmer!)

Everyone here has been VERY HELPFUL! I'm very impressed with how this group
responds and behaves. Wonderful. But I wish to do my part and if someone has
put together a comprehensive (hopefully) book on this subject, I'm going to
read it and hopefully be a contributor as well.

5 weeks ago I didn't even know SQLite existed. There was a task I wanted to
accomplish via Visual Basic 6 (the language I use the most) and was told
about SQLite by Olaf Schmidt, who has a VB6 wrapper for SQLite. He's been a
MAJOR help in getting me up to speed on some basic stuff and I'm hooked! 

Anyway, when I've gathered enough info from the book I'll share my thoughts
on it. It will be from the perspective of a person new to SQLite and SQL.

Regards to all!

Rick


 

#>-Original Message-
#>From: sqlite-users-boun...@sqlite.org 
#>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Fred Williams
#>Sent: Sunday, July 19, 2009 8:53 AM
#>To: punk...@eidesis.org; General Discussion of SQLite Database
#>Subject: Re: [sqlite] The SQL Guide to SQLite
#>
#>Reminds me of the old days BTW (Before The Web) when the News 
#>Net's main recreation was "C" language curly brackets 
#>formatting flame wars :-)
#>
#>I was kind'a wondering what on earth is so complicated in 
#>SQLite that would take an entire book to cover?  Is it a thin 
#>book?  How 'bout big print for us old _arts.
#>
#>Fred
#>
#>Miss the old signature "Tag line" message terminators as 
#>well, as most times they were much more entertaining than the 
#>post they were attached to.
#>
#>-Original Message-
#>From: sqlite-users-boun...@sqlite.org
#>[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of P Kishor
#>Sent: Sunday, July 19, 2009 8:06 AM
#>To: General Discussion of SQLite Database
#>Subject: Re: [sqlite] The SQL Guide to SQLite
#>
#>
#>On Sat, Jul 18, 2009 at 8:55 PM, <aba.elha...@comcast.net> wrote:
#>> Rick,
#>> This a very comon way for citations in ACM and IEEE papers.
#>> Others such as ESA use "Lname" year.
#>>
#>..
#>
#>Good grief... this is the most ridiculous thread. Poor Rick. 
#>All he said was that there were weird looking citations in a 
#>computer software "how-to" book. He ended up getting a 
#>treatise on citation styles. In solidarity with Rick, I have 
#>almost 10 computer how-to books, and while they do have 
#>footnotes, none of them have citations of any sort whatsoever.
#>
#>Now, can we please have a new thread where Rick tells us 
#>whether the book is any good or not?
#>
#>
#>--
#>Puneet Kishor http://www.punkish.org
#>Carbon Model http://carbonmodel.org
#>Charter Member, Open Source Geospatial Foundation 
#>http://www.osgeo.org Science Commons Fellow, 
#>http://sciencecommons.org/about/whoweare/kishor
#>Nelson Institute, UW-Madison http://www.nelson.wisc.edu
#>--
#>-
#>Assertions are politics; backing up assertions with evidence 
#>is science 
#>==
#>=
#>Sent from Madison, WI, United States
#>___
#>sqlite-users mailing list
#>sqlite-users@sqlite.org
#>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>
#>___
#>sqlite-users mailing list
#>sqlite-users@sqlite.org
#>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>
#>


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

Re: [sqlite] The SQL Guide to SQLite

2009-07-19 Thread John Machin 
On 20/07/2009 12:08 AM, P Kishor wrote:
> 
> unfortunately, we get either advertisements nowadays
> 

> or a signature twice the length of the message warning us that the
> contents of the particular email are confidential and meant only for
> the recipient, and if I am not the recipient then I should promptly
> destroy the message.

The screamingly funny bit is that they should say "*intended* recipient" 
but often they don't -- if I receive it, whether intended or not, I am 
the recipient :-)

> In my view, those who attach such warnings and disclaimers to their
> emails should be fired from their jobs for breach of security and
> protocol

Out there in enterprise land, it is not the individuals who are 
attaching the warning/disclaimer -- admins are directed by the HigherUps 
to configure the mail software to attach the e-bumf automatically


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

Re: [sqlite] The SQL Guide to SQLite

2009-07-19 Thread P Kishor 
On Sun, Jul 19, 2009 at 8:53 AM, Fred Williams wrote:
> Miss the old signature "Tag line" message terminators as well, as most times
> they were much more entertaining than the post they were attached to.

unfortunately, we get either advertisements nowadays

"sent from my  so please
xcsue teh spelings" -

or a signature twice the length of the message warning us that the
contents of the particular email are confidential and meant only for
the recipient, and if I am not the recipient then I should promptly
destroy the message.

In my view, those who attach such warnings and disclaimers to their
emails should be fired from their jobs for breach of security and
protocol -- "hi, I am sending you a confidential message, but I am
sending it to an entire mailing list that has an unknown number of
unknown folks from around the world subscribing to it, so, if it is
not for you, please delete it."

Seriously. WTF!



-- 
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
---
Assertions are politics; backing up assertions with evidence is science
===
Sent from Madison, WI, United States
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] The SQL Guide to SQLite

2009-07-19 Thread Rich Shepard 
On Sun, 19 Jul 2009, Neville Franks wrote:

> Many were disappointed with "The Definitive Guide to SQLite".

   One readers opinion: I find Mike Owens' book excellent and it continues to
be an important reference for me. My only disappointment is the index; it's
essentially useless. I paid the extra $10 for the pdf version of the book
and I search that for terms since they're not in the index. Overall, the
book has been valuable to me.

   I reviewed a couple of chapters in Rick's new book and offered a few
suggestions that I felt would improve it. I've not yet seen the complete
book. However, I strongly recommend his "Introduction to SQL, 4th Ed." and
expect the SQLite-specific version to be on par with that.

Rich

-- 
Richard B. Shepard, Ph.D.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 Voice: 503-667-4517  Fax: 503-667-8863
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] The SQL Guide to SQLite

2009-07-19 Thread Fred Williams 
Reminds me of the old days BTW (Before The Web) when the News Net's main
recreation was "C" language curly brackets formatting flame wars :-)

I was kind'a wondering what on earth is so complicated in SQLite that would
take an entire book to cover?  Is it a thin book?  How 'bout big print for
us old _arts.

Fred

Miss the old signature "Tag line" message terminators as well, as most times
they were much more entertaining than the post they were attached to.

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of P Kishor
Sent: Sunday, July 19, 2009 8:06 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] The SQL Guide to SQLite


On Sat, Jul 18, 2009 at 8:55 PM, <aba.elha...@comcast.net> wrote:
> Rick,
> This a very comon way for citations in ACM and IEEE papers.
> Others such as ESA use "Lname" year.
>
..

Good grief... this is the most ridiculous thread. Poor Rick. All he
said was that there were weird looking citations in a computer
software "how-to" book. He ended up getting a treatise on citation
styles. In solidarity with Rick, I have almost 10 computer how-to
books, and while they do have footnotes, none of them have citations
of any sort whatsoever.

Now, can we please have a new thread where Rick tells us whether the
book is any good or not?


--
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
---
Assertions are politics; backing up assertions with evidence is science
===
Sent from Madison, WI, United States
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

Re: [sqlite] The SQL Guide to SQLite

2009-07-19 Thread aba . elhaddi 
Rick,
This a very comon way for citations in ACM and IEEE papers.
Others such as ESA use "Lname" year.

--A El Haddi
Sent via BlackBerry from T-Mobile

-Original Message-
From: "Rick Ratchford" <r...@amazingaccuracy.com>

Date: Sat, 18 Jul 2009 19:20:40 
To: 'General Discussion of SQLite Database'<sqlite-users@sqlite.org>
Subject: Re: [sqlite] The SQL Guide to SQLite


Perhaps its true that its common in academic papers. I wouldn't know as I've
never read one.

All I know is that this is a book. I have a vast library of technical books
and this is the ONLY one that uses this convention. Even my copy of "A New
Kind of Science" by Wolfram doesn't use this convention. :-b

So seeing it for the first time was very confusing. I flipped through the
last pages and didn't note the one page biblio. That's when I ran it through
'bing' before asking here.

Even doing a 'bing' on "square brackets" suggested they were placeholders
for other information during production. I think some kind of convention
explanation would have been appropriate at the beginning of this book like
most programming books provide rather than assuming everyone is familiar
with conventions used in "academic papers". 

Thanks. 
:-)
Rick

 
 

#>-Original Message-
#>From: sqlite-users-boun...@sqlite.org 
#>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Thomas Briggs
#>Sent: Saturday, July 18, 2009 6:53 PM
#>To: General Discussion of SQLite Database
#>Subject: Re: [sqlite] The SQL Guide to SQLite
#>
#>   That's pretty common in academic papers, actually.
#>
#>   -T
#>
#>
#>On 7/18/09, Rick Ratchford <r...@amazingaccuracy.com> wrote:
#>> Yes. You are correct. That is what they are.
#>>
#>> Thanks for pointing this out. It probably should have been 
#>made clear 
#>> at the beginning of the book since this is not common in 
#>the majority 
#>> of books I own purchased here in the US.
#>>
#>> Thanks again.
#>>
#>> Rick
#>>
#>>
#>> #>-Original Message-
#>> #>From: sqlite-users-boun...@sqlite.org 
#>> #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of 
#>Igor Tandetnik
#>> #>Sent: Saturday, July 18, 2009 10:42 AM
#>> #>To: sqlite-users@sqlite.org
#>> #>Subject: Re: [sqlite] The SQL Guide to SQLite #> #>Rick Ratchford 
#>> wrote:
#>> #>> I just received my copy of the new book "The SQL Guide to 
#>> #>SQLite" by #>> Rick F. van der Lans.
#>> #>>
#>> #>> There are many references within the book that are 
#>#>contained in 
#>> square #>> brackets and some sort of keyword or code.
#>> #>>
#>> #>> Example: "...written about SQLite; see for example [NEWM05] and 
#>> #>> [OWEN06]."
#>> #>
#>> #>These are most likely citations. See if there's a 
#>#>bibliography (a 
#>> list of other books, articles and such) at #>the end of the 
#>book, each 
#>> reference identified by one of these codes.
#>> #>
#>> #>Igor Tandetnik
#>> #>
#>> #>
#>> #>
#>> #>___
#>> #>sqlite-users mailing list
#>> #>sqlite-users@sqlite.org
#>> #>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>> #>
#>> #>
#>>
#>>
#>> ___
#>> sqlite-users mailing list
#>> sqlite-users@sqlite.org
#>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>>
#>
#>--
#>Sent from my mobile device
#>___
#>sqlite-users mailing list
#>sqlite-users@sqlite.org
#>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>
#>


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

Re: [sqlite] The SQL Guide to SQLite

2009-07-18 Thread Rick Ratchford 
Greetings Neville-

(thanks for changing the subject. :)

I'm only a few pages into the book. Before I went deeper, I just wanted to
get a handle on the [...] notations.

The first few pages are quite informative. Let me get deeper into the book
and I'll be glad to share my thoughts on it here.

Best regards,
Rick
 
 

#>-Original Message-
#>From: sqlite-users-boun...@sqlite.org 
#>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Neville Franks
#>Sent: Saturday, July 18, 2009 9:11 PM
#>To: sqlite-users@sqlite.org
#>Subject: Re: [sqlite] The SQL Guide to SQLite
#>
#>Rick,
#>Changing the conversation a little I would be interested to 
#>know your opinion of this book, as I'm sure would others. 
#>Many were disappointed with "The Definitive Guide to SQLite".
#>
#>
#>Sunday, July 19, 2009, 11:56:05 AM, you wrote:
#>
#>RR> Okay. We're talking two different things here.
#>
#>RR> One states "academic papers" and you state "technical documents".
#>
#>RR> This is a "book", not an "academic paper or technical document".
#>
#>RR> I'm all for Names and Dates. I'm quite familiar with 
#>(Williams and 
#>RR> Jones
#>RR> 1981) and other such references. They appear in most of 
#>the books I possess.
#>
#>RR> However, bracketed references such as [SMI01] do not. 
#>First time in 
#>RR> my 50 years I've come across this.
#>
#>RR> Are we assuming that everyone who buys this book attended 
#>University?
#>
#>RR> Another thing I'm familiar with are TAGS in documents. 
#>These looked 
#>RR> like TAGS to me. I immediately assumed the TAGS weren't replaced 
#>RR> with the actual material.
#>
#>RR> Anyway, I think enough has been said on this. One should never 
#>RR> ASSUME that a convention is understood by ALL readers. 
#>Apparently, it is not.
#>
#>RR> Best regards,
#>
#>RR> Rich
#>
#>
#>RR>  
#>
#>#>>-Original Message-
#>#>>From: sqlite-users-boun...@sqlite.org 
#>#>>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rich Shepard
#>#>>Sent: Saturday, July 18, 2009 8:00 PM
#>#>>To: General Discussion of SQLite Database
#>#>>Subject: Re: [sqlite] The SQL Guide to SQLite #>> #>>On 
#>Sat, 18 Jul 2009, Rick Ratchford wrote:
#>#>>
#>#>>> All I know is that this is a book. I have a vast library 
#>of #>>technical #>>> books and this is the ONLY one that uses 
#>this convention. 
#>#>>Even my copy
#>#>>> of "A New Kind of Science" by Wolfram doesn't use this 
#>#>>convention. :-b #>>
#>#>>   There are many conventions for citations in books, 
#>#>>reports, articles, and other documents that cite original 
#>#>>sources. When I was in academia, the ecological literature 
#>#>>(books, papers, etc.) used a (name date) format; e.g., 
#>(Smith #>>1962), or (Williams and Jones 1981), or (Foobar et 
#>al. 1954). 
#>#>>The bibliography or reference section (and there is a 
#>#>>difference between those
#>#>>two) was arranged in alphabetic order. Many other 
#>technical #>>books (including
#>#>>mine) use a numeric citation, e.g., [20], and the 
#>#>>bibliography is numeric rather than alphabetic. Still 
#>other #>>technical documents use the author abreviation plus 
#>two-digit #>>year system which is what you apparently 
#>encountered; e.g., #>>[ORA92] or [SMI01]. They are all common.
#>#>>
#>#>>   Personally, I like the author/year system because it's 
#>#>>explicit and easy to comprehend without requiring looking 
#>at #>>the references section.
#>#>>Regardless, it's up to the publisher, country, or the 
#>#>>practice of a particular discipline which one is used.
#>#>>
#>#>>   It's unfortunate that you had such difficulty figuring out 
#>#>>the citation system.
#>#>>
#>#>>Rich
#>#>>
#>#>>-- 
#>#>>Richard B. Shepard, Ph.D.   |  Integrity  
#>#>>  Credibility
#>#>>Applied Ecosystem Services, Inc.|Innovation
#>#>><http://www.appl-ecosys.com> Voice: 503-667-4517  
#>#>>Fax: 503-667-8863
#>#>>___
#>#>>sqlite-users mailing list
#>#>>sqlite-users@sqlite.org
#>#>>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>#>>
#>#>>
#>
#>
#>RR> ___
#>RR> sqlite-users mailing list
#>RR> sqlite-users@sqlite.org
#>RR> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>
#>
#>
#>--
#>Best regards,
#>  Neville Franks, http://www.surfulater.com http://blog.surfulater.com
#> 
#>
#>___
#>sqlite-users mailing list
#>sqlite-users@sqlite.org
#>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>
#>


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

Re: [sqlite] The SQL Guide to SQLite

2009-07-18 Thread Neville Franks 
Rick,
Changing the conversation a little I would be interested to know your
opinion of this book, as I'm sure would others. Many were disappointed
with "The Definitive Guide to SQLite".


Sunday, July 19, 2009, 11:56:05 AM, you wrote:

RR> Okay. We're talking two different things here.

RR> One states "academic papers" and you state "technical documents".

RR> This is a "book", not an "academic paper or technical document".

RR> I'm all for Names and Dates. I'm quite familiar with (Williams and Jones
RR> 1981) and other such references. They appear in most of the books I possess.

RR> However, bracketed references such as [SMI01] do not. First time in my 50
RR> years I've come across this.

RR> Are we assuming that everyone who buys this book attended University?

RR> Another thing I'm familiar with are TAGS in documents. These looked like
RR> TAGS to me. I immediately assumed the TAGS weren't replaced with the actual
RR> material.

RR> Anyway, I think enough has been said on this. One should never ASSUME that a
RR> convention is understood by ALL readers. Apparently, it is not.

RR> Best regards,

RR> Rich


RR>  

#>>-Original Message-
#>>From: sqlite-users-boun...@sqlite.org 
#>>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rich Shepard
#>>Sent: Saturday, July 18, 2009 8:00 PM
#>>To: General Discussion of SQLite Database
#>>Subject: Re: [sqlite] The SQL Guide to SQLite
#>>
#>>On Sat, 18 Jul 2009, Rick Ratchford wrote:
#>>
#>>> All I know is that this is a book. I have a vast library of 
#>>technical 
#>>> books and this is the ONLY one that uses this convention. 
#>>Even my copy 
#>>> of "A New Kind of Science" by Wolfram doesn't use this 
#>>convention. :-b
#>>
#>>   There are many conventions for citations in books, 
#>>reports, articles, and other documents that cite original 
#>>sources. When I was in academia, the ecological literature 
#>>(books, papers, etc.) used a (name date) format; e.g., (Smith 
#>>1962), or (Williams and Jones 1981), or (Foobar et al. 1954). 
#>>The bibliography or reference section (and there is a 
#>>difference between those
#>>two) was arranged in alphabetic order. Many other technical 
#>>books (including
#>>mine) use a numeric citation, e.g., [20], and the 
#>>bibliography is numeric rather than alphabetic. Still other 
#>>technical documents use the author abreviation plus two-digit 
#>>year system which is what you apparently encountered; e.g., 
#>>[ORA92] or [SMI01]. They are all common.
#>>
#>>   Personally, I like the author/year system because it's 
#>>explicit and easy to comprehend without requiring looking at 
#>>the references section.
#>>Regardless, it's up to the publisher, country, or the 
#>>practice of a particular discipline which one is used.
#>>
#>>   It's unfortunate that you had such difficulty figuring out 
#>>the citation system.
#>>
#>>Rich
#>>
#>>-- 
#>>Richard B. Shepard, Ph.D.   |  Integrity  
#>>  Credibility
#>>Applied Ecosystem Services, Inc.|Innovation
#>><http://www.appl-ecosys.com> Voice: 503-667-4517  
#>>Fax: 503-667-8863
#>>___
#>>sqlite-users mailing list
#>>sqlite-users@sqlite.org
#>>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>>
#>>


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



-- 
Best regards,
  Neville Franks, http://www.surfulater.com http://blog.surfulater.com
 

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

Re: [sqlite] The SQL Guide to SQLite

2009-07-18 Thread Rick Ratchford 
Okay. We're talking two different things here.

One states "academic papers" and you state "technical documents".

This is a "book", not an "academic paper or technical document".

I'm all for Names and Dates. I'm quite familiar with (Williams and Jones
1981) and other such references. They appear in most of the books I possess.

However, bracketed references such as [SMI01] do not. First time in my 50
years I've come across this.

Are we assuming that everyone who buys this book attended University?

Another thing I'm familiar with are TAGS in documents. These looked like
TAGS to me. I immediately assumed the TAGS weren't replaced with the actual
material.

Anyway, I think enough has been said on this. One should never ASSUME that a
convention is understood by ALL readers. Apparently, it is not.

Best regards,

Rich


 

#>-Original Message-
#>From: sqlite-users-boun...@sqlite.org 
#>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rich Shepard
#>Sent: Saturday, July 18, 2009 8:00 PM
#>To: General Discussion of SQLite Database
#>Subject: Re: [sqlite] The SQL Guide to SQLite
#>
#>On Sat, 18 Jul 2009, Rick Ratchford wrote:
#>
#>> All I know is that this is a book. I have a vast library of 
#>technical 
#>> books and this is the ONLY one that uses this convention. 
#>Even my copy 
#>> of "A New Kind of Science" by Wolfram doesn't use this 
#>convention. :-b
#>
#>   There are many conventions for citations in books, 
#>reports, articles, and other documents that cite original 
#>sources. When I was in academia, the ecological literature 
#>(books, papers, etc.) used a (name date) format; e.g., (Smith 
#>1962), or (Williams and Jones 1981), or (Foobar et al. 1954). 
#>The bibliography or reference section (and there is a 
#>difference between those
#>two) was arranged in alphabetic order. Many other technical 
#>books (including
#>mine) use a numeric citation, e.g., [20], and the 
#>bibliography is numeric rather than alphabetic. Still other 
#>technical documents use the author abreviation plus two-digit 
#>year system which is what you apparently encountered; e.g., 
#>[ORA92] or [SMI01]. They are all common.
#>
#>   Personally, I like the author/year system because it's 
#>explicit and easy to comprehend without requiring looking at 
#>the references section.
#>Regardless, it's up to the publisher, country, or the 
#>practice of a particular discipline which one is used.
#>
#>   It's unfortunate that you had such difficulty figuring out 
#>the citation system.
#>
#>Rich
#>
#>-- 
#>Richard B. Shepard, Ph.D.   |  Integrity  
#>  Credibility
#>Applied Ecosystem Services, Inc.|Innovation
#><http://www.appl-ecosys.com> Voice: 503-667-4517  
#>Fax: 503-667-8863
#>___
#>sqlite-users mailing list
#>sqlite-users@sqlite.org
#>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>
#>


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

Re: [sqlite] The SQL Guide to SQLite

2009-07-18 Thread Rich Shepard 
On Sat, 18 Jul 2009, Rick Ratchford wrote:

> All I know is that this is a book. I have a vast library of technical
> books and this is the ONLY one that uses this convention. Even my copy of
> "A New Kind of Science" by Wolfram doesn't use this convention. :-b

   There are many conventions for citations in books, reports, articles, and
other documents that cite original sources. When I was in academia, the
ecological literature (books, papers, etc.) used a (name date) format; e.g.,
(Smith 1962), or (Williams and Jones 1981), or (Foobar et al. 1954). The
bibliography or reference section (and there is a difference between those
two) was arranged in alphabetic order. Many other technical books (including
mine) use a numeric citation, e.g., [20], and the bibliography is numeric
rather than alphabetic. Still other technical documents use the author
abreviation plus two-digit year system which is what you apparently
encountered; e.g., [ORA92] or [SMI01]. They are all common.

   Personally, I like the author/year system because it's explicit and easy
to comprehend without requiring looking at the references section.
Regardless, it's up to the publisher, country, or the practice of a
particular discipline which one is used.

   It's unfortunate that you had such difficulty figuring out the citation
system.

Rich

-- 
Richard B. Shepard, Ph.D.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 Voice: 503-667-4517  Fax: 503-667-8863
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] The SQL Guide to SQLite

2009-07-18 Thread Rick Ratchford 
Perhaps its true that its common in academic papers. I wouldn't know as I've
never read one.

All I know is that this is a book. I have a vast library of technical books
and this is the ONLY one that uses this convention. Even my copy of "A New
Kind of Science" by Wolfram doesn't use this convention. :-b

So seeing it for the first time was very confusing. I flipped through the
last pages and didn't note the one page biblio. That's when I ran it through
'bing' before asking here.

Even doing a 'bing' on "square brackets" suggested they were placeholders
for other information during production. I think some kind of convention
explanation would have been appropriate at the beginning of this book like
most programming books provide rather than assuming everyone is familiar
with conventions used in "academic papers". 

Thanks. 
:-)
Rick

 
 

#>-Original Message-
#>From: sqlite-users-boun...@sqlite.org 
#>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Thomas Briggs
#>Sent: Saturday, July 18, 2009 6:53 PM
#>To: General Discussion of SQLite Database
#>Subject: Re: [sqlite] The SQL Guide to SQLite
#>
#>   That's pretty common in academic papers, actually.
#>
#>   -T
#>
#>
#>On 7/18/09, Rick Ratchford <r...@amazingaccuracy.com> wrote:
#>> Yes. You are correct. That is what they are.
#>>
#>> Thanks for pointing this out. It probably should have been 
#>made clear 
#>> at the beginning of the book since this is not common in 
#>the majority 
#>> of books I own purchased here in the US.
#>>
#>> Thanks again.
#>>
#>> Rick
#>>
#>>
#>> #>-Original Message-
#>> #>From: sqlite-users-boun...@sqlite.org 
#>> #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of 
#>Igor Tandetnik
#>> #>Sent: Saturday, July 18, 2009 10:42 AM
#>> #>To: sqlite-users@sqlite.org
#>> #>Subject: Re: [sqlite] The SQL Guide to SQLite #> #>Rick Ratchford 
#>> wrote:
#>> #>> I just received my copy of the new book "The SQL Guide to 
#>> #>SQLite" by #>> Rick F. van der Lans.
#>> #>>
#>> #>> There are many references within the book that are 
#>#>contained in 
#>> square #>> brackets and some sort of keyword or code.
#>> #>>
#>> #>> Example: "...written about SQLite; see for example [NEWM05] and 
#>> #>> [OWEN06]."
#>> #>
#>> #>These are most likely citations. See if there's a 
#>#>bibliography (a 
#>> list of other books, articles and such) at #>the end of the 
#>book, each 
#>> reference identified by one of these codes.
#>> #>
#>> #>Igor Tandetnik
#>> #>
#>> #>
#>> #>
#>> #>___
#>> #>sqlite-users mailing list
#>> #>sqlite-users@sqlite.org
#>> #>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>> #>
#>> #>
#>>
#>>
#>> ___
#>> sqlite-users mailing list
#>> sqlite-users@sqlite.org
#>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>>
#>
#>--
#>Sent from my mobile device
#>___
#>sqlite-users mailing list
#>sqlite-users@sqlite.org
#>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>
#>


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

Re: [sqlite] The SQL Guide to SQLite

2009-07-18 Thread Thomas Briggs 
   That's pretty common in academic papers, actually.

   -T


On 7/18/09, Rick Ratchford <r...@amazingaccuracy.com> wrote:
> Yes. You are correct. That is what they are.
>
> Thanks for pointing this out. It probably should have been made clear at
> the
> beginning of the book since this is not common in the majority of books I
> own purchased here in the US.
>
> Thanks again.
>
> Rick
>
>
> #>-Original Message-
> #>From: sqlite-users-boun...@sqlite.org
> #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik
> #>Sent: Saturday, July 18, 2009 10:42 AM
> #>To: sqlite-users@sqlite.org
> #>Subject: Re: [sqlite] The SQL Guide to SQLite
> #>
> #>Rick Ratchford wrote:
> #>> I just received my copy of the new book "The SQL Guide to
> #>SQLite" by
> #>> Rick F. van der Lans.
> #>>
> #>> There are many references within the book that are
> #>contained in square
> #>> brackets and some sort of keyword or code.
> #>>
> #>> Example: "...written about SQLite; see for example [NEWM05] and
> #>> [OWEN06]."
> #>
> #>These are most likely citations. See if there's a
> #>bibliography (a list of other books, articles and such) at
> #>the end of the book, each reference identified by one of these codes.
> #>
> #>Igor Tandetnik
> #>
> #>
> #>
> #>___
> #>sqlite-users mailing list
> #>sqlite-users@sqlite.org
> #>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> #>
> #>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>

-- 
Sent from my mobile device
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] The SQL Guide to SQLite

2009-07-18 Thread Rick Ratchford 
Yes. You are correct. That is what they are.

Thanks for pointing this out. It probably should have been made clear at the
beginning of the book since this is not common in the majority of books I
own purchased here in the US.

Thanks again.
 
Rick
 

#>-Original Message-
#>From: sqlite-users-boun...@sqlite.org 
#>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik
#>Sent: Saturday, July 18, 2009 10:42 AM
#>To: sqlite-users@sqlite.org
#>Subject: Re: [sqlite] The SQL Guide to SQLite
#>
#>Rick Ratchford wrote:
#>> I just received my copy of the new book "The SQL Guide to 
#>SQLite" by 
#>> Rick F. van der Lans.
#>>
#>> There are many references within the book that are 
#>contained in square 
#>> brackets and some sort of keyword or code.
#>>
#>> Example: "...written about SQLite; see for example [NEWM05] and 
#>> [OWEN06]."
#>
#>These are most likely citations. See if there's a 
#>bibliography (a list of other books, articles and such) at 
#>the end of the book, each reference identified by one of these codes.
#>
#>Igor Tandetnik 
#>
#>
#>
#>___
#>sqlite-users mailing list
#>sqlite-users@sqlite.org
#>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#>
#>


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

Re: [sqlite] The SQL Guide to SQLite

2009-07-18 Thread Igor Tandetnik 
Rick Ratchford wrote:
> I just received my copy of the new book "The SQL Guide to SQLite" by
> Rick F. van der Lans.
>
> There are many references within the book that are contained in square
> brackets and some sort of keyword or code.
>
> Example: "...written about SQLite; see for example [NEWM05] and
> [OWEN06]."

These are most likely citations. See if there's a bibliography (a list 
of other books, articles and such) at the end of the book, each 
reference identified by one of these codes.

Igor Tandetnik 



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