Re: [sqlite] Optimized way of export/import of the sqlite database through C API Interface

2008-01-11 Thread Jay Sprenkle
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Source code is there to download. - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Optimized way of export/import of the sqlite database through C API Interface

2008-01-10 Thread Ken
Hi Prameeth, Just cut and past the shell.c routines: open_db shellstaticFunc appendText run_table_dump_query dump_callback run_schema_dump_query <- this is the top level routine Look at the code for dump command to dump everything use: run_schema_dump_query(p, "SELECT name,

[sqlite] Optimized way of export/import of the sqlite database through C API Interface

2008-01-09 Thread Prameeth Sreesha
Hi, I have an application that has to provide an export/import feature of the sqlite database. I have achieved the export through the normal "Select * >From TABLENAME" to export the database. I went through the C API Documentation reference but did not come across any such API. If there are APIs