Re: [sqlite] a suggestion to write tutorial for sqlite
D. Richard Hipp wrote: > FWIW, I'll be happy to give write access to the documentation > repository (http://www.sqlite.org/docsrc/) and even a > prestigious "sqlite.org" email alias to anybody who is > willing to step up and make some improvements and > updates to the current documentation. > > D. Richard Hipp > [EMAIL PROTECTED] > > > As I haven't been using SQLite for very long, although I can't write the documentation, I'm happy to read through drafts and give pointers to what might need to be changed - I'm probably still at the stage where I need to read something like this, so I could quite happily be a "test candidate" if it helps. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > -- -------- 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
Re: [sqlite] a suggestion to write tutorial for sqlite
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
Re: [sqlite] a suggestion to write tutorial for 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! Toby 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. > > 2008-04-19 > mikeobe > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > -- ---- 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
Re: [sqlite] no VFS error
Thanks - that seems to have fixed it D. Richard Hipp wrote: > On Apr 19, 2008, at 9:19 AM, Toby Roworth wrote: > >>> What value are you passing as the 4th argument to >>> sqlite3_open_v2()? (I assume you are using sqlite3_open_v2() >>> since that seems the mostly likely way to get this error.) >>> >>> >> I'm passing a blank string - this would appear to be the problem! >> errorCode = sqlite3_open_v2("data/texts.db", , >> SQLITE_OPEN_READONLY, ""); >> >> > > A null pointer (aka zero). 0. Very different from an > empty string. > > D. Richard Hipp > [EMAIL PROTECTED] > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > -- 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
Re: [sqlite] no VFS error
D. Richard Hipp wrote: > On Apr 19, 2008, at 7:41 AM, Toby Roworth wrote: > > >> When attempting to open a database, I am getting a "no such vfs" >> error. >> >> What is likely to be causing this - a quick search suggested that vfs >> may stand for virtual file system - is this right? >> >> Any help would be appreciated >> >> > > > What value are you passing as the 4th argument to > sqlite3_open_v2()? (I assume you are using sqlite3_open_v2() > since that seems the mostly likely way to get this error.) > I'm passing a blank string - this would appear to be the problem! errorCode = sqlite3_open_v2("data/texts.db", , SQLITE_OPEN_READONLY, ""); What shoudl I be passing (on a windows system) Thanks > D. Richard Hipp > [EMAIL PROTECTED] > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > -- 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
[sqlite] no VFS error
When attempting to open a database, I am getting a "no such vfs" error. What is likely to be causing this - a quick search suggested that vfs may stand for virtual file system - is this right? Any help would be appreciated Toby Roworth -- ---- 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
Re: [sqlite] C++ API callback problem
Thanks Igor and Teg, I think I know were I was going wrong now. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] C++ API callback problem
Hello all Looking at the API reference. it would apear you can send an extra "custom" argument to the callback fro sqlite3_exec, using the 4th parameter - how does this work, and inperticular, could I pass an object through to the call back, and if so, how? Thanks Toby ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] C++ api - callbacks problem
Hello all Looking at the API reference. it would apear you can send an extra "custom" argument to the callback fro sqlite3_exec, using the 4th parameter - how does this work, and inperticular, could I pass an object through to the call back, and if so, how? Thanks Toby ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] C++ api - callbacks problem
Hello all Looking at the API reference. it would apear you can send an extra "custom" argument to the callback fro sqlite3_exec, using the 4th parameter - how does this work, and inperticular, could I pass an object through to the call back, and if so, how? Thanks Toby ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] C++ api - callbacks problem
Hello all Looking at the API reference. it would apear you can send an extra "custom" argument to the callback fro sqlite3_exec, using the 4th parameter - how does this work, and inperticular, could I pass an object through to the call back, and if so, how? Thanks Toby ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Most widely deployed?
Aristotle Pagaltzis wrote: > * Shawn Wilsher <[EMAIL PROTECTED]> [2008-02-21 20:00]: > >>> Every copy of Firefox 3 contains a copy of SQLite. >>> >> And Firefox 2 ;) >> > > Really? What is it used for? > > Regards, > Apparently it's used for storing profile information in Firefox 2, and Firefox 3 uses it for storing history/bookmarks (it was reading about this that first alerted me to SQLite's existence) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Most widely deployed?
Bryan Oakley wrote: > On Feb 20, 2008 7:41 AM, Toby Roworth <[EMAIL PROTECTED]> wrote: > >> Oracle has deployment contracts in the govornments of X countries >> worldwide, each having Y department, which have Z number of databases >> each... >> > > I would think the number of MacOSX installations would outnumber the > Oracle installations of the world, wouldn't it? I'm just guessing > here, but with the cost of Oracle being so high, and there being > millions of Macintoshes out in the wild... > > It wouldn't surpise me to learn sqlite was on the ipod or iphone too, > though I haven't heard definitely one way or the other. > > And of course there is Solaris. And symbian cell phones. > > And if you count a large percentage of windows systems in the wild > that use McAfee virus protection which reportedly uses sqlite and add > it all up, you're approaching a *very* large number of deployments. > > Do you really think Oracle can match all that? > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > I'm not disputing whether it is the mist widely used SQL database - I was merely disputing the fact that there are only 100 million other databases in use worldwide. I completely agree with you that there is a very large number of deployments, and that oracle probably has nowhere near as many. I just wanted to point out this flaw in the logic, so that it could possibly be rectified before someone in a better poition to criticise the statement does so. Hope this makes sense Toby ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Most widely deployed?
Geoff Lane wrote: > On Wed, Feb 20, 2008 at 01:41:50PM +0000, Toby Roworth wrote: > >> I'm not trying to be picky here, or start telling you that you're wrong, >> but it could be worth changing - if an oracle developer (etc) were to >> look at the page, the could potentially have a field day when they can >> point out something like: >> > > It is just a list of estimates. > Indeed, it does state that clearly. I just feel it could potentially damage the image of SQlite to have a fact stated on the front page that, when looked into, is based on what could be considered flawed logic, as it seems an unfair comparison. I've seen people get very aggressive on these matters (Adobe on the Prism page on mozilla labs, for example). > The list does omit about 10 million Solaris 10 installations. Solaris 10 > uses sqlite to manage parts of the package and patch installation process. > > I use sqlite in shell scripts (I guess many others also do so) and so sqlite > will rapidly get installed on any new computer I look after, if it is not > already there. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Most widely deployed?
I was just reading the page about SQlite being the most widely deployed SQL database engine (http://sqlite.org/mostdeployed.html), and noticed that it does not seem to take into account non-website non-sqlite database engines in the arbitrary 100million other database engines. I'm not trying to be picky here, or start telling you that you're wrong, but it could be worth changing - if an oracle developer (etc) were to look at the page, the could potentially have a field day when they can point out something like: Oracle has deployment contracts in the govornments of X countries worldwide, each having Y department, which have Z number of databases each... Like I said, *I* am not trying to dispute this claim, but merely point out a place where others may, and thus should maybe be looked at. I'm not sure if this was the right place to post this, but it would be interesting to hear people's thoughts on the matter. Toby ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Finding table names
I'm using the C++ API (although I'm not sure this matters), and need the names of all the tables I've put in the database (user tables?). From a quick google, it would appear I might need to use system tables or something like this, but I'm not too sure how to do this. Sorry if I sent this twice Any help would be appreciated Toby Roworth ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users