Re: [sqlite] i have a few Qs - sqlite3
On 7/8/06, Martin Jenkins <[EMAIL PROTECTED]> wrote: Nuno Lucas wrote: > Please don't feed the troll... Well, I have to add my two cents here. I've been following this thread and alot of people have been generous enough to the troll. I think its nice to see a community such as this that is generous with time and clues. However, I've seen some responses from the person that asked this initially and I say Troll is putting it nicely. Thumbs up to the SQLite community as a whole and also open source in general.
Re: [sqlite] i have a few Qs - sqlite3
Apologies to the rest of the list, but I've had one of those days. ;) mj
Re: [sqlite] i have a few Qs - sqlite3
Nuno Lucas wrote: Please don't feed the troll... ;)
Re: [sqlite] i have a few Qs - sqlite3
353455 453455 wrote: excuse me?. do you really think this is my homework and that i want someone like him to do it for me?. I didn't earlier, but it seems obvious now because you're clearly not capable of it. Like most of the others here I learned things the hard way, by working them out for myself. Of course that takes time, a bit determination and some intelligence. I know how difficult it is for people that don't have those skills - I helped quite a few of them through college. i think this is the problem, fear, more than one here has the fear that a I don't think you need worry that anyone here is afraid of losing their job. Worry about getting one and then keeping it. little kid would come from nowhere and take over their jobs. Very droll. More worryingly, it shows delusions of adequacy on your part. hence they dont want to teach the little they know about anything to anyone. Then again, it's you that's asking about basics and experienced posters taking time out from interesting advanced stuff doing the telling. on the other hand, the problem might just be that you guys are either brits or canadians. Is that because we can spell and punctuate or because we don't resort to childish insults? enjoy your cup of tea sir. Thank you. I am. you are so funny, but i already pictured you hanging out with your "bloody mates" and it "pissed me off" to see such a big amount of "townies" laughting at each other while drinking an ale market beer with 1.9% alcohol concentration. Not sure how to parse this what with the spelling and strange use of "English". I don't think it's anything to do with several hours of beer drinking because I can still communicate better than you can. And 1.9% beer? Is there such a thing? Is that strong for American beer? Most British beer is 4-7% and even weak British beer is over 3%.You do have to be over 18 to get it though. I avoid those under about 5-6% for taste reasons. now if youre canadian youll think im mexican. if youre british youll think im a "nigger". Funnily enough I am British and don't think you're a "nigger" as you so quaintly put it. No, if I had to classify you all it would be in terms of how far down the left hand side of the bell curve you are rather than resorting to the feeble racial/sexual stereotypes so beloved of the people whose lot it is to down there looking up at the peak. Luckily that peak is large enough that the posters on this list who are on the right hand side don't see the likes of you until you jump up and down like a spoilt 5 year old. how nice sqlite turned out to be. and the users calling it a PROGRAMMING LANGUAGE when its just an interpreted piece of crap. Couple of basic points that seem to have escaped your razor sharp insight. SQL is the language, SQLite is a library that implements it. Most users are well aware of this basic fact - it's only failed wannabes that have missed it. And the fact that SQLite compiles SQL to byte code which is interpreted doesn't prevent SQL from being a language any more than it does .NET, Python, Java, Pascal, BASIC or many others for all I know. And a lot of BIG companies use this "interpreted piece of crap" - what's your contribution to the global good? Now Terry, I must dash - it's 2am and my missus and I have some brandy and a bottle of port to finish off before bedtime. If you're interested in the numbers I think they're about 40% but to be honest I drink them because I like the taste, which is more than I can say about tedious little ingrates like you. Martin
Re: [sqlite] i have a few Qs - sqlite3
Please don't feed the troll... ~Nuno Lucas
RE: [sqlite] i have a few Qs - sqlite3
I think with that last one you best witch to some other database. I fear you will get no help here. Your lack of command of the English language does not excuse your extremely misaligned mind. No one on the face of this planet would place me in the "politically correct" crowd, but this last post even offended me, and I am neither a Canadian or English. Just an old tired east Texas red neck that is struggling to suppress the urge to wish I could kick you whiney ass... Go away Boy, you bother us. > -Original Message- > From: 353455 453455 [mailto:[EMAIL PROTECTED] > Sent: Saturday, July 08, 2006 4:07 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] i have a few Qs - sqlite3 > > > excuse me?. do you really think this is my homework and that > i want someone > like him to do it for me?. > > i think this is the problem, fear, more than one here has the > fear that a > little kid would come from nowhere and take over their jobs. > hence they dont > want to teach the little they know about anything to anyone. > > on the other hand, the problem might just be that you guys > are either brits > or canadians. > > enjoy your cup of tea sir. > > you are so funny, but i already pictured you hanging out with > your "bloody > mates" and it "pissed me off" to see such a big amount of "townies" > laughting at each other while drinking an ale market beer > with 1.9% alcohol > concentration. > > now if youre canadian youll think im mexican. > if youre british youll think im a "nigger". ...
Re: [sqlite] i have a few Qs - sqlite3
Dear Mr. Kid, I'm Slovakian and I hope you will accept a reply from me. I think that at least 3 people answered your request in a very polite way. Please don't judge them by your own standards. The first requirement when working with SQLite is to know the SQL language, only then you can try to use this library. If you don't require SQL compatible data storage, look for some other library, there are plenty of them on sf.net or freshmeat.net . If you need to find some SQL tutorials, feel free to click on http://www.google.com/search?hl=en&q=sql+tutorial . That will show you how to search for a text, and other things. Once you master all kinds SELECTs, this mailing list can give you lot of answers on optimizing your searches using indices and help you with other SQLite-specific syntax. If this is not what you're looking for, try to be more specific. Sorry for top-posting. Peter On 7/8/06, 353455 453455 <[EMAIL PROTECTED]> wrote: excuse me?. do you really think this is my homework and that i want someone like him to do it for me?. i think this is the problem, fear, more than one here has the fear that a little kid would come from nowhere and take over their jobs. hence they dont want to teach the little they know about anything to anyone. on the other hand, the problem might just be that you guys are either brits or canadians. enjoy your cup of tea sir. you are so funny, but i already pictured you hanging out with your "bloody mates" and it "pissed me off" to see such a big amount of "townies" laughting at each other while drinking an ale market beer with 1.9% alcohol concentration. now if youre canadian youll think im mexican. if youre british youll think im a "nigger". thats so right. how nice sqlite turned out to be. and the users calling it a PROGRAMMING LANGUAGE when its just an interpreted piece of crap.
Re: [sqlite] i have a few Qs - sqlite3
There are people on this forum who are extremely generous with their time and talent, none more than Dr Hipp who has created and maintains a first rate piece of software yet is generous enough to provide it free of charge to all those who can find a use for it. Be nice to them and they will make an extraordinary effort to be helpful to you. By the way Sqlite is a DBMS library for embedded applications, not a language. It uses SQL as its input and incorporates an embedded metalanguage, VDBE, which is the output of the SQL compiler and actually executes the data manipulation. 353455 453455 wrote: excuse me?. do you really think this is my homework and that i want someone like him to do it for me?. i think this is the problem, fear, more than one here has the fear that a little kid would come from nowhere and take over their jobs. hence they dont want to teach the little they know about anything to anyone. on the other hand, the problem might just be that you guys are either brits or canadians. enjoy your cup of tea sir. you are so funny, but i already pictured you hanging out with your "bloody mates" and it "pissed me off" to see such a big amount of "townies" laughting at each other while drinking an ale market beer with 1.9% alcohol concentration. now if youre canadian youll think im mexican. if youre british youll think im a "nigger". thats so right. how nice sqlite turned out to be. and the users calling it a PROGRAMMING LANGUAGE when its just an interpreted piece of crap. On 7/8/06, Martin Jenkins <[EMAIL PROTECTED]> wrote: C.Peachment wrote: So true. :( I was hoping that when it all goes quiet for him he might take a moment to take a look at the "getting other people to do your homework" section... Martin > While this is good advice, I fear the content might be too much for our > impatient petitioner. Learning to crawl before trying to walk or run can > be a poorly understood fact of life for some novices. > > On Sat, 08 Jul 2006 11:23:03 +0100, Martin Jenkins wrote: > >> You might find it useful to >> take a look at http://www.catb.org/~esr/faqs/smart-questions.htmlbefore >> asking any more questions. Useful advice in there that you would do well >> to digest. ;) > > > > > >
Re: [sqlite] i have a few Qs - sqlite3
excuse me?. do you really think this is my homework and that i want someone like him to do it for me?. i think this is the problem, fear, more than one here has the fear that a little kid would come from nowhere and take over their jobs. hence they dont want to teach the little they know about anything to anyone. on the other hand, the problem might just be that you guys are either brits or canadians. enjoy your cup of tea sir. you are so funny, but i already pictured you hanging out with your "bloody mates" and it "pissed me off" to see such a big amount of "townies" laughting at each other while drinking an ale market beer with 1.9% alcohol concentration. now if youre canadian youll think im mexican. if youre british youll think im a "nigger". thats so right. how nice sqlite turned out to be. and the users calling it a PROGRAMMING LANGUAGE when its just an interpreted piece of crap. On 7/8/06, Martin Jenkins <[EMAIL PROTECTED]> wrote: C.Peachment wrote: So true. :( I was hoping that when it all goes quiet for him he might take a moment to take a look at the "getting other people to do your homework" section... Martin > While this is good advice, I fear the content might be too much for our > impatient petitioner. Learning to crawl before trying to walk or run can > be a poorly understood fact of life for some novices. > > On Sat, 08 Jul 2006 11:23:03 +0100, Martin Jenkins wrote: > >> You might find it useful to >> take a look at http://www.catb.org/~esr/faqs/smart-questions.htmlbefore >> asking any more questions. Useful advice in there that you would do well >> to digest. ;) > > > > > >
Re: [sqlite] i have a few Qs - sqlite3
OK, just as long as you promise not to sue me. There are no lawyeres here. Fred Williams wrote: Then how 'bout letting me know the next time you see a market "bubble" coming? :-) -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Friday, July 07, 2006 8:53 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] i have a few Qs - sqlite3 ??? I am in heaven. 353455 453455 wrote: You make it so easy so others can learn from you. Youll go to heaven for that. You are so useful to those who ask for your help. Someone should make you a saint and pray so you help them. On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: Sigh Free help is a privilege, not a right. Explanations are not pointless, they are educational. 353455 453455 wrote: I do want to learn but i dont like to waste hours and hours through pointless explainations. i know what an integer is.. i dont need 3 pages explaining it, worst thing is that the tutorials arent good at all they dont teach me a lot of what i want to learn. spoon feeding? well i cant afford books here because there are none to buy. and shipment fees are huge so thats not an option. i just wanted some advice. sqlite documentation seems to talk about how good sqlite WAS in those times and how things seem to be done among with a few senseless examples which doesnt help at all. by now you think im a retarded little kid for saying what i said. i just wanted some advice from those who KNOW. hence i came to ask HERE. On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: This type of thing works - http://www.1keydata.com/sql/sql.html You can also look through the Sqlite documentation. An SQL driven database is not a good tool for a person who doesn't want to get some SQL knowledge. If you are looking for spoon feeding, seeking free information on the Internet is not the way. Enroll. I found Sqlitespy a bit flaky but useful. Sqlbrowser seems to be quite effective. 353455 453455 wrote: i tried sqlitespy but its so unfinished! about the tutorials i cant find any sqlite good ones should i read mysql ones? any texts i can read so i can learn the basics instead of having to crawl though piles of nonsense texts? because most tutorials ive found doesnt seem quite right they TRY to explain a lot but they TEACH way too little. On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: Try sqlitespy or sqlbrowser. Both free to download. You will need to learn some SQL. Just find an on-line tutorial and learn the basics. It will on take a couple of hours. 353455 453455 wrote: hi i have a few questions hope they dont bother much. I) how can i know how many tables and how many rows there are in my database? II) how can i perform a search on my database? i need to do simple text search queries. and about knowing the amount of tables and rows. i need this because i want to have a few statistics. so is there any way of knowing how many tables and how many rows there are in total via a query? im interested in searching on just a column of each table in this database but i dont know any sql at all. im using sqlite3. does anybody know of a good administration tool for sqlite3? because i only found a few tools but they werent quite done. and the others ive found were shareware so i want to know if theres any freeware good tool out there?.
Re: [sqlite] i have a few Qs - sqlite3
C.Peachment wrote: So true. :( I was hoping that when it all goes quiet for him he might take a moment to take a look at the "getting other people to do your homework" section... Martin While this is good advice, I fear the content might be too much for our impatient petitioner. Learning to crawl before trying to walk or run can be a poorly understood fact of life for some novices. On Sat, 08 Jul 2006 11:23:03 +0100, Martin Jenkins wrote: You might find it useful to take a look at http://www.catb.org/~esr/faqs/smart-questions.html before asking any more questions. Useful advice in there that you would do well to digest. ;)
Re: [sqlite] i have a few Qs - sqlite3
While this is good advice, I fear the content might be too much for our impatient petitioner. Learning to crawl before trying to walk or run can be a poorly understood fact of life for some novices. On Sat, 08 Jul 2006 11:23:03 +0100, Martin Jenkins wrote: > You might find it useful to >take a look at http://www.catb.org/~esr/faqs/smart-questions.html before >asking any more questions. Useful advice in there that you would do well >to digest. ;)
Re: [sqlite] i have a few Qs - sqlite3
353455 453455 wrote: www.yeohhs.com/vcsqlite1.htmI doesnt seem to work for me, wrong url? >> www.yeohhs.com/vcsqlite1.htmItcovers some basics of SQLite, and the It's pretty obvious from the context and structure of that message that the URL http://www.yeohhs.com/vcsqlite1.htm got run into the text immediately following it. I'm not making fun of you here but if you can't spot stuff like that then perhaps programming isn't really the thing for you. If you lighten up you'll get plenty of help, but if you complain when help is offered or rubbish that help because it's not tailored to your exact requirements or bleat that you have to "waste hours and hours" of your time, then I think you'll find that people will stop "wasting" their time and go back to whatever interesting thing it was they were doing before you popped up. You might find it useful to take a look at http://www.catb.org/~esr/faqs/smart-questions.html before asking any more questions. Useful advice in there that you would do well to digest. ;) Martin
RE: [sqlite] i have a few Qs - sqlite3
Then how 'bout letting me know the next time you see a market "bubble" coming? :-) > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Friday, July 07, 2006 8:53 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] i have a few Qs - sqlite3 > > > ??? I am in heaven. > > 353455 453455 wrote: > > You make it so easy so others can learn from you. Youll go > to heaven for > > that. You are so useful to those who ask for your help. > Someone should make > > you a saint and pray so you help them. > > > > > > > > > > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: > > > >> > >> Sigh Free help is a privilege, not a right. > Explanations are not > >> pointless, they are educational. > >> > >> 353455 453455 wrote: > >> > I do want to learn but i dont like to waste hours and > hours through > >> > pointless explainations. i know what an integer is.. i > dont need 3 > >> pages > >> > explaining it, worst thing is that the tutorials arent > good at all they > >> > dont > >> > teach me a lot of what i want to learn. > >> > > >> > spoon feeding? well i cant afford books here because > there are none to > >> buy. > >> > and shipment fees are huge so thats not an option. i > just wanted some > >> > advice. > >> > > >> > sqlite documentation seems to talk about how good sqlite > WAS in those > >> times > >> > and how things seem to be done among with a few > senseless examples > >> which > >> > doesnt help at all. > >> > > >> > by now you think im a retarded little kid for saying what i said. > >> > i just wanted some advice from those who KNOW. hence i > came to ask > >> HERE. > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: > >> > > >> >> > >> >> This type of thing works - http://www.1keydata.com/sql/sql.html > >> >> > >> >> You can also look through the Sqlite documentation. > >> >> > >> >> An SQL driven database is not a good tool for a person > who doesn't > >> want > >> >> to get some SQL knowledge. > >> >> > >> >> If you are looking for spoon feeding, seeking free > information on the > >> >> Internet is not the way. Enroll. > >> >> > >> >> I found Sqlitespy a bit flaky but useful. Sqlbrowser > seems to be > >> quite > >> >> effective. > >> >> > >> >> 353455 453455 wrote: > >> >> > i tried sqlitespy but its so unfinished! > >> >> > > >> >> > about the tutorials i cant find any sqlite good ones > >> >> > should i read mysql ones? > >> >> > > >> >> > any texts i can read so i can learn the basics > instead of having to > >> >> crawl > >> >> > though piles of nonsense texts? because most > tutorials ive found > >> doesnt > >> >> > seem > >> >> > quite right they TRY to explain a lot but they TEACH > way too little. > >> >> > > >> >> > > >> >> > > >> >> > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: > >> >> > > >> >> >> > >> >> >> Try sqlitespy or sqlbrowser. Both free to download. > >> >> >> > >> >> >> You will need to learn some SQL. Just find an > on-line tutorial and > >> >> >> learn the basics. It will on take a couple of hours. > >> >> >> > >> >> >> 353455 453455 wrote: > >> >> >> > hi i have a few questions hope they dont bother much. > >> >> >> > > >> >> >> > I) how can i know how many tables and how many > rows there are in > >> my > >> >> >> > database? > >> >> >> > II) how can i perform a search on my database? > >> >> >> > > >> >> >> > > >> >> >> > i need to do simple text search queries. and about > knowing the > >> >> >> amount of > >> >> >> > tables and rows. i need this because i want to have a few > >> >> >> statistics. so > >> >> >> is > >> >> >> > there any way of knowing how many tables and how > many rows there > >> are > >> >> in > >> >> >> > total via a query? > >> >> >> > > >> >> >> > im interested in searching on just a column of > each table in this > >> >> >> database > >> >> >> > but i dont know any sql at all. > >> >> >> > im using sqlite3. > >> >> >> > > >> >> >> > does anybody know of a good administration tool > for sqlite3? > >> because > >> >> i > >> >> >> only > >> >> >> > found a few tools but they werent quite done. and > the others ive > >> >> found > >> >> >> were > >> >> >> > shareware so i want to know if theres any freeware > good tool out > >> >> >> there?. > >> >> >> > > >> >> >> > >> >> >> > >> >> > > >> >> > >> >> > >> > > >> > >> > > >
RE: [sqlite] i have a few Qs - sqlite3
I would guess from the drift of things, you really should be working at learning the database language "SQL" and not "learning" SQLite. SQLite is only one of a multitude of modern relational databases which use SQL as their language of choice for their user interface. Actually using SQLite once you know and understand the inherent structure and design philosophies of modern databases in general is basically a "no brainer" I installed SQLite and in less than a day was playing with the new toy. But, I've been messing with relational databases before they were named that and long before SQL became a defacto industry standard. Sometimes things are just not as easy as the marketing department leads you to believe. Resign yourself to learning about databases in general, then SQL the language, and then SQLite will be a "no brainer" for you as well. If there are no books perhaps you can find a local mentor. The support structure of SQLite is not designed to be a database teaching tool. It is as it is, a support structure. And you will find answers to support like questions here, but try to soak up the bandwidth and hand holding that would be required for "Databases 101" and you will get pretty much the reaction you have already witnessed. It is also not against the law to skip ahead in text when you find the current topic boring. How else could one read all those 1000+ page tomes so ubiquitous in our field of endeavor. Fred > -Original Message- > From: 353455 453455 [mailto:[EMAIL PROTECTED] > Sent: Friday, July 07, 2006 8:06 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] i have a few Qs - sqlite3 > > > I do want to learn but i dont like to waste hours and hours through > pointless explainations. i know what an integer is.. i dont > need 3 pages > explaining it, worst thing is that the tutorials arent good > at all they dont > teach me a lot of what i want to learn. > > spoon feeding? well i cant afford books here because there > are none to buy. > and shipment fees are huge so thats not an option. i just wanted some > advice. > > sqlite documentation seems to talk about how good sqlite WAS > in those times > and how things seem to be done among with a few senseless > examples which > doesnt help at all. > > by now you think im a retarded little kid for saying what i said. > i just wanted some advice from those who KNOW. hence i came > to ask HERE. > > > > > > > > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: > > > > This type of thing works - http://www.1keydata.com/sql/sql.html > > > > You can also look through the Sqlite documentation. > > > > An SQL driven database is not a good tool for a person who > doesn't want > > to get some SQL knowledge. > > > > If you are looking for spoon feeding, seeking free > information on the > > Internet is not the way. Enroll. > > > > I found Sqlitespy a bit flaky but useful. Sqlbrowser seems > to be quite > > effective. > > > > 353455 453455 wrote: > > > i tried sqlitespy but its so unfinished! > > > > > > about the tutorials i cant find any sqlite good ones > > > should i read mysql ones? > > > > > > any texts i can read so i can learn the basics instead of > having to > > crawl > > > though piles of nonsense texts? because most tutorials > ive found doesnt > > > seem > > > quite right they TRY to explain a lot but they TEACH way > too little. > > > > > > > > > > > > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: > > > > > >> > > >> Try sqlitespy or sqlbrowser. Both free to download. > > >> > > >> You will need to learn some SQL. Just find an on-line > tutorial and > > >> learn the basics. It will on take a couple of hours. > > >> > > >> 353455 453455 wrote: > > >> > hi i have a few questions hope they dont bother much. > > >> > > > >> > I) how can i know how many tables and how many rows > there are in my > > >> > database? > > >> > II) how can i perform a search on my database? > > >> > > > >> > > > >> > i need to do simple text search queries. and about knowing the > > >> amount of > > >> > tables and rows. i need this because i want to have a few > > >> statistics. so > > >> is > > >> > there any way of knowing how many tables and how many > rows there are > > in > > >> > total via a query? > > >> > > > >> > im interested in searching on just a column of each > table in this > > >> database > > >> > but i dont know any sql at all. > > >> > im using sqlite3. > > >> > > > >> > does anybody know of a good administration tool for > sqlite3? because > > i > > >> only > > >> > found a few tools but they werent quite done. and the > others ive > > found > > >> were > > >> > shareware so i want to know if theres any freeware > good tool out > > >> there?. > > >> > > > >> > > >> > > > > > > > >
Re: [sqlite] i have a few Qs - sqlite3
www.yeohhs.com/vcsqlite1.htmI doesnt seem to work for me, wrong url? On 7/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Whoa, time out here.Try this tutorial at www.yeohhs.com/vcsqlite1.htmItcovers some basics of SQLite, and the use of SQLite with C++.Bill ??? I am in heaven.353455 453455 wrote:> You make it so easy so others can learn from you. Youll go to heaven for> that. You are so useful to those who ask for your help. Someone should make> you a saint and pray so you help them.> > > > > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote:> Sigh Free help is a privilege, not a right. Explanations are not>> pointless, they are educational. 353455 453455 wrote:>> > I do want to learn but i dont like to waste hours and hours through>> > pointless explainations. i know what an integer is.. i dont need 3 >> pages>> > explaining it, worst thing is that the tutorials arent good at all they>> > dont>> > teach me a lot of what i want to learn.>> >>> > spoon feeding? well i cant afford books here because there are none to>> buy.>> > and shipment fees are huge so thats not an option. i just wanted some>> > advice.>> >>> > sqlite documentation seems to talk about how good sqlite WAS in those>> times>> > and how things seem to be done among with a few senseless examples >> which>> > doesnt help at all.>> >>> > by now you think im a retarded little kid for saying what i said.>> > i just wanted some advice from those who KNOW. hence i came to ask >> HERE.>> >>> >>> >>> >>> >>> >>> >>> > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote:>> >>> >> This type of thing works - http://www.1keydata.com/sql/sql.htm l>> >> You can also look through the Sqlite documentation.>> >> An SQL driven database is not a good tool for a person who doesn't >> want>> >> to get some SQL knowledge.>> >> If you are looking for spoon feeding, seeking free information on the>> >> Internet is not the way. Enroll.>> >> I found Sqlitespy a bit flaky but useful. Sqlbrowser seems to be >> quite>> >> effective.>> >> 353455 453455 wrote:>> >> > i tried sqlitespy but its so unfinished!>> >> >>> >> > about the tutorials i cant find any sqlite good ones>> >> > should i read mysql ones?>> >> >>> >> > any texts i can read so i can learn the basics instead of having to>> >> crawl>> >> > though piles of nonsense texts? because most tutorials ive found>> doesnt>> >> > seem>> >> > quite right they TRY to explain a lot but they TEACH way too little.>> >> >>> >> >>> >> >>> >> > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote:>> >> >>> >> >> >> Try sqlitespy or sqlbrowser. Both free to download.>> >> >> >> You will need to learn some SQL. Just find an on-line tutorial and>> >> >> learn the basics. It will on take a couple of hours.>> >> >> >> 353455 453455 wrote:>> >> >> > hi i have a few questions hope they dont bother much.>> >> >> >>> >> >> > I) how can i know how many tables and how many rows there are in>> my>> >> >> > database?>> >> >> > II) how can i perform a search on my database?>> >> >> >>> >> >> >>> >> >> > i need to do simple text search queries. and about knowing the>> >> >> amount of>> >> >> > tables and rows. i need this because i want to have a few>> >> >> statistics. so>> >> >> is>> >> >> > there any way of knowing how many tables and how many rows there>> are>> >> in>> >> >> > total via a query?>> >> >> >>> >> >> > im interested in searching on just a column of each table in this>> >> >> database>> >> >> > but i dont know any sql at all.>> >> >> > im using sqlite3.>> >> >> >>> >> >> > does anybody know of a good administration tool for sqlite3?>> because>> >> i>> >> >> only>> >> >> > found a few tools but they werent quite done. and the others ive>> >> found>> >> >> were>> >> >> > shareware so i want to know if theres any freeware good tool out>> >> >> there?.>> >> >> >>> >> >> >> >>> >>
Re: [sqlite] i have a few Qs - sqlite3
Yeah, making fun out of those who are one step underneath. On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: ??? I am in heaven. 353455 453455 wrote: > You make it so easy so others can learn from you. Youll go to heaven for > that. You are so useful to those who ask for your help. Someone should make > you a saint and pray so you help them. > > > > > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: > >> >> Sigh Free help is a privilege, not a right. Explanations are not >> pointless, they are educational. >> >> 353455 453455 wrote: >> > I do want to learn but i dont like to waste hours and hours through >> > pointless explainations. i know what an integer is.. i dont need 3 >> pages >> > explaining it, worst thing is that the tutorials arent good at all they >> > dont >> > teach me a lot of what i want to learn. >> > >> > spoon feeding? well i cant afford books here because there are none to >> buy. >> > and shipment fees are huge so thats not an option. i just wanted some >> > advice. >> > >> > sqlite documentation seems to talk about how good sqlite WAS in those >> times >> > and how things seem to be done among with a few senseless examples >> which >> > doesnt help at all. >> > >> > by now you think im a retarded little kid for saying what i said. >> > i just wanted some advice from those who KNOW. hence i came to ask >> HERE. >> > >> > >> > >> > >> > >> > >> > >> > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: >> > >> >> >> >> This type of thing works - http://www.1keydata.com/sql/sql.html >> >> >> >> You can also look through the Sqlite documentation. >> >> >> >> An SQL driven database is not a good tool for a person who doesn't >> want >> >> to get some SQL knowledge. >> >> >> >> If you are looking for spoon feeding, seeking free information on the >> >> Internet is not the way. Enroll. >> >> >> >> I found Sqlitespy a bit flaky but useful. Sqlbrowser seems to be >> quite >> >> effective. >> >> >> >> 353455 453455 wrote: >> >> > i tried sqlitespy but its so unfinished! >> >> > >> >> > about the tutorials i cant find any sqlite good ones >> >> > should i read mysql ones? >> >> > >> >> > any texts i can read so i can learn the basics instead of having to >> >> crawl >> >> > though piles of nonsense texts? because most tutorials ive found >> doesnt >> >> > seem >> >> > quite right they TRY to explain a lot but they TEACH way too little. >> >> > >> >> > >> >> > >> >> > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: >> >> > >> >> >> >> >> >> Try sqlitespy or sqlbrowser. Both free to download. >> >> >> >> >> >> You will need to learn some SQL. Just find an on-line tutorial and >> >> >> learn the basics. It will on take a couple of hours. >> >> >> >> >> >> 353455 453455 wrote: >> >> >> > hi i have a few questions hope they dont bother much. >> >> >> > >> >> >> > I) how can i know how many tables and how many rows there are in >> my >> >> >> > database? >> >> >> > II) how can i perform a search on my database? >> >> >> > >> >> >> > >> >> >> > i need to do simple text search queries. and about knowing the >> >> >> amount of >> >> >> > tables and rows. i need this because i want to have a few >> >> >> statistics. so >> >> >> is >> >> >> > there any way of knowing how many tables and how many rows there >> are >> >> in >> >> >> > total via a query? >> >> >> > >> >> >> > im interested in searching on just a column of each table in this >> >> >> database >> >> >> > but i dont know any sql at all. >> >> >> > im using sqlite3. >> >> >> > >> >> >> > does anybody know of a good administration tool for sqlite3? >> because >> >> i >> >> >> only >> >> >> > found a few tools but they werent quite done. and the others ive >> >> found >> >> >> were >> >> >> > shareware so i want to know if theres any freeware good tool out >> >> >> there?. >> >> >> > >> >> >> >> >> >> >> >> > >> >> >> >> >> > >> >> >
Re: [sqlite] i have a few Qs - sqlite3
Whoa, time out here.Try this tutorial at www.yeohhs.com/vcsqlite1.htmIt covers some basics of SQLite, and the use of SQLite with C++.Bill ??? I am in heaven.353455 453455 wrote:> You make it so easy so others can learn from you. Youll go to heaven for> that. You are so useful to those who ask for your help. Someone should make> you a saint and pray so you help them.> > > > > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote:> Sigh Free help is a privilege, not a right. Explanations are not>> pointless, they are educational. 353455 453455 wrote:>> > I do want to learn but i dont like to waste hours and hours through>> > pointless explainations. i know what an integer is.. i dont need 3 >> pages>> > explaining it, worst thing is that the tutorials arent good at all they>> > dont>> > teach me a lot of what i want to learn.>> >>> > spoon feeding? well i cant afford books here because there are none to>> buy.>> > and shipment fees are huge so thats not an option. i just wanted some>> > advice.>> >>> > sqlite documentation seems to talk about how good sqlite WAS in those>> times>> > and how things seem to be done among with a few senseless examples >> which>> > doesnt help at all.>> >>> > by now you think im a retarded little kid for saying what i said.>> > i just wanted some advice from those who KNOW. hence i came to ask >> HERE.>> >>> >>> >>> >>> >>> >>> >>> > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote:>> >>> >> This type of thing works - http://www.1keydata.com/sql/sql.htm l>> >> You can also look through the Sqlite documentation.>> >> An SQL driven database is not a good tool for a person who doesn't >> want>> >> to get some SQL knowledge.>> >> If you are looking for spoon feeding, seeking free information on the>> >> Internet is not the way. Enroll.>> >> I found Sqlitespy a bit flaky but useful. Sqlbrowser seems to be >> quite>> >> effective.>> >> 353455 453455 wrote:>> >> > i tried sqlitespy but its so unfinished!>> >> >>> >> > about the tutorials i cant find any sqlite good ones>> >> > should i read mysql ones?>> >> >>> >> > any texts i can read so i can learn the basics instead of having to>> >> crawl>> >> > though piles of nonsense texts? because most tutorials ive found>> doesnt>> >> > seem>> >> > quite right they TRY to explain a lot but they TEACH way too little.>> >> >>> >> >>> >> >>> >> > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote:>> >> >>> >> >> >> Try sqlitespy or sqlbrowser. Both free to download.>> >> >> >> You will need to learn some SQL. Just find an on-line tutorial and>> >> >> learn the basics. It will on take a couple of hours.>> >> >> >> 353455 453455 wrote:>> >> >> > hi i have a few questions hope they dont bother much.>> >> >> >>> >> >> > I) how can i know how many tables and how many rows there are in>> my>> >> >> > database?>> >> >> > II) how can i perform a search on my database?>> >> >> >>> >> >> >>> >> >> > i need to do simple text search queries. and about knowing the>> >> >> amount of>> >> >> > tables and rows. i need this because i want to have a few>> >> >> statistics. so>> >> >> is>> >> >> > there any way of knowing how many tables and how many rows there>> are>> >> in>> >> >> > total via a query?>> >> >> >>> >> >> > im interested in searching on just a column of each table in this>> >> >> database>> >> >> > but i dont know any sql at all.>> >> >> > im using sqlite3.>> >> >> >>> >> >> > does anybody know of a good administration tool for sqlite3?>> because>> >> i>> >> >> only>> >> >> > found a few tools but they werent quite done. and the others ive>> >> found>> >> >> were>> >> >> > shareware so i want to know if theres any freeware good tool out>> >> >> there?.>> >> >> >>> >> >> >> >>> >>
Re: [sqlite] i have a few Qs - sqlite3
??? I am in heaven. 353455 453455 wrote: You make it so easy so others can learn from you. Youll go to heaven for that. You are so useful to those who ask for your help. Someone should make you a saint and pray so you help them. On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: Sigh Free help is a privilege, not a right. Explanations are not pointless, they are educational. 353455 453455 wrote: > I do want to learn but i dont like to waste hours and hours through > pointless explainations. i know what an integer is.. i dont need 3 pages > explaining it, worst thing is that the tutorials arent good at all they > dont > teach me a lot of what i want to learn. > > spoon feeding? well i cant afford books here because there are none to buy. > and shipment fees are huge so thats not an option. i just wanted some > advice. > > sqlite documentation seems to talk about how good sqlite WAS in those times > and how things seem to be done among with a few senseless examples which > doesnt help at all. > > by now you think im a retarded little kid for saying what i said. > i just wanted some advice from those who KNOW. hence i came to ask HERE. > > > > > > > > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: > >> >> This type of thing works - http://www.1keydata.com/sql/sql.html >> >> You can also look through the Sqlite documentation. >> >> An SQL driven database is not a good tool for a person who doesn't want >> to get some SQL knowledge. >> >> If you are looking for spoon feeding, seeking free information on the >> Internet is not the way. Enroll. >> >> I found Sqlitespy a bit flaky but useful. Sqlbrowser seems to be quite >> effective. >> >> 353455 453455 wrote: >> > i tried sqlitespy but its so unfinished! >> > >> > about the tutorials i cant find any sqlite good ones >> > should i read mysql ones? >> > >> > any texts i can read so i can learn the basics instead of having to >> crawl >> > though piles of nonsense texts? because most tutorials ive found doesnt >> > seem >> > quite right they TRY to explain a lot but they TEACH way too little. >> > >> > >> > >> > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: >> > >> >> >> >> Try sqlitespy or sqlbrowser. Both free to download. >> >> >> >> You will need to learn some SQL. Just find an on-line tutorial and >> >> learn the basics. It will on take a couple of hours. >> >> >> >> 353455 453455 wrote: >> >> > hi i have a few questions hope they dont bother much. >> >> > >> >> > I) how can i know how many tables and how many rows there are in my >> >> > database? >> >> > II) how can i perform a search on my database? >> >> > >> >> > >> >> > i need to do simple text search queries. and about knowing the >> >> amount of >> >> > tables and rows. i need this because i want to have a few >> >> statistics. so >> >> is >> >> > there any way of knowing how many tables and how many rows there are >> in >> >> > total via a query? >> >> > >> >> > im interested in searching on just a column of each table in this >> >> database >> >> > but i dont know any sql at all. >> >> > im using sqlite3. >> >> > >> >> > does anybody know of a good administration tool for sqlite3? because >> i >> >> only >> >> > found a few tools but they werent quite done. and the others ive >> found >> >> were >> >> > shareware so i want to know if theres any freeware good tool out >> >> there?. >> >> > >> >> >> >> >> > >> >> >
Re: [sqlite] i have a few Qs - sqlite3
You make it so easy so others can learn from you. Youll go to heaven for that. You are so useful to those who ask for your help. Someone should make you a saint and pray so you help them. On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: Sigh Free help is a privilege, not a right. Explanations are not pointless, they are educational. 353455 453455 wrote: > I do want to learn but i dont like to waste hours and hours through > pointless explainations. i know what an integer is.. i dont need 3 pages > explaining it, worst thing is that the tutorials arent good at all they > dont > teach me a lot of what i want to learn. > > spoon feeding? well i cant afford books here because there are none to buy. > and shipment fees are huge so thats not an option. i just wanted some > advice. > > sqlite documentation seems to talk about how good sqlite WAS in those times > and how things seem to be done among with a few senseless examples which > doesnt help at all. > > by now you think im a retarded little kid for saying what i said. > i just wanted some advice from those who KNOW. hence i came to ask HERE. > > > > > > > > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: > >> >> This type of thing works - http://www.1keydata.com/sql/sql.html >> >> You can also look through the Sqlite documentation. >> >> An SQL driven database is not a good tool for a person who doesn't want >> to get some SQL knowledge. >> >> If you are looking for spoon feeding, seeking free information on the >> Internet is not the way. Enroll. >> >> I found Sqlitespy a bit flaky but useful. Sqlbrowser seems to be quite >> effective. >> >> 353455 453455 wrote: >> > i tried sqlitespy but its so unfinished! >> > >> > about the tutorials i cant find any sqlite good ones >> > should i read mysql ones? >> > >> > any texts i can read so i can learn the basics instead of having to >> crawl >> > though piles of nonsense texts? because most tutorials ive found doesnt >> > seem >> > quite right they TRY to explain a lot but they TEACH way too little. >> > >> > >> > >> > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: >> > >> >> >> >> Try sqlitespy or sqlbrowser. Both free to download. >> >> >> >> You will need to learn some SQL. Just find an on-line tutorial and >> >> learn the basics. It will on take a couple of hours. >> >> >> >> 353455 453455 wrote: >> >> > hi i have a few questions hope they dont bother much. >> >> > >> >> > I) how can i know how many tables and how many rows there are in my >> >> > database? >> >> > II) how can i perform a search on my database? >> >> > >> >> > >> >> > i need to do simple text search queries. and about knowing the >> >> amount of >> >> > tables and rows. i need this because i want to have a few >> >> statistics. so >> >> is >> >> > there any way of knowing how many tables and how many rows there are >> in >> >> > total via a query? >> >> > >> >> > im interested in searching on just a column of each table in this >> >> database >> >> > but i dont know any sql at all. >> >> > im using sqlite3. >> >> > >> >> > does anybody know of a good administration tool for sqlite3? because >> i >> >> only >> >> > found a few tools but they werent quite done. and the others ive >> found >> >> were >> >> > shareware so i want to know if theres any freeware good tool out >> >> there?. >> >> > >> >> >> >> >> > >> >> >
Re: [sqlite] i have a few Qs - sqlite3
Sigh Free help is a privilege, not a right. Explanations are not pointless, they are educational. 353455 453455 wrote: I do want to learn but i dont like to waste hours and hours through pointless explainations. i know what an integer is.. i dont need 3 pages explaining it, worst thing is that the tutorials arent good at all they dont teach me a lot of what i want to learn. spoon feeding? well i cant afford books here because there are none to buy. and shipment fees are huge so thats not an option. i just wanted some advice. sqlite documentation seems to talk about how good sqlite WAS in those times and how things seem to be done among with a few senseless examples which doesnt help at all. by now you think im a retarded little kid for saying what i said. i just wanted some advice from those who KNOW. hence i came to ask HERE. On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: This type of thing works - http://www.1keydata.com/sql/sql.html You can also look through the Sqlite documentation. An SQL driven database is not a good tool for a person who doesn't want to get some SQL knowledge. If you are looking for spoon feeding, seeking free information on the Internet is not the way. Enroll. I found Sqlitespy a bit flaky but useful. Sqlbrowser seems to be quite effective. 353455 453455 wrote: > i tried sqlitespy but its so unfinished! > > about the tutorials i cant find any sqlite good ones > should i read mysql ones? > > any texts i can read so i can learn the basics instead of having to crawl > though piles of nonsense texts? because most tutorials ive found doesnt > seem > quite right they TRY to explain a lot but they TEACH way too little. > > > > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: > >> >> Try sqlitespy or sqlbrowser. Both free to download. >> >> You will need to learn some SQL. Just find an on-line tutorial and >> learn the basics. It will on take a couple of hours. >> >> 353455 453455 wrote: >> > hi i have a few questions hope they dont bother much. >> > >> > I) how can i know how many tables and how many rows there are in my >> > database? >> > II) how can i perform a search on my database? >> > >> > >> > i need to do simple text search queries. and about knowing the >> amount of >> > tables and rows. i need this because i want to have a few >> statistics. so >> is >> > there any way of knowing how many tables and how many rows there are in >> > total via a query? >> > >> > im interested in searching on just a column of each table in this >> database >> > but i dont know any sql at all. >> > im using sqlite3. >> > >> > does anybody know of a good administration tool for sqlite3? because i >> only >> > found a few tools but they werent quite done. and the others ive found >> were >> > shareware so i want to know if theres any freeware good tool out >> there?. >> > >> >> >
Re: [sqlite] i have a few Qs - sqlite3
I do want to learn but i dont like to waste hours and hours through pointless explainations. i know what an integer is.. i dont need 3 pages explaining it, worst thing is that the tutorials arent good at all they dont teach me a lot of what i want to learn. spoon feeding? well i cant afford books here because there are none to buy. and shipment fees are huge so thats not an option. i just wanted some advice. sqlite documentation seems to talk about how good sqlite WAS in those times and how things seem to be done among with a few senseless examples which doesnt help at all. by now you think im a retarded little kid for saying what i said. i just wanted some advice from those who KNOW. hence i came to ask HERE. On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: This type of thing works - http://www.1keydata.com/sql/sql.html You can also look through the Sqlite documentation. An SQL driven database is not a good tool for a person who doesn't want to get some SQL knowledge. If you are looking for spoon feeding, seeking free information on the Internet is not the way. Enroll. I found Sqlitespy a bit flaky but useful. Sqlbrowser seems to be quite effective. 353455 453455 wrote: > i tried sqlitespy but its so unfinished! > > about the tutorials i cant find any sqlite good ones > should i read mysql ones? > > any texts i can read so i can learn the basics instead of having to crawl > though piles of nonsense texts? because most tutorials ive found doesnt > seem > quite right they TRY to explain a lot but they TEACH way too little. > > > > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: > >> >> Try sqlitespy or sqlbrowser. Both free to download. >> >> You will need to learn some SQL. Just find an on-line tutorial and >> learn the basics. It will on take a couple of hours. >> >> 353455 453455 wrote: >> > hi i have a few questions hope they dont bother much. >> > >> > I) how can i know how many tables and how many rows there are in my >> > database? >> > II) how can i perform a search on my database? >> > >> > >> > i need to do simple text search queries. and about knowing the >> amount of >> > tables and rows. i need this because i want to have a few >> statistics. so >> is >> > there any way of knowing how many tables and how many rows there are in >> > total via a query? >> > >> > im interested in searching on just a column of each table in this >> database >> > but i dont know any sql at all. >> > im using sqlite3. >> > >> > does anybody know of a good administration tool for sqlite3? because i >> only >> > found a few tools but they werent quite done. and the others ive found >> were >> > shareware so i want to know if theres any freeware good tool out >> there?. >> > >> >> >
Re: [sqlite] i have a few Qs - sqlite3
This type of thing works - http://www.1keydata.com/sql/sql.html You can also look through the Sqlite documentation. An SQL driven database is not a good tool for a person who doesn't want to get some SQL knowledge. If you are looking for spoon feeding, seeking free information on the Internet is not the way. Enroll. I found Sqlitespy a bit flaky but useful. Sqlbrowser seems to be quite effective. 353455 453455 wrote: i tried sqlitespy but its so unfinished! about the tutorials i cant find any sqlite good ones should i read mysql ones? any texts i can read so i can learn the basics instead of having to crawl though piles of nonsense texts? because most tutorials ive found doesnt seem quite right they TRY to explain a lot but they TEACH way too little. On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: Try sqlitespy or sqlbrowser. Both free to download. You will need to learn some SQL. Just find an on-line tutorial and learn the basics. It will on take a couple of hours. 353455 453455 wrote: > hi i have a few questions hope they dont bother much. > > I) how can i know how many tables and how many rows there are in my > database? > II) how can i perform a search on my database? > > > i need to do simple text search queries. and about knowing the amount of > tables and rows. i need this because i want to have a few statistics. so is > there any way of knowing how many tables and how many rows there are in > total via a query? > > im interested in searching on just a column of each table in this database > but i dont know any sql at all. > im using sqlite3. > > does anybody know of a good administration tool for sqlite3? because i only > found a few tools but they werent quite done. and the others ive found were > shareware so i want to know if theres any freeware good tool out there?. >
Re: [sqlite] i have a few Qs - sqlite3
i tried sqlitespy but its so unfinished! about the tutorials i cant find any sqlite good ones should i read mysql ones? any texts i can read so i can learn the basics instead of having to crawl though piles of nonsense texts? because most tutorials ive found doesnt seem quite right they TRY to explain a lot but they TEACH way too little. On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: Try sqlitespy or sqlbrowser. Both free to download. You will need to learn some SQL. Just find an on-line tutorial and learn the basics. It will on take a couple of hours. 353455 453455 wrote: > hi i have a few questions hope they dont bother much. > > I) how can i know how many tables and how many rows there are in my > database? > II) how can i perform a search on my database? > > > i need to do simple text search queries. and about knowing the amount of > tables and rows. i need this because i want to have a few statistics. so is > there any way of knowing how many tables and how many rows there are in > total via a query? > > im interested in searching on just a column of each table in this database > but i dont know any sql at all. > im using sqlite3. > > does anybody know of a good administration tool for sqlite3? because i only > found a few tools but they werent quite done. and the others ive found were > shareware so i want to know if theres any freeware good tool out there?. >
Re: [sqlite] i have a few Qs - sqlite3
Try sqlitespy or sqlbrowser. Both free to download. You will need to learn some SQL. Just find an on-line tutorial and learn the basics. It will on take a couple of hours. 353455 453455 wrote: hi i have a few questions hope they dont bother much. I) how can i know how many tables and how many rows there are in my database? II) how can i perform a search on my database? i need to do simple text search queries. and about knowing the amount of tables and rows. i need this because i want to have a few statistics. so is there any way of knowing how many tables and how many rows there are in total via a query? im interested in searching on just a column of each table in this database but i dont know any sql at all. im using sqlite3. does anybody know of a good administration tool for sqlite3? because i only found a few tools but they werent quite done. and the others ive found were shareware so i want to know if theres any freeware good tool out there?.