RE: [sqlite] stupid man's manual to sqlite?
Apress does have an online index they call "superindex" which indexes all Apress books. But I just did some test searches and found it to be equally useless. You can't search a specific book and some searches that obviously should have returned results didn't. In case you have better luck, the URL is here: http://superindex.apress.com/ Sam --- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: A.J.Millan [mailto:[EMAIL PROTECTED] Sent: Saturday, March 10, 2007 6:54 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] stupid man's manual to sqlite? ... On the other hand, besides the mentioned possibility, to put on-line, or in a CD, the index, I believe that equally, an artifice could be included that ... Greetings A. J. Millan ZATOR Systems. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] stupid man's manual to sqlite?
>Removing the index is one of the silliest suggestions I've ever >encountered. A book without an index is almost useless, unless of course >you're blessed with a photographic memory. As far as putting in on a CD >or on the web, that's fine as long as a _good_ index is also included in >the book. I often read books on the subway, train, in a car, etc., where >there is no possibility of access to a CD or the web. Many people I know >have similar reading habits and consequently have no use for this sort >of thing. Certainly I admit that a stupid idea can seem to some superior minds, but then the editors of almost all the novels that I have in my library should be stupid. As almost all in this forum has understood, I am not referring to that index type that can occupy a couple of pages at the end, and that is limited to point out the title of each chapter, but to the exhaustive index of words and terms that appear in this type of technical books; manuals and references that by the way, are not those that usually read the people in the subway or in the bus, but like guide in the desktop. As an example, the work "Win32 Programming" from Brent E. Rector and Joseph M. Newcomer, Addison-Wesley. A "brick" with 1522 pages, those that the index occupies 187 pages of words to three columns per page. The one that can let You pass three years of continuous trips without getting bored. Greetings A.J.Millan ZATOR Systems - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] stupid man's manual to sqlite?
Removing the index is one of the silliest suggestions I've ever encountered. A book without an index is almost useless, unless of course you're blessed with a photographic memory. As far as putting in on a CD or on the web, that's fine as long as a _good_ index is also included in the book. I often read books on the subway, train, in a car, etc., where there is no possibility of access to a CD or the web. Many people I know have similar reading habits and consequently have no use for this sort of thing. -Original Message- From: A.J.Millan [mailto:[EMAIL PROTECTED] Sent: Saturday, March 10, 2007 6:54 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] stupid man's manual to sqlite? >I will get back to you about the index. I also would like to invite >anyone else who has any specific things they would like to see changed >in the index to tell me. Assuming I can get a revised index out >electronically, I will make any such changes immediately to the file I >have on-hand. >-- Mike I have continued thinking of the index matter, and I consider that the possibility to take out it completely in the printed version, or leaving it summarized to a minimum, would have the additional advantage to be able to dedicate more pages to the truly useful things (in the past, I also published some thing, so I have some idea about the editorial world.) On the other hand, besides the mentioned possibility, to put on-line, or in a CD, the index, I believe that equally, an artifice could be included that allow "Google" any word or combination of them (in the case of a CD, the original content could be ciphered to avoid the piracy). As in Google, besides the page and line-number, the result it could include certain quantity of characters around all the matchs-points. For example, say 30 before and 30 later, to give an idea of the context. Beside the utility for the book owners, the potential buyers could check what can wait. It could be a good "hook " to attract possible clients. As I stated before, the same thing for the idea. Please, don't patent it (yes I have some paranoia about patents). Following the Hipp's blessing , and inside my much smaller possibilities, I would like that these ideas remains in the public domain. Greetings A. J. Millan ZATOR Systems. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] stupid man's manual to sqlite?
>I will get back to you about the index. I also would like to invite >anyone else who has any specific things they would like to see changed >in the index to tell me. Assuming I can get a revised index out >electronically, I will make any such changes immediately to the file I >have on-hand. >-- Mike I have continued thinking of the index matter, and I consider that the possibility to take out it completely in the printed version, or leaving it summarized to a minimum, would have the additional advantage to be able to dedicate more pages to the truly useful things (in the past, I also published some thing, so I have some idea about the editorial world.) On the other hand, besides the mentioned possibility, to put on-line, or in a CD, the index, I believe that equally, an artifice could be included that allow "Google" any word or combination of them (in the case of a CD, the original content could be ciphered to avoid the piracy). As in Google, besides the page and line-number, the result it could include certain quantity of characters around all the matchs-points. For example, say 30 before and 30 later, to give an idea of the context. Beside the utility for the book owners, the potential buyers could check what can wait. It could be a good "hook " to attract possible clients. As I stated before, the same thing for the idea. Please, don't patent it (yes I have some paranoia about patents). Following the Hipp's blessing , and inside my much smaller possibilities, I would like that these ideas remains in the public domain. Greetings A. J. Millan ZATOR Systems. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] stupid man's manual to sqlite?
>.For the record, Apress had the index generated by a third party. I've >used the index myself recently, and frankly it worked for me -- I >found what I was looking for. >The SQL and C API references to which you refer --- taken from the >on-line documentation --- start on page 365. Furthermore, the >inclusion of this material was and has been considered useful by >everyone who reviewed the book, as it serves as an authoritative and >succinct reference. Many technical books include a reference similar >to this as a convenience to the reader. >I devoted 100 pages on the subject of SQL. I tried to systematically >and progressively describe SQL so that someone completely unfamiliar >could read the chapter in order, and by the end of the chapter >understand topics such as 3NF, left outer joins, and the intricacies >of NULL. >For an average programmer who needs to use SQLite, I hope this book >can save a lot of time whether you are a unfamiliar to or experienced >with SQL or the SQLite API. I wrote this book purely because I like >SQLite, wanted to help get the word out, and someone presented me with >the opportunity to write a book. Once I decided to write it, I went to >great lengths to write a book that would be genuinely useful. Apress >has put a lot of time and effort into making this a useful book as >well. >As I said in the book, and I think on this list, I am always open to >suggestions and feedback. If you really feel the book has failed you >in some way, or missed an important topic, I would like to know about >it so I can try to make it better should it ever make it to a second >edition. While I have many other things going on in life just like >everybody else, it is important to me that the book serves its >purpose, and I am more than happy to take whatever efforts required to >do so. >-- Mike I wish remark that my message should be interpreted in its context; it is and advise to somebody for what the acquisition of the book can suppose a great economic effort. In other circumstances the advice can be different. Go ahead that, in my case, I have never acquired a book the one that cannot say that I have learned something, or that it didn't contain something valuable that had not found in any other one. I also want to pick up your's offer to add some personal suggestion in this respect (IMHO): * Eliminate the part devoted to the SQL generalities. In my opinion, the buyer of a book whose title is "The Definitive Guide to SQLite", doesn't want an introduction to the SQL; for that there already exist good manuals, even in the Web. In the best case, a chapter dedicated the SQL "peculiarities" of SQLite. * I'm not against cut and paste the SQL reference or the C-API from the on-line manual (it is really a convenience for the reader), but include an example, that can be synthetic and not commented, in each epigraph. This gives true utility. * Say goodbye to the index subcontractor, and as an idea: Why not a mini-CD, or a downloadable file with the index? (editors: thought in that, but please, not patent it, the idea is mine :-)) * More and more and more... code examples Finally, if you wants a gift for the hearing, I will tell You that indeed, I find some parts stupendous. For example, the epigraph "The thing called NULL", or the explanation of the supported data types (Storage Classes; Manifest Typing, and Type Affinity). All the chapter 5 "Design and concepts"; chapter 6, "The Core C API"; chapter 7, "Extension C API", and, of course, the chapter 9 "SQLite internals". These last chapters should be more cared and enlarged, because it is the core of the book. Greetings. A.J.Millán ZATOR Systems. P.D: excuse my English. - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] stupid man's manual to sqlite?
I originally wasn't going to buy the book because according to the TOC it look like it was generally about SQL and the C API and not too much that would be helpful for us being knowledgeable in SQL in general and not using the C API. We did buy it 'cause we're basically betting our new product on SQLite and figured even the 20 pages the TOC says are devoted to SQLite internals are helpful it'd be worthwhile. We've been pleasantly surprised and everything I've read so far has been very helpful. The entire book does focus on SQLite and talks consistently about internals and how things work and optimization specific to SQLite. Even the database section which talks about SQL was helpful as was the C API reference even though we're not using the C API. I do have to agree about the index though--the three times I tried to look something up in the index I couldn't find what I was looking for. I wouldn't base a buying decision on the index though. Best regards, Sam --- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] stupid man's manual to sqlite?
FWIW, excepting the index which is truly terrible, this is one of the better technical books I've encountered. It has certainly been invaluable for me. jim -Original Message- From: Mike Owens [mailto:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 9:16 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] stupid man's manual to sqlite? > More of a half is about SQL generalities, an a quarter a copy-paste of the > on-line manual without more comment. At the end, the horrific index i've > ever seen. For the record, Apress had the index generated by a third party. I've used the index myself recently, and frankly it worked for me -- I found what I was looking for. The SQL and C API references to which you refer --- taken from the on-line documentation --- start on page 365. Furthermore, the inclusion of this material was and has been considered useful by everyone who reviewed the book, as it serves as an authoritative and succinct reference. Many technical books include a reference similar to this as a convenience to the reader. I devoted 100 pages on the subject of SQL. I tried to systematically and progressively describe SQL so that someone completely unfamiliar could read the chapter in order, and by the end of the chapter understand topics such as 3NF, left outer joins, and the intricacies of NULL. For an average programmer who needs to use SQLite, I hope this book can save a lot of time whether you are a unfamiliar to or experienced with SQL or the SQLite API. I wrote this book purely because I like SQLite, wanted to help get the word out, and someone presented me with the opportunity to write a book. Once I decided to write it, I went to great lengths to write a book that would be genuinely useful. Apress has put a lot of time and effort into making this a useful book as well. As I said in the book, and I think on this list, I am always open to suggestions and feedback. If you really feel the book has failed you in some way, or missed an important topic, I would like to know about it so I can try to make it better should it ever make it to a second edition. While I have many other things going on in life just like everybody else, it is important to me that the book serves its purpose, and I am more than happy to take whatever efforts required to do so. -- Mike On 3/8/07, A.J.Millan <[EMAIL PROTECTED]> wrote: > > > > Thank you i will try my possibilities buying from amazon, while i am based > in > > the Czech republic. > > Unfortunately it is little bit expensive for me, to buy it without looking > > into it before. > > Jakub > > I would recommend not to waste your's money in that book. > > More of a half is about SQL generalities, an a quarter a copy-paste of the > on-line manual without more comment. At the end, the horrific index i've > ever seen. > > A.J.Millan > ZATOR Systems. > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > - To unsubscribe, send email to [EMAIL PROTECTED] - NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] stupid man's manual to sqlite?
More of a half is about SQL generalities, an a quarter a copy-paste of the on-line manual without more comment. At the end, the horrific index i've ever seen. For the record, Apress had the index generated by a third party. I've used the index myself recently, and frankly it worked for me -- I found what I was looking for. The SQL and C API references to which you refer --- taken from the on-line documentation --- start on page 365. Furthermore, the inclusion of this material was and has been considered useful by everyone who reviewed the book, as it serves as an authoritative and succinct reference. Many technical books include a reference similar to this as a convenience to the reader. I devoted 100 pages on the subject of SQL. I tried to systematically and progressively describe SQL so that someone completely unfamiliar could read the chapter in order, and by the end of the chapter understand topics such as 3NF, left outer joins, and the intricacies of NULL. For an average programmer who needs to use SQLite, I hope this book can save a lot of time whether you are a unfamiliar to or experienced with SQL or the SQLite API. I wrote this book purely because I like SQLite, wanted to help get the word out, and someone presented me with the opportunity to write a book. Once I decided to write it, I went to great lengths to write a book that would be genuinely useful. Apress has put a lot of time and effort into making this a useful book as well. As I said in the book, and I think on this list, I am always open to suggestions and feedback. If you really feel the book has failed you in some way, or missed an important topic, I would like to know about it so I can try to make it better should it ever make it to a second edition. While I have many other things going on in life just like everybody else, it is important to me that the book serves its purpose, and I am more than happy to take whatever efforts required to do so. -- Mike On 3/8/07, A.J.Millan <[EMAIL PROTECTED]> wrote: > Thank you i will try my possibilities buying from amazon, while i am based in > the Czech republic. > Unfortunately it is little bit expensive for me, to buy it without looking > into it before. > Jakub I would recommend not to waste your's money in that book. More of a half is about SQL generalities, an a quarter a copy-paste of the on-line manual without more comment. At the end, the horrific index i've ever seen. A.J.Millan ZATOR Systems. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] stupid man's manual to sqlite?
Jakub Ladman wrote: I am searching for some "stupid man's manual to sqlite". I can not found any basic's in documentation section of sqlite.org You can try some of the sqlite articles available online: Linux Journal has a couple of articles at http://www.linuxjournal.com/article/7803 and http://www.linuxjournal.com/article/6650. Linux Magazine has an article at http://www.linux-mag.com/id/1484/ (this site requires free registration to access all its content). Or any of the articles located by this google search http://www.google.com/search?q=sqlite+tutorial such as http://freshmeat.net/articles/view/1428/ HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] stupid man's manual to sqlite?
On Thu, 2007-03-08 at 17:43 +0100, A.J.Millan wrote: > > > Thank you i will try my possibilities buying from amazon, while i am based > in > > the Czech republic. > > Unfortunately it is little bit expensive for me, to buy it without looking > > into it before. > > Jakub > > I would recommend not to waste your's money in that book. > > More of a half is about SQL generalities, an a quarter a copy-paste of the > on-line manual without more comment. At the end, the horrific index i've > ever seen. > I have found SQL in a Nutshell very useful over the past 5 years. You might try http://safari.oreilly.com/0596004818 -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
Re: [sqlite] stupid man's manual to sqlite?
> Thank you i will try my possibilities buying from amazon, while i am based in > the Czech republic. > Unfortunately it is little bit expensive for me, to buy it without looking > into it before. > Jakub I would recommend not to waste your's money in that book. More of a half is about SQL generalities, an a quarter a copy-paste of the on-line manual without more comment. At the end, the horrific index i've ever seen. A.J.Millan ZATOR Systems. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] stupid man's manual to sqlite?
Jakub Ladman wrote: Thank you i will try my possibilities buying from amazon, while i am based in the Czech republic. Unfortunately it is little bit expensive for me, to buy it without looking into it before. I don't know if would help, but Apress sell an e-book (PDF) version for about half the cost of the printed version. http://www.apress.com/ecommerce/cart.html?act=add=10130 The printed contains details of how to get a PDF version for $10US, but that's a bit Catch 22 here. ;) Martin - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] stupid man's manual to sqlite?
So i will try it. But what to do before the book will be here? rc = sqlite3_exec(db, argv[2], callback, 0, ); if( rc!=SQLITE_OK ){ fprintf(stderr, "SQL error: %s\n", zErrMsg); sqlite3_free(zErrMsg); } What does the code if argument is 'select * from tbl1'? I see, that the results are printed on the screen, but how to fill variables from the found values for example. Is there some well arranged manual on the internet? Thank you Jakub Dne čtvrtek 08 březen 2007 16:08 Anderson, James H (IT) napsal(a): > You won't be disappointed , it's a terrific book! > > -Original Message- > From: Jakub Ladman [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 08, 2007 9:51 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] stupid man's manual to sqlite? > > Thank you i will try my possibilities buying from amazon, while i am based > in the Czech republic. > Unfortunately it is little bit expensive for me, to buy it without looking > into it before. > Jakub > > Dne čtvrtek 08 březen 2007 15:25 Samuel R. Neff napsal(a): > > I'd suggest Mike Owens book "The Definitive Guid to SQLite". We just > > started working with SQLite and are very impressed by the book. It's a > > very easy read, well written, and covers a ton of details of internals on > > SQLite. There are several chapters with examples on using the C API (as > > well as other language extensions). > > > > http://www.amazon.com/Definitive-Guide-SQLite/dp/1590596730/ref=pd_bbs_sr > >_1 / 002-0953141-3838416 > > > > HTH, > > > > Sam > > > > > > > > --- > > We're Hiring! Seeking a passionate developer to join our team building > > products. Position is in the Washington D.C. metro area. If interested > > contact [EMAIL PROTECTED] > > > > -Original Message- > > From: Jakub Ladman [mailto:[EMAIL PROTECTED] > > Sent: Thursday, March 08, 2007 7:26 AM > > To: sqlite-users@sqlite.org > > Subject: [sqlite] stupid man's manual to sqlite? > > > > Hi (much smarter) friends. > > I need to start with sqlite (interfaced via C language) very quickly, > > unfortunately. > > I have not any experiences with any SQL, only some books. > > I am searching for some "stupid man's manual to sqlite". > > I can not found any basic's in documentation section of sqlite.org > > > > > > - > >-- -- To unsubscribe, send email to [EMAIL PROTECTED] > > - > >-- -- > > --- >-- To unsubscribe, send email to [EMAIL PROTECTED] > --- >-- > > NOTICE: If received in error, please destroy and notify sender. Sender does > not intend to waive confidentiality or privilege. Use of this email is > prohibited when received in error. > > --- >-- To unsubscribe, send email to [EMAIL PROTECTED] > --- >-- - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] stupid man's manual to sqlite?
You won't be disappointed , it's a terrific book! -Original Message- From: Jakub Ladman [mailto:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 9:51 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] stupid man's manual to sqlite? Thank you i will try my possibilities buying from amazon, while i am based in the Czech republic. Unfortunately it is little bit expensive for me, to buy it without looking into it before. Jakub Dne čtvrtek 08 březen 2007 15:25 Samuel R. Neff napsal(a): > I'd suggest Mike Owens book "The Definitive Guid to SQLite". We just > started working with SQLite and are very impressed by the book. It's a > very easy read, well written, and covers a ton of details of internals on > SQLite. There are several chapters with examples on using the C API (as > well as other language extensions). > > http://www.amazon.com/Definitive-Guide-SQLite/dp/1590596730/ref=pd_bbs_sr_1 >/ 002-0953141-3838416 > > HTH, > > Sam > > > > --- > We're Hiring! Seeking a passionate developer to join our team building > products. Position is in the Washington D.C. metro area. If interested > contact [EMAIL PROTECTED] > > -Original Message- > From: Jakub Ladman [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 08, 2007 7:26 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] stupid man's manual to sqlite? > > Hi (much smarter) friends. > I need to start with sqlite (interfaced via C language) very quickly, > unfortunately. > I have not any experiences with any SQL, only some books. > I am searching for some "stupid man's manual to sqlite". > I can not found any basic's in documentation section of sqlite.org > > > --- >-- To unsubscribe, send email to [EMAIL PROTECTED] > --- >-- - To unsubscribe, send email to [EMAIL PROTECTED] - NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] stupid man's manual to sqlite?
I bought the book and I'd recommend it to anyone who was beginning to learn SQL or the Relational Database model as well. It was a very helpful refresher to me. On 3/8/07, Jakub Ladman <[EMAIL PROTECTED]> wrote: Thank you i will try my possibilities buying from amazon, while i am based in the Czech republic. Unfortunately it is little bit expensive for me, to buy it without looking into it before. Jakub Dne čtvrtek 08 březen 2007 15:25 Samuel R. Neff napsal(a): > I'd suggest Mike Owens book "The Definitive Guid to SQLite". We just > started working with SQLite and are very impressed by the book. It's a > very easy read, well written, and covers a ton of details of internals on > SQLite. There are several chapters with examples on using the C API (as > well as other language extensions). > > http://www.amazon.com/Definitive-Guide-SQLite/dp/1590596730/ref=pd_bbs_sr_1 >/ 002-0953141-3838416 > > HTH, > > Sam > > > > --- > We're Hiring! Seeking a passionate developer to join our team building > products. Position is in the Washington D.C. metro area. If interested > contact [EMAIL PROTECTED] > > -Original Message- > From: Jakub Ladman [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 08, 2007 7:26 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] stupid man's manual to sqlite? > > Hi (much smarter) friends. > I need to start with sqlite (interfaced via C language) very quickly, > unfortunately. > I have not any experiences with any SQL, only some books. > I am searching for some "stupid man's manual to sqlite". > I can not found any basic's in documentation section of sqlite.org > > > --- >-- To unsubscribe, send email to [EMAIL PROTECTED] > --- >-- - To unsubscribe, send email to [EMAIL PROTECTED] - -- William F Pearson III
Re: [sqlite] stupid man's manual to sqlite?
Thank you i will try my possibilities buying from amazon, while i am based in the Czech republic. Unfortunately it is little bit expensive for me, to buy it without looking into it before. Jakub Dne čtvrtek 08 březen 2007 15:25 Samuel R. Neff napsal(a): > I'd suggest Mike Owens book "The Definitive Guid to SQLite". We just > started working with SQLite and are very impressed by the book. It's a > very easy read, well written, and covers a ton of details of internals on > SQLite. There are several chapters with examples on using the C API (as > well as other language extensions). > > http://www.amazon.com/Definitive-Guide-SQLite/dp/1590596730/ref=pd_bbs_sr_1 >/ 002-0953141-3838416 > > HTH, > > Sam > > > > --- > We're Hiring! Seeking a passionate developer to join our team building > products. Position is in the Washington D.C. metro area. If interested > contact [EMAIL PROTECTED] > > -Original Message- > From: Jakub Ladman [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 08, 2007 7:26 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] stupid man's manual to sqlite? > > Hi (much smarter) friends. > I need to start with sqlite (interfaced via C language) very quickly, > unfortunately. > I have not any experiences with any SQL, only some books. > I am searching for some "stupid man's manual to sqlite". > I can not found any basic's in documentation section of sqlite.org > > > --- >-- To unsubscribe, send email to [EMAIL PROTECTED] > --- >-- - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] stupid man's manual to sqlite?
I'd suggest Mike Owens book "The Definitive Guid to SQLite". We just started working with SQLite and are very impressed by the book. It's a very easy read, well written, and covers a ton of details of internals on SQLite. There are several chapters with examples on using the C API (as well as other language extensions). http://www.amazon.com/Definitive-Guide-SQLite/dp/1590596730/ref=pd_bbs_sr_1/ 002-0953141-3838416 HTH, Sam --- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Jakub Ladman [mailto:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 7:26 AM To: sqlite-users@sqlite.org Subject: [sqlite] stupid man's manual to sqlite? Hi (much smarter) friends. I need to start with sqlite (interfaced via C language) very quickly, unfortunately. I have not any experiences with any SQL, only some books. I am searching for some "stupid man's manual to sqlite". I can not found any basic's in documentation section of sqlite.org - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] stupid man's manual to sqlite?
Dne čtvrtek 08 březen 2007 13:34 Pavan napsal(a): > Hi Jakub, > > Check this link > http://sqlite.org/quickstart.html > There is a sample program. compile it and run executable in this form > > $./a.out test.db 'create table tbl1(one varchar(10), two smallint)' > $./a.out test.db 'insert into tbl1 values('hello!',10)' > $./a.out test.db 'select * from tbl1' > Thank you, very very very much. Jakub > Thanks, > Pavan. > > On 3/8/07, Jakub Ladman <[EMAIL PROTECTED]> wrote: > > Hi (much smarter) friends. > > I need to start with sqlite (interfaced via C language) very quickly, > > unfortunately. > > I have not any experiences with any SQL, only some books. > > I am searching for some "stupid man's manual to sqlite". > > I can not found any basic's in documentation section of sqlite.org > > > > For example: I do understand this: > > > > $ sqlite3 ex1 > > SQLite version 3.3.10 > > Enter ".help" for instructions > > sqlite> create table tbl1(one varchar(10), two smallint); > > sqlite> insert into tbl1 values('hello!',10); > > sqlite> insert into tbl1 values('goodbye', 20); > > sqlite> select * from tbl1; > > hello!|10 > > goodbye|20 > > sqlite> > > > > > > but not this: > > rc = sqlite3_exec(db, argv[2], callback, 0, ); > > > > What format of the command line argument should i write? > > > > Thank you for any advice. > > > > Jakub Ladman > > > > > > - > > To unsubscribe, send email to [EMAIL PROTECTED] > > > > - > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] stupid man's manual to sqlite?
Oh, wikipedia says " It also serves as an example for writing applications that use the SQLite library." Of course, why do i not get it myself? Jakub Dne čtvrtek 08 březen 2007 13:26 Jakub Ladman napsal(a): > Hi (much smarter) friends. > I need to start with sqlite (interfaced via C language) very quickly, > unfortunately. > I have not any experiences with any SQL, only some books. > I am searching for some "stupid man's manual to sqlite". > I can not found any basic's in documentation section of sqlite.org > > For example: I do understand this: > > $ sqlite3 ex1 > SQLite version 3.3.10 > Enter ".help" for instructions > sqlite> create table tbl1(one varchar(10), two smallint); > sqlite> insert into tbl1 values('hello!',10); > sqlite> insert into tbl1 values('goodbye', 20); > sqlite> select * from tbl1; > hello!|10 > goodbye|20 > sqlite> > > > but not this: > rc = sqlite3_exec(db, argv[2], callback, 0, ); > > What format of the command line argument should i write? > > Thank you for any advice. > > Jakub Ladman > > --- >-- To unsubscribe, send email to [EMAIL PROTECTED] > --- >-- - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] stupid man's manual to sqlite?
Hi Jakub, Check this link http://sqlite.org/quickstart.html There is a sample program. compile it and run executable in this form $./a.out test.db 'create table tbl1(one varchar(10), two smallint)' $./a.out test.db 'insert into tbl1 values('hello!',10)' $./a.out test.db 'select * from tbl1' Thanks, Pavan. On 3/8/07, Jakub Ladman <[EMAIL PROTECTED]> wrote: Hi (much smarter) friends. I need to start with sqlite (interfaced via C language) very quickly, unfortunately. I have not any experiences with any SQL, only some books. I am searching for some "stupid man's manual to sqlite". I can not found any basic's in documentation section of sqlite.org For example: I do understand this: $ sqlite3 ex1 SQLite version 3.3.10 Enter ".help" for instructions sqlite> create table tbl1(one varchar(10), two smallint); sqlite> insert into tbl1 values('hello!',10); sqlite> insert into tbl1 values('goodbye', 20); sqlite> select * from tbl1; hello!|10 goodbye|20 sqlite> but not this: rc = sqlite3_exec(db, argv[2], callback, 0, ); What format of the command line argument should i write? Thank you for any advice. Jakub Ladman - To unsubscribe, send email to [EMAIL PROTECTED] - -- ' Always finish stronger than you start *