Re: [sqlite] Need sql query help
Thanks for all of the great ideas :) Plently of techniques to work on there. Just incase your interested, i woke up this morning and all the words finally made it into sqlite :) It took over 8 hours, so if anyone could tell me a text command that would do this same task of importing a txt file into a table through the sqlite3 command line that would be great. It must be the gui slowing it down somehow. Anyway, i ran the like query using heaps of different combinations of letters and the results are returned instantly :) More than fast enough for my purposes but i will definately check out some of the other methods just for fun :) It seems we under estimated sqlites speed for this task. Anyway, thanks again for all your replies, now i have to figure out how to sort through the resulted word list and score each letter with certain points to find the highest scoring words. Incase you haven't guessed, it is for a scrabble AI project. Am trying to make an AI player in scrabble that finds the highest scoring word with given tiles and pattern recognition of the words that are on the board. In other words, i am trying to clone this site: http://www.scrabblewordfinder.com/ Cheers :) -- View this message in context: http://www.nabble.com/Need-sql-query-help-t1844399.html#a5040314 Sent from the SQLite forum at Nabble.com.
Re: [sqlite] Need sql query help
Thanks, The thing is, i am going to need to use different letters each time to search through over 200,000 words in a database and it needs to be fast. What technology would be best suited for this task? I just assumed that a databse would be ideal, why do you say sql isn't suited for this and what is? Thanks again. -- View this message in context: http://www.nabble.com/Need-sql-query-help-t1844399.html#a5034782 Sent from the SQLite forum at Nabble.com.
Re: [sqlite] Sqlite crashes when i imort huge list
Aha, sorry Richard, it seems you may have been right. I downloaded a different gui call SQLite Administrator and it is importing now. The first gui i used, used 100% of my cpu and crashes, this new one doesn't use much but it is a sloow process.Have been running it for about 10 mins and am only at 3%. Might go to bed now and hopefully it willl be done by the morning. Cheers -- View this message in context: http://www.nabble.com/Sqlite-crashes-when-i-imort-huge-list-t1842991.html#a5034613 Sent from the SQLite forum at Nabble.com.
[sqlite] Where is the sqlite3.h file?
Hi, I am trying to use the .dll with c but it doesn't come with the eader file. Also, what is the.def file that comes with it? Thanks for any info -- View this message in context: http://www.nabble.com/Where-is-the-sqlite3.h-file--t1844421.html#a5034422 Sent from the SQLite forum at Nabble.com.
[sqlite] Need sql query help
Hi, I was hoping someone could tell me if it was possible to select all words containing ceratin letters. Eg If i had a table wit a word column that had a huge list of words and i wanted to select every word that contained all these letters "qdsa". Then it would return the words: quads quidas ect but wouldn't return queen because queen does not contain all letters specified. Would it be something like this: select * from word where word = "qsda"; THat doesn't work by the way :) Any help would be great. Thanks -- View this message in context: http://www.nabble.com/Need-sql-query-help-t1844399.html#a5034347 Sent from the SQLite forum at Nabble.com.
Re: [sqlite] Sqlite crashes when i imort huge list
Thanks guys, Richard: The reason i didn't mention the software is because all guis just create the text commands anyway so they all do the same thing. I doubt it is a problem with the gui i used which was "SQLite database browser". Chris: Thanks for that but i dont know how that helps me. Are you suggesting that i write a script that inserts one word at a time to avoid crashing or was it just an example? How would i write a command that would import from a text file without the gui? Is it the .import command? Any more help would be great. Here is a small sample of the file that i am trying to insert: AA AAH AAHED AAHING AAHS AAL AALII AALIIS AALS AARDVARK AARDVARKS AARDWOLF AARDWOLVES AARGH AARRGH AARRGHH AAS AASVOGEL AASVOGELS AB ABA ABACA ABACAS ABACI ABACK ABACTERIAL ABACUS ABACUSES ABAFT ABAKA ABAKAS ABALONE ABALONES ABAMP ABAMPERE ABAMPERES ABAMPS ABANDON ABANDONED ABANDONER ABANDONERS ABANDONING ABANDONMENT ABANDONMENTS ABANDONS ABAPICAL ABAS ABASE ABASED ABASEDLY ABASEMENT ABASEMENTS ABASER ABASERS ABASES ABASH ABASHED ABASHEDLY ABASHES ABASHING ABASHMENT ABASHMENTS ABASIA ABASIAS ABASING ABATABLE ABATE ABATED ABATEMENT ABATEMENTS ABATER ABATERS ABATES ABATING ABATIS ABATISES ABATOR ABATORS ABATTIS ABATTISES ABATTOIR ABATTOIRS ABAXIAL ABAXILE ABAYA ABAYAS ABBA ABBACIES ABBACY ABBAS ABBATIAL ABBE ABBES ABBESS ABBESSES ABBEY ABBEYS ABBOT ABBOTCIES ABBOTCY ABBOTS ABBOTSHIP ABBOTSHIPS ABBREVIATE ABBREVIATED ABBREVIATES ABBREVIATING ABBREVIATION ABBREVIATIONS ABBREVIATOR ABBREVIATORS ABCOULOMB ABCOULOMBS ABDICABLE ABDICATE ABDICATED ABDICATES ABDICATING ABDICATION ABDICATIONS ABDICATOR ABDICATORS ABDOMEN ABDOMENS ABDOMINA ABDOMINAL ABDOMINALLY ABDOMINALS ABDUCE ABDUCED ABDUCENS ABDUCENT ABDUCENTES ABDUCES ABDUCING ABDUCT ABDUCTED ABDUCTEE ABDUCTEES ABDUCTING ABDUCTION ABDUCTIONS ABDUCTOR ABDUCTORES ABDUCTORS ABDUCTS ABEAM ABECEDARIAN Thanks :) -- View this message in context: http://www.nabble.com/Sqlite-crashes-when-i-imort-huge-list-t1842991.html#a5034321 Sent from the SQLite forum at Nabble.com.
[sqlite] Sqlite crashes when i imort huge list
Hi, I am using the sqlite gui and click import table from csv. I select a txt file that contain over 200,000 words in a list. Sqlite works fine with a smaller list of 200-300 words but when i import my big list, it hangs for ages or completely crashes my computer. Does anyone know how i can import this list into a table successfully? Thanks for any help. -- View this message in context: http://www.nabble.com/Sqlite-crashes-when-i-imort-huge-list-t1842991.html#a5030925 Sent from the SQLite forum at Nabble.com.