Using SQLite covers up to the very last 2.6 version of SQLite. The book went to press about the same time that SQLite 2.7.0 came out. As such, the book does not cover WAL or any of the more resent features. The book only covers the C/C++ APIs, since everything else is based off those.
The primary audience for Using SQLite is experienced developers that have never had to use a relational database before. Much of the book does cover introductory information. As others have said, if you already have database experience and all you need to understand is the basic SQLite-specific APIs, I'm not sure the full book is going to offer much. On the other hand, if you have a more advanced project and need to understand SQLite's locking model in more detail, or understand how virtual tables (or one of the other more advanced features) work, then the book still has something to offer. Amazon.com offers their "Look Inside!" preview of Using SQLite. That should give you a pretty good idea of what information is covered. You can also buy the PDF from oreilly.com for much less then the cost of a printed copy. Let me know if there are any other questions. -j On Dec 30, 2013, at 8:48 PM, Bob Cochran <bcochra...@verizon.net> wrote: > I'm working on a tough project that requires me to use Node.js and SQLite. > I'm building a database with SQLite version 3.8.2. > > My question is, would purchasing the book "Using Sqlite" by Jay Kreibich > still be mostly pertinent to SQLite 3.8.x features? Would it be helpful in > the context how Node.js is used? I realize that Mr. Kreibich was writing the > book and bringing it to publication just as Node.js was being invented in > 2009. > > Does anyone know if this book will be updated? > > Or is there a different book title I should look at? > > Right now, my major difficulties seem to be in my own grasp of asynchronous > programming. It is my own deficient grasp of the logic problems that are > biting me; I need to "get it" and understand Node style programming. An > example is: I need to insert two rows to an SQLite table, but because I'm > using non-blocking interface software to do the actual inserts, and I'm > probably using that software incorrectly, only one insert is being done. > > Thanks > > Bob Cochran > Greenbelt, Maryland, USA > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
