On Wed, Jul 08, 2009 at 07:19:02PM +0530, _h_ scratched on the wall: > Hi Jay, > Its nice to hear that you already did that. > > > If you're willing to write a bit of code, you can do whatever you want. > I can do that, can share some idea how it can be done.
Read up on how build a virtual table: http://www.sqlite.org/cvstrac/wiki?p=VirtualTables http://www.sqlite.org/cvstrac/wiki?p=VirtualTableMethods You will likely want to write your virtual table module as a loadable extension. See: http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions To parse a text file, just have the xNext method read the next line and parse it out for any calls to xColumn. You can pretty much ignore xBestIndex and xFilter, and have xUpdate throw an error. xRowid can be the line number in the file. I don't have the code anymore, otherwise I'd be happy to post the Apache parser I did. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
