[sqlite] SQLite training/meet-up opportunities in Eindhoven and Berlin
Hi Dr. Hipp: Any plans to visit San Francisco? -Original Message- From: Richard Hipp To: General Discussion of SQLite Database Sent: Wed, Apr 20, 2016 10:21 am Subject: [sqlite] SQLite training/meet-up opportunities in Eindhoven and Berlin There will be an opportunity to meet some of the developers of SQLite in Eindhoven on 2016-06-24 and in Berlin on 2016-06-27. This can be a free public lecture on SQLite or related topics, or just an informal get-together over coffee. Private training sessions and/or briefings are also available to companies for a modest fee. Paid appearances can be more flexible with regard to dates and locations. I (Richard Hipp, the original creator of SQLite) will be at both locations. Dan Kennedy (the principal author of the FTS extensions, ZIPVFS, RBU, sessions, etc.) will be at Berlin. If you would like to set something up, please contact me directly at the email below. But please hurry: We will be purchasing our non-refundable tickets soon. -- D. Richard Hipp drh at sqlite.org ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite training/meet-up opportunities in Eindhoven and Berlin
2016-04-20 19:21 GMT+02:00 Richard Hipp : > There will be an opportunity to meet some of the developers of SQLite > in Eindhoven on 2016-06-24 and in Berlin on 2016-06-27. This can be a > free public lecture on SQLite or related topics, or just an informal > get-together over coffee. > ?I would be interested in the public lecture in Eindhoven. -- Cecil Westerhof
[sqlite] SQLite training/meet-up opportunities in Eindhoven and Berlin
There will be an opportunity to meet some of the developers of SQLite in Eindhoven on 2016-06-24 and in Berlin on 2016-06-27. This can be a free public lecture on SQLite or related topics, or just an informal get-together over coffee. Private training sessions and/or briefings are also available to companies for a modest fee. Paid appearances can be more flexible with regard to dates and locations. I (Richard Hipp, the original creator of SQLite) will be at both locations. Dan Kennedy (the principal author of the FTS extensions, ZIPVFS, RBU, sessions, etc.) will be at Berlin. If you would like to set something up, please contact me directly at the email below. But please hurry: We will be purchasing our non-refundable tickets soon. -- D. Richard Hipp drh at sqlite.org
Re: [sqlite] SQLite Training
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rich Shepard wrote: >That's very true, but it's still the best overall introduction to SQLite. The book claims to be a definitive guide, not an introduction :-) >Almost no book on a particular software application remains current. This is usually addressed by coming out with new editions, pointing to the author website for updates or at least some sort of "teach a man to fish" material such as how to use the website and mailing lists (eg SQLite developer vs user activities, bug tracker, utility of release notes, what being open source means and how progress is made, wikis, FAQs etc). >I actually bought my copy in 2006 and found it answered many questions for > me. Still does. Indeed. I have it open on my desk in front of me :-) Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkthPAoACgkQmOOfHg372QTquQCfTZEQx4TJxHVGDw/EzzQuJusk YWYAnjKxAspn/LvMZfpCyqRGxtiKEQFo =2l/a -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Training
On Wed, 27 Jan 2010, Roger Binns wrote: > The main drawback is that the book hasn't been revised since 2006 since > when the virtual machine has changed, foreign key support is present, you > can use threading freely, there is incremental Blob I/O, virtual tables > are available, VFS is available, backup API is available etc so the book > is no longer definitive! Roger, That's very true, but it's still the best overall introduction to SQLite. Almost no book on a particular software application remains current. Too often the book is based on a software version that has been replaced by the time the book makes it out of the manufacturing process. The fundamentals are usually still valid, however. I actually bought my copy in 2006 and found it answered many questions for me. Still does. Rich ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Training
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Simon Slavin wrote: > Excellent. I must check out a copy. You may find my review useful: http://www.rogerbinns.com/sqlitereview.html The main drawback is that the book hasn't been revised since 2006 since when the virtual machine has changed, foreign key support is present, you can use threading freely, there is incremental Blob I/O, virtual tables are available, VFS is available, backup API is available etc so the book is no longer definitive! Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAktg88cACgkQmOOfHg372QROHQCdGF8b0gFPyr3IqLr5DZE7ZW+q ZiIAoMYRqDaOfDrw0WHOSbR1s/cwAbqa =P77k -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Training
On 28 Jan 2010, at 2:04am, Roger Binns wrote: > Simon Slavin wrote: >> ... but that requires that you understand at least a bit of relational >> databases theory. > > Mike Owen's book does that well. There are 26 pages covering the relational > model before SQL is introduced. Excellent. I must check out a copy. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Training
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Simon Slavin wrote: > ... but that requires that you understand at least a bit of relational > databases theory. Mike Owen's book does that well. There are 26 pages covering the relational model before SQL is introduced. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAktg8LEACgkQmOOfHg372QQKWgCfYBJYhuncut+UWTxscFIcj2dT +D8Ani6IiBy576jqEKtU8yD/QuRP3nLB =/2Hd -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Training
On Thu, 28 Jan 2010, Simon Slavin wrote: > ... but that requires that you understand at least a bit of relational > databases theory. We've recently had questions from people who don't > understand an INDEX, or what you would want one, or how to make one which > is useful for a particular query. So I guess the lowest rung on learning > SQLite is something like "What is a relational database ?". > Sorry, a little hobby-horse of mine. Simon, You'll find no disagreement here. I've seen too many "databases" that are flat-field because the creators have no idea on how to build a relational database by normalizing data. However, that's not specific to SQLite. There are many Web sites that can provide a good introduction. Google will turn them up. I will make the same argument about statistical software, particularly GIS for spatial analyses. Just because you teach someone how to use a word processor does not make her a writer. Holds true for any technical tool: if you don't know how to properly use the tool you can hurt yourself. Rich ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Training
On 28 Jan 2010, at 1:03am, Rich Shepard wrote: > All you need is to know SQL well ... but that requires that you understand at least a bit of relational databases theory. We've recently had questions from people who don't understand an INDEX, or what you would want one, or how to make one which is useful for a particular query. So I guess the lowest rung on learning SQLite is something like "What is a relational database ?". Sorry, a little hobby-horse of mine. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Training
On Thu, 28 Jan 2010, nyetngoh wong wrote: > I'm currently working on a project that uses SQLite and would like to know > if there is any SQLite certification available in Singapore. Do you > provide any forms of technical training or courses on using SQLite > efficiently ? All you need is to know SQL well. I'll recommend two books. 1) Michael Owens. 2006. "The Definitive Guide to SQLite." Apress. An excellent reference to the specifics of SQLite. 2) Rick F. van der Lans. 2009. "The SQL Guide to SQLite." Lulu. An excellent tutorial and reference on SQL as implemented in SQLite. In addition, feel free to post specific questions here. Rich ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite Training
Hi, I'm currently working on a project that uses SQLite and would like to know if there is any SQLite certification available in Singapore. Do you provide any forms of technical training or courses on using SQLite efficiently ? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
