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?. > > >> > > > >> > > >> > > > > > > > >
