Re: [sqlite] Need sql query help

On Sun, 25 Jun 2006 18:24:50 -0700 (PDT), onemind wrote: >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.

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

Re: [sqlite] Need sql query help

On Sun, Jun 25, 2006 at 07:54:13AM -0700, onemind wrote: > 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. The quick and dirty way to do this using a sqlite would be to keep a separate column from

Re: [sqlite] Need sql query help

A. Pagaltzis wrote: * onemind <[EMAIL PROTECTED]> [2006-06-25 17:00]: 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. 200,000 words is nothing. If they’re 5 letters on average, that’s some 1.1MB

Re: [sqlite] Need sql query help

Ulrik Petersen wrote: Hi, responding to myself... Ulrik Petersen wrote: onemind wrote: 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

Re: [sqlite] Need sql query help

* onemind <[EMAIL PROTECTED]> [2006-06-25 17:00]: > 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. 200,000 words is nothing. If they’re 5 letters on average, that’s some 1.1MB of data. You can

Re: [sqlite] Need sql query help

* Ulrik Petersen <[EMAIL PROTECTED]> [2006-06-25 17:55]: > 5) Use the function with the regex '[spqd]' to search for words > containing the letters "s", "p", "q", OR "d". Doing it for all > letters (AND) may be doable with a single regex, It is doable with an NFA engine like PCRE, but it’s

Re: [sqlite] Need sql query help

onemind wrote: 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

Re: [sqlite] Need sql query help

A. Pagaltzis wrote: * onemind <[EMAIL PROTECTED]> [2006-06-25 16:05]: 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". SELECT * FROM words WHERE word LIKE '%q%' AND word

Re: [sqlite] Need sql query help

onemind wrote: 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

Re: [sqlite] Need sql query help

onemind wrote: 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

Re: [sqlite] Need sql query help

onemind <[EMAIL PROTECTED]> writes: > 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? Take a look at the Controllable Regex Mutilator, CRM114, . It has

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

Re: [sqlite] Need sql query help

* onemind <[EMAIL PROTECTED]> [2006-06-25 16:05]: > 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". SELECT * FROM words WHERE word LIKE '%q%' AND word LIKE '%d%'

[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