Interesting.... I read somewhere that Google added full text search to sqlLite codebase recently (last 6 months)?
On 14/07/07, viktoras didziulis <[EMAIL PROTECTED]> wrote:
one more alternative - works very fast - use sqlite in-memory database: 1) download sqlite3 command-line executable 2) run shell (cmd on windows) and create an in-memory database by executing: sqlite3 :memory: 3) assuming your data consists of 4 fields (columns) that are tab delimited and stored in file table.csv type or copy paste and execute the following commands in your sqlite3 session: create table myTable (a varchar, b varchar, pepMass float, d integer); .separator \t .import table.csv myTable 4) Now all you need to do is to store a list of update statements like this in text file (lets name it q.sql): UPDATE myTable SET a='whatever', b='whatever', d='100' WHERE pepMass BETWEEN 2267.0000 AND 2267.9999; UPDATE myTable SET a='whatever', b='whatever', d='1000' WHERE pepMass BETWEEN 2268.0000 AND 2268.9999; and 5) execute the following sql string in sqlite: .read q.sql 6) Thats it. Now you can get your result: .output myTable.csv SELECT * FROM myTable; .output stdout Here you can use Revolution to create a list of multiple UPDATES :-). But I do not know how to use in memory sqlite database directly from Revolution :-(. Viktoras . _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
