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