Hi there, This Talend you mentioned caught my eye. Can one use this tool as a general database browser tool. Palmer
> Date: Mon, 29 Jun 2009 08:56:58 -0700 > From: g...@talend.com > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] importing data to sqlite from stdin > > > What you could use is an open source ETL that has connectors with Sqlite. > > Talend Open Studio is an open source ETL tool for data integration and > migration experts. It's easy to learn for a non-technical user. What > distinguishes Talend, when it comes to business users, is the tMap > component. It allows the user to get a graphical and functional view of > integration processes. > > For more information: http://www.talend.com/ > > > > Robert Citek-2 wrote: > > > > On occasion I have had a need to import large amounts of data from > > standard input via a pipe. Here's an example of how to import from a > > pipe using sqlite3 on Ubuntu: > > > > $ { grep -v '^#' <<eof > > # create the table > > create table foo (bar int) ; > > eof > > } | sqlite3 foo.sqlite > > > > $ seq 1 1000000 | sqlite3 foo.sqlite '.imp "/dev/stdin" "foo"' > > > > $ sqlite3 foo.sqlite 'select count(*) from foo; ' > > 1000000 > > > > Regards, > > - Robert > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > View this message in context: > http://www.nabble.com/importing-data-to-sqlite-from-stdin-tp24256696p24256851.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _________________________________________________________________ Hotmail® has ever-growing storage! Don’t worry about storage limits. http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage_062009 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
