[sqlite] vitual tables
Hi, Can you give one simple example, about how to use "virtual tables" in sqlite3? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] general question
Hi, Does any mechanism is available via which I can bind the db with text file and can use the db apis to access that text file, and can perform the i/o. Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] general question
I am looking for some thing where via db apis I inform the format of my text file and then I can do open/close, read/write via db apis to interact with the underlaying text file. I require to access the text files, which has different formats, via unified apis. Thank you. On Wed, Jul 8, 2009 at 4:23 PM, Simon Slavin wrote: > > On 8 Jul 2009, at 11:40am, _h_ wrote: > > > Does any mechanism is available via which I can bind the db with > > text file > > and can use the db apis to access that text file, and can perform > > the i/o. > > For SQLite to be useful for you, the data must be in a SQLite database > file. You cannot manipulate data in a text file. > > If you want to import data from a text file to a database file, use > the sqlite3 command-line tool. See the documentation here to get > started using SQLite: > > http://www.sqlite.org/quickstart.html > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] general question
Hi Kishor, Thank your pointing out perl db module. Is the same things are avaiable as C/C++ apis. Thank you. On Wed, Jul 8, 2009 at 5:25 PM, P Kishor wrote: > On Wed, Jul 8, 2009 at 1:48 PM, _h_ wrote: > > I am looking for some thing where via db apis I inform the format of my > text > > file and then I can do open/close, read/write via db apis to interact > with > > the underlaying text file. > > I require to access the text files, which has different formats, via > unified > > apis. > > > > http://search.cpan.org/~jzucker/DBD-CSV-0.22/lib/DBD/CSV.pm > > > > Thank you. > > > > On Wed, Jul 8, 2009 at 4:23 PM, Simon Slavin < > slav...@hearsay.demon.co.uk>wrote: > > > >> > >> On 8 Jul 2009, at 11:40am, _h_ wrote: > >> > >> > Does any mechanism is available via which I can bind the db with > >> > text file > >> > and can use the db apis to access that text file, and can perform > >> > the i/o. > >> > >> For SQLite to be useful for you, the data must be in a SQLite database > >> file. You cannot manipulate data in a text file. > >> > >> If you want to import data from a text file to a database file, use > >> the sqlite3 command-line tool. See the documentation here to get > >> started using SQLite: > >> > >> http://www.sqlite.org/quickstart.html > >> > >> Simon. > >> ___ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > Puneet Kishor http://www.punkish.org > Carbon Model http://carbonmodel.org > Charter Member, Open Source Geospatial Foundation http://www.osgeo.org > Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor > Nelson Institute, UW-Madison http://www.nelson.wisc.edu > --- > Assertions are politics; backing up assertions with evidence is science > === > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] general question
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. Thank you. On Wed, Jul 8, 2009 at 7:12 PM, Jay A. Kreibich wrote: > On Wed, Jul 08, 2009 at 11:53:13AM +0100, Simon Slavin scratched on the > wall: > > > > On 8 Jul 2009, at 11:40am, _h_ wrote: > > > > > Does any mechanism is available via which I can bind the db with > > > text file > > > and can use the db apis to access that text file, and can perform > > > the i/o. > > > > For SQLite to be useful for you, the data must be in a SQLite database > > file. You cannot manipulate data in a text file. > > If you're willing to write a bit of code, you can do whatever you > want. I've written virtual-table extensions that can read Apache > logs, one for Squid web-cache logs, and several for various binary > file formats we used at my last job. It's hugely useful to just > attach the database to the existing log files (including live files) > on the occasions I needed to search for stuff, rather than import > the files first. In the case of the binary files, performance was > actually better than imported data (nearly all our queries required > full table scans). > > I've never done a virtual-table that supported writing to a > text-based file format, but there is no reason why it couldn't be > done. > > -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 > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Which is faster raw file I/O or sqlite BLOB
Hi, I am planning to use BLOB to store file contents. So can you please suggest, which is faster 'raw file I/O' or 'sqlite BLOB'. Thank you in advance. -H ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users