Thanks. -----Original Message----- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Monday, December 18, 2006 8:32 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a method for doing bulk insertion?
On 12/18/06, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > I was hoping there was the equivalent of Sybase's BCP program. I was > also hoping something programmatic was available, i.e., not something > from the command shell. Maybe a little background would help. > > I'm planning on using the perl package DBD::SQLite. My department is a > big sybase user but because of the nature of our workload, we experience > a lot of contention in both the transaction log and tempdb (the database > that houses temporary tables). I'm investigating the feasibility of > transferring data into SQLite, doing all the data manipulations there, > and then transferring it back to the appropriate sybase tables. I > suspect this could be a big win for a number of our applications. > > But if it can be avoided, I don't want to do a CSV conversion, nor do I > want to shell out of the code to invoke this. I created a c++ version for my own use. The source code is downloadable if that's of any help to you. See my sig line for the address. -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- -------------------------------------------------------- NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------