I'm sorry if this reply seems jumbled - I wrote the middle bit (about the sugested content) after the bits above and below it.
Jay A. Kreibich wrote: > On Sat, Apr 19, 2008 at 05:40:45PM +0100, Toby Roworth scratched on the wall: > >> mikeobe wrote: >> >>> i found it boring to learn how to use sqlite, maybe we can write a >>> tutorial for it, with examples, it will be much easier for the >>> beginner to start with sqlite. >>> >> Agreed - I had to learn from the 5 minute introduction (which I was >> later told was a poor way of doing it), and then by using the reference, >> which leaves a lot to be desired when it comes to having little >> knowledge of SQLite - and it's still giving me trouble now! >> > > What are we looking for? A 60 minute introduction? > > Any thoughts on specific topics, or is the main thing just > covering the basics of the API in vanilla situations? > I think that's exactly what we need - how to run a SQL statement and return/print the results. A brief explanation of: sqlite3_open_v2() sqlite3_prepare_v2() sqlite3_step() sqlite3_finalize() sqlite3_close() and any other important ones might be nice, in slightly more friendlier terms then the API reference, then an example thet puts them toggether. > I have a great deal of interest in this area, and would love to hear > from anyone that has thoughts, ideas, or comments. I would > especially like to hear if there is a specific area or concept that > confused folks when they were learning SQLite. > Ideally, the tutorial would allow someone who has very limited/no database knowledge to be able to use SQLite in a simple application, EG an address book: 1: Database design (in sqlite3 program?) (creating the table containing name, address, telehone) 2: queries to run (finding all people living at an address, finding someone's phone number, possible annother) 3: The above bit - run down of frequently used functions 4: putting it all toggether into a C program 5: code listing (could be in 4) I think something along these lines could work weel, as long as it is well written > SQLite tends to get used by a lot of people that have a stronger > background in software development than in databases, so I would > expect there to be some confusion about "database things" like table > design and complex query commands. Solid introductory materials need > to take that into account, but we need to gather some more > information on precisely what that difference means. > Should a separate SQL/databases introduction be available - this could be quite useful, but would it be duplicating what's already available elsewhere (see above point) > > This is a bit off-topic for the mailing list, so please feel free > to send stuff directly to the address below. > > -j > > > -- ------------------------------------------------------------------------ Sent by Toby Roworth ([EMAIL PROTECTED]) This message is intended for the named reciepients only, and should not be forwarded without permission The conents of this message may be ©Toby Roworth _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
