Re: [sqlite] SQL Quick Review/Reference

[Martin Jenkins]

metro wrote:
> is this what everybody is looking for??
> http://booksforpeople.blogspot.com/2008/03/definitive-guide-to-sqlite-free-book.html
> there are other sources  for free ebooks
>
> Laurie
>   
It did the rounds on alt.binaries.e-book.technical last year. The 
buyer's email address had been removed from
the page footers but otherwise it looked like my legit copy, ie it 
wasn't a scan.

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

Re: [sqlite] SQL Quick Review/Reference

[Martin Jenkins]

Mike Owens wrote:
>> Mike Owens wrote:
>>  > I've been lobbying Apress to release the book in electronic form for
>>  > free. 
>>  That seems a bit extreme 
> I wasn't referring to releasing the book as an exclusive solution to
> the index problem, but rather for the community and SQLite in general.
>   
That's fair enough - sorry for the misunderstanding on my part.
> Fixing the index issue would just be a nice dividend. 
Indeed. I've not had any issues with it but I tend to remember roughly 
where things are in books.
I read quickly so I don't mind reading a few extra pages - useful as a 
refresher.
> making it a good book 
I think it's a fine book. I know one or two "occasional" posters on this 
list made some negative
comments (index issues apart) but I think they made a mistake and bought 
the wrong book... ;)

Martin

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

Re: [sqlite] SQL Quick Review/Reference

[Neville Franks]

The book is sitting on a server in China and I would have to assume it
is an illegal copy. Not something folks here should be using.


Tuesday, April 15, 2008, 7:58:03 PM, you wrote:

m> is this what everybody is looking for??
m> 
http://booksforpeople.blogspot.com/2008/03/definitive-guide-to-sqlite-free-book.html
m> there are other sources  for free ebooks

m> Laurie


m> Mike Owens wrote:
>> On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[EMAIL PROTECTED]> wrote:
>>   
>>> Mike Owens wrote:
>>>  > I've been lobbying Apress to release the book in electronic form for
>>>  > free. It's currently under consideration, but I've not heard anything
>>>  > back yet.
>>>  >
>>>  That seems a bit extreme - how about a user generated/funded index on
>>>  the web somewhere?
>>>  Download and print a PDF, stick it in the back of the book and...
>>> 
>>
>> I wasn't referring to releasing the book as an exclusive solution to
>> the index problem, but rather for the community and SQLite in general.
>> Fixing the index issue would just be a nice dividend. I am indebted to
>> Apress for picking up the book and putting substantial resources into
>> making it a good book (they truly made it a much better book than it
>> ever would have been otherwise), and I would like to see them recoup
>> their costs and benefit in any way they so desire. But I couldn't care
>> less for any gain on my part. I wrote the book for SQLite. Don't get
>> me wrong, I jumped at the chance to write a book when offered to me,
>> but my main concern is that the book helps people and furthers the
>> project. As long as I can avoid getting vilified on Amazon, I'm happy.
>> Ultimately, I would love to see this book turn out like the "Dive Into
>> Python" book, which is available online, or the
>> Subversion/Samba/Asterisk books. I think it is in keeping with the
>> open source philosophy. But the decision in this case is not mine
>> alone to make. Regardless of their decision, I applaud Apress for
>> their continued efforts in supporting books on open source software,
>> and the people who reward their efforts by purchasing them.
>>
>> -- Mike
>>
>> On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[EMAIL PROTECTED]> wrote:
>>   
>>> Mike Owens wrote:
>>>  > I've been lobbying Apress to release the book in electronic form for
>>>  > free. It's currently under consideration, but I've not heard anything
>>>  > back yet.
>>>  >
>>>  That seems a bit extreme - how about a user generated/funded index on
>>>  the web somewhere?
>>>  Download and print a PDF, stick it in the back of the book and...
>>>
>>>  Martin
>>>
>>>
>>> ___
>>>  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
>>
>>   

m> ___
m> sqlite-users mailing list
m> sqlite-users@sqlite.org
m> 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] SQL Quick Review/Reference

[metro]

is this what everybody is looking for??
http://booksforpeople.blogspot.com/2008/03/definitive-guide-to-sqlite-free-book.html
there are other sources  for free ebooks

Laurie


Mike Owens wrote:
> On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[EMAIL PROTECTED]> wrote:
>   
>> Mike Owens wrote:
>>  > I've been lobbying Apress to release the book in electronic form for
>>  > free. It's currently under consideration, but I've not heard anything
>>  > back yet.
>>  >
>>  That seems a bit extreme - how about a user generated/funded index on
>>  the web somewhere?
>>  Download and print a PDF, stick it in the back of the book and...
>> 
>
> I wasn't referring to releasing the book as an exclusive solution to
> the index problem, but rather for the community and SQLite in general.
> Fixing the index issue would just be a nice dividend. I am indebted to
> Apress for picking up the book and putting substantial resources into
> making it a good book (they truly made it a much better book than it
> ever would have been otherwise), and I would like to see them recoup
> their costs and benefit in any way they so desire. But I couldn't care
> less for any gain on my part. I wrote the book for SQLite. Don't get
> me wrong, I jumped at the chance to write a book when offered to me,
> but my main concern is that the book helps people and furthers the
> project. As long as I can avoid getting vilified on Amazon, I'm happy.
> Ultimately, I would love to see this book turn out like the "Dive Into
> Python" book, which is available online, or the
> Subversion/Samba/Asterisk books. I think it is in keeping with the
> open source philosophy. But the decision in this case is not mine
> alone to make. Regardless of their decision, I applaud Apress for
> their continued efforts in supporting books on open source software,
> and the people who reward their efforts by purchasing them.
>
> -- Mike
>
> On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[EMAIL PROTECTED]> wrote:
>   
>> Mike Owens wrote:
>>  > I've been lobbying Apress to release the book in electronic form for
>>  > free. It's currently under consideration, but I've not heard anything
>>  > back yet.
>>  >
>>  That seems a bit extreme - how about a user generated/funded index on
>>  the web somewhere?
>>  Download and print a PDF, stick it in the back of the book and...
>>
>>  Martin
>>
>>
>> ___
>>  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] SQL Quick Review/Reference

[Mike Owens]

On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[EMAIL PROTECTED]> wrote:
> Mike Owens wrote:
>  > I've been lobbying Apress to release the book in electronic form for
>  > free. It's currently under consideration, but I've not heard anything
>  > back yet.
>  >
>  That seems a bit extreme - how about a user generated/funded index on
>  the web somewhere?
>  Download and print a PDF, stick it in the back of the book and...

I wasn't referring to releasing the book as an exclusive solution to
the index problem, but rather for the community and SQLite in general.
Fixing the index issue would just be a nice dividend. I am indebted to
Apress for picking up the book and putting substantial resources into
making it a good book (they truly made it a much better book than it
ever would have been otherwise), and I would like to see them recoup
their costs and benefit in any way they so desire. But I couldn't care
less for any gain on my part. I wrote the book for SQLite. Don't get
me wrong, I jumped at the chance to write a book when offered to me,
but my main concern is that the book helps people and furthers the
project. As long as I can avoid getting vilified on Amazon, I'm happy.
Ultimately, I would love to see this book turn out like the "Dive Into
Python" book, which is available online, or the
Subversion/Samba/Asterisk books. I think it is in keeping with the
open source philosophy. But the decision in this case is not mine
alone to make. Regardless of their decision, I applaud Apress for
their continued efforts in supporting books on open source software,
and the people who reward their efforts by purchasing them.

-- Mike

On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[EMAIL PROTECTED]> wrote:
> Mike Owens wrote:
>  > I've been lobbying Apress to release the book in electronic form for
>  > free. It's currently under consideration, but I've not heard anything
>  > back yet.
>  >
>  That seems a bit extreme - how about a user generated/funded index on
>  the web somewhere?
>  Download and print a PDF, stick it in the back of the book and...
>
>  Martin
>
>
> ___
>  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] SQL Quick Review/Reference

[Martin Jenkins]

Mike Owens wrote:
> I've been lobbying Apress to release the book in electronic form for
> free. It's currently under consideration, but I've not heard anything
> back yet.
>   
That seems a bit extreme - how about a user generated/funded index on 
the web somewhere?
Download and print a PDF, stick it in the back of the book and...

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

Re: [sqlite] SQL Quick Review/Reference

[Rich Shepard]

On Mon, 14 Apr 2008, Mike Owens wrote:

> I know I've said this before, but I just want to say it again because it
> pains me that the index is so bad: I had absolutely nothing to do with the
> index. While I was presented with the index to look over, I only had about
> a day to provide any feedback and there were so many other deadlines
> looming that I really only had about 30 minutes to "read" the index.

Mike,

   I'm certainly not blaming you!

> I've been lobbying Apress to release the book in electronic form for free.
> It's currently under consideration, but I've not heard anything back yet.

   Well, since I've purchased both the dead tree and digital versions, that
won't help me.

   I wrote my book in LaTeX (using the LyX GUI front end which is highly
productive), and used the indexing feature to create the index. Before doing
so, I researched how to write an index, bought a book on the subject, and
read that before starting. It did take me several iterations before I was
satisfied, and I'm sure there are still deficiencies I did not catch.

   Putting out a supplemental index would be a very useful effort.

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] SQL Quick Review/Reference

[ajm]

Mike:

As a purchaser of your Book, I think that perhaps you can have a copy of the 
book in plain text form.
Then, with a little effort can be made a index of words, and (also) perhaps it 
would be easier that Apress let you publish it.

In respect to the index creation I would help in that.

Adolfo.-Original Message-
From: Mike Owens [mailto:[EMAIL PROTECTED]
Sent: Monday, April 14, 2008 08:23 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] SQL Quick Review/Reference

I've been lobbying Apress to release the book in electronic form forfree.
It's currently under consideration, but I've not heard anythingback yet.
 Mike
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Quick Review/Reference

[Mike Owens]

On Sat, Apr 12, 2008 at 9:36 AM, Rich Shepard <[EMAIL PROTECTED]> wrote:
> On Fri, 11 Apr 2008, Amit Uttamchandani wrote:

>I second the recommendation of Mike Owens' "The Definitive Guide to
>  SQLite" for detailed insight on this system. And it does have the worst
>  index of any technical book. (I wrote to the publisher about it but never
>  received any reply.)

I know I've said this before, but I just want to say it again because
it pains me that the index is so bad: I had absolutely nothing to do
with the index. While I was presented with the index to look over, I
only had about a day to provide any feedback and there were so many
other deadlines looming that I really only had about 30 minutes to
"read" the index.

I've been lobbying Apress to release the book in electronic form for
free. It's currently under consideration, but I've not heard anything
back yet.

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

Re: [sqlite] SQL Quick Review/Reference

[Clay Dowling]

Amit Uttamchandani wrote:

>> I also purchased "Beginning Database Design - from Novice to
>> Professional" by Clare Churcher, but found it to much of a beginners
>> book for my needs.

Let me recommend SQL For Smarties as an excellent starting point.  The
book is perfectly suitable for beginners, but can take you all the way
to very advanced topics.  Probably one of the best computer books I have
purchased.

This isn't an SQLite specific book, by the way.  It's fairly generic, so
what you learn here will work elsewhere.

Clay Dowling
http://www.lazarusid.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Quick Review/Reference

[Amit Uttamchandani]

On Sat, 12 Apr 2008 17:23:55 +1000
Neville Franks <[EMAIL PROTECTED]> wrote:

> For SQLite in particular "The Definitive Guide to SQLite" by Micahel
> Owens is reasonably good. Unfortunately it has the worst index of any
> book I can recall seeing, other than some Cook Books. This makes it
> very difficult and frustrating to use as a Reference Book.
> 
> I also purchased "Beginning Database Design - from Novice to
> Professional" by Clare Churcher, but found it to much of a beginners
> book for my needs.
> 
> 

Thanks! This is exactly what I was looking for.

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

Re: [sqlite] SQL Quick Review/Reference

[Amit Uttamchandani]

On Sat, 12 Apr 2008 10:40:43 -0400
"P Kishor" <[EMAIL PROTECTED]> wrote:

> On 4/12/08, Amit Uttamchandani <[EMAIL PROTECTED]> wrote:
> > Hey everyone,
> >
> >  Just got back into the world of SQL after being away for 5 years. This 
> > time I decided to jump in with SQLite. It really has me excited.
> >
> >  Anyways, I have done a lot database work but I seem to have forgotten a 
> > lot of the subtleties of database designs/schema.
> >
> >  I am wondering if any of you have been in a similar situation? Is there a 
> > set of documents/notes that you refer to? Something that covers SQL and 
> > database design in general?
> >
> >  For example, for Python I refer to "A Byte of Python" and for LaTex there 
> > is "The Not So Short Introduction to LaTeX." Something similar for SQL is 
> > what I am looking for.
> >
> >  I've googled around but I thought why not ask the SQL veterans here?
> >
> 
> 
> nothing against the other suggestions, but have you really Googled?
> Lookee what I found
> 
> http://www.google.com/search?q=sql+tutorial
> 
> Honestly, there must be a bazillion SQL tutorials out there many of
> which provide quite a good intro to the basic concepts. Try a few of
> them.

Thanks for the reply.

Yes, I googled using similar search terms that you gave and found a lot of 
resources. I read up on them but I just wanted an opinion from some of the 
users here. I never owned a SQL reference material before...so some of the 
recommendations definitely helped a lot.

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

Re: [sqlite] SQL Quick Review/Reference

[Rich Shepard]

On Sat, 12 Apr 2008, Jay A. Kreibich wrote:

>  I purchased the hardback of this book some months ago only to discover
>  the PDF version some weeks later.  In the end, I ended up buying them
>  both.

Jay,

   I have both, too. Yes, using the find function within xpdf does compensate
for the lack of index and I keep the digital version on my notebook for use
when I'm traveling. I still refer to the paper edition frequently here in
the office.

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] SQL Quick Review/Reference

[P Kishor]

On 4/12/08, Amit Uttamchandani <[EMAIL PROTECTED]> wrote:
> Hey everyone,
>
>  Just got back into the world of SQL after being away for 5 years. This time 
> I decided to jump in with SQLite. It really has me excited.
>
>  Anyways, I have done a lot database work but I seem to have forgotten a lot 
> of the subtleties of database designs/schema.
>
>  I am wondering if any of you have been in a similar situation? Is there a 
> set of documents/notes that you refer to? Something that covers SQL and 
> database design in general?
>
>  For example, for Python I refer to "A Byte of Python" and for LaTex there is 
> "The Not So Short Introduction to LaTeX." Something similar for SQL is what I 
> am looking for.
>
>  I've googled around but I thought why not ask the SQL veterans here?
>


nothing against the other suggestions, but have you really Googled?
Lookee what I found

http://www.google.com/search?q=sql+tutorial

Honestly, there must be a bazillion SQL tutorials out there many of
which provide quite a good intro to the basic concepts. Try a few of
them.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Quick Review/Reference

[Jay A. Kreibich]

On Sat, Apr 12, 2008 at 05:23:55PM +1000, Neville Franks scratched on the wall:
> For SQLite in particular "The Definitive Guide to SQLite" by Micahel
> Owens is reasonably good. Unfortunately it has the worst index of any
> book I can recall seeing, other than some Cook Books. This makes it
> very difficult and frustrating to use as a Reference Book.

  It is, however, available on the Apress website in PDF format for 30%
  off the cover price.  A good PDF viewer with listed search results is
  almost better than an index.

  I purchased the hardback of this book some months ago only to
  discover the PDF version some weeks later.  In the end, I ended up
  buying them both.

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"'People who live in bamboo houses should not throw pandas.' Jesus said that."
   - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006"
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Quick Review/Reference

[Rich Shepard]

On Fri, 11 Apr 2008, Amit Uttamchandani wrote:

> Is there a set of documents/notes that you refer to? Something that covers
> SQL and database design in general?

Amit,

   I second the recommendation of Mike Owens' "The Definitive Guide to
SQLite" for detailed insight on this system. And it does have the worst
index of any technical book. (I wrote to the publisher about it but never
received any reply.)

   Now, for general information, nothing beats Rick F. van der Lans'
"Introduction to SQL, 4th Ed." He includes coverage of time-based database
applications (which applies to most business needs) which is not covered in
other books.

   Also, anything written by Joe Celko is worth reading and owning. The
latest edition of "SQL for Smarties" is very useful, as is his "SQL
Programming Style." He has a couple of other titles out, but they're not
applicable to my needs so I don't have them. Joe's been writing and teaching
about dbms for at least 25 years; I remember reading his columns in the mid-
to late-1980s.

HTH,

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] SQL Quick Review/Reference

[Neville Franks]

For SQLite in particular "The Definitive Guide to SQLite" by Micahel
Owens is reasonably good. Unfortunately it has the worst index of any
book I can recall seeing, other than some Cook Books. This makes it
very difficult and frustrating to use as a Reference Book.

I also purchased "Beginning Database Design - from Novice to
Professional" by Clare Churcher, but found it to much of a beginners
book for my needs.


Saturday, April 12, 2008, 3:23:10 PM, you wrote:

AU> Hey everyone,

AU> Just got back into the world of SQL after being away for 5
AU> years. This time I decided to jump in with SQLite. It really has
AU> me excited.

AU> Anyways, I have done a lot database work but I seem to have
AU> forgotten a lot of the subtleties of database designs/schema.

AU> I am wondering if any of you have been in a similar
AU> situation? Is there a set of documents/notes that you refer to?
AU> Something that covers SQL and database design in general?

AU> For example, for Python I refer to "A Byte of Python" and for
AU> LaTex there is "The Not So Short Introduction to LaTeX." Something
AU> similar for SQL is what I am looking for.

AU> I've googled around but I thought why not ask the SQL veterans here?

AU> Thanks,
AU> Amit
AU> ___
AU> sqlite-users mailing list
AU> sqlite-users@sqlite.org
AU> 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