how to copy a sqlite3 table to another file in python

Posted by james on Stack Overflow See other posts from Stack Overflow or by james
Published on 2011-01-15T15:47:35Z Indexed on 2011/01/15 15:53 UTC
Read the original article Hit count: 276

Filed under:

sqlite3

hey i was wondering how i could make a copy of a sqlite3 table and save it to a seperate file in python. im confused as in python your sqlite3 object can only be connected to one database so how would i make it save to a seperate database? the reason i want to do this is in sqlite3 the database file size can never get smaller, and ive made alot of changes so i want just copy this table to another file which wont have all the extra empty space and then delete the origonal database thanks guys

Related posts about sqlite3

ruby1.9.1 - sqlite3 problem on ubuntu 9.10 x64 (no such file to load -- sqlite3)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have problem with sqlite3, because it is not working. irb(main):001:0> require 'sqlite3' LoadError: no such file to load -- sqlite3 from (irb):1:in `require' from (irb):1 from /usr/bin/irb:12:in `<main>' I have installed following packages: sudo apt-get install ruby1… >>> More
python sqlite3 won't execute a join, but sqlite3 alone will

as seen on Stack Overflow - Search for 'Stack Overflow'
Using the sqlite3 standard library in python 2.6.4, the following query works fine on sqlite3 command line: select segmentid, node_t, start, number,title from ((segments inner join position using (segmentid)) left outer join titles using (legid, segmentid)) left outer join numbers… >>> More
Snow Leopard upgrade -> reinstalling sqlite3-ruby gem problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I got ruby 1.8.7 (native compiled), rails 2.3.4, OSX 10.6.2 and also sqlite3-ruby. The error I'm getting when accessing the rails app is NameError: uninitialized constant SQLite3::Driver::Native::Driver::API History: I upgraded to snow leopard by migrating my apps with a FW-cable from… >>> More
Compile PHP Error with freetype

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey Guys, I configured PHP myself, included all of the libraries I needed... but then realized I forgot the freetype library. So I went back to my php-5.3.2 directory and ran ./configure '--with-free-type=/usr/local/lib' PHP did the configure fine, no errors. But when I run make: collect2: ld… >>> More
how to enable sqlite3 for php?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to install sqlite3 for php in ubuntu. I install apt-get php5-sqlite3 and edited php.ini to include sqlite3 extension. When I run phpinfo(); I get SQLITE3 SQLite3 support enabled sqlite3 library version 3.4.2 as shown above, sqlite3 is enabled. However, I get "Class SQLite3… >>> More

Developer IT