SQLite Export

Description

SQLiteExport is a program to easily export data from a SQLite database. You can enter database, outputfile name and output type, and specify a table or a custom sql command.

You can easily automate export tasks with SQLiteExport, as you can execute the program from within a batch file and have all freedom to specify custom sql commands.

SQLiteExport is available for Linux and Windows.

Features

Export from a SQLite database
Export formats: tabs, csv, xls, html, screen
Export a complete table or results from a custom sql command
Exporting data is very fast

Download

Download the executables and sourcecode here.

Windows executable (zip, 1.3 MB)

Linux executable (commandline only at the moment, zip, 180 KB)

C++ sourcecode (zip, 1.0 MB)

Screenshots

Click to enlarge the following screenshots.

Usage

User interface

Usage of the user interface is easy and intuitive: select a database, choose a filename for the output file. The correct mode is automatically selected. Then choose a table or enter a custom SQL command. Press "Export" and wait until the export is finished.

Command line program

The command line version of the program has the following syntax.

sqlite_export_cmd -database DATABASE -output FILENAME -table TABLENAME [-mode MODE]
sqlite_export_cmd -database DATABASE -output FILENAME -sql SQLCOMMAND  [-mode MODE]
sqlite_export_cmd -help

Available parameters:

-database DATABASE The name of the SQLite database.

-output FILENAME The filename of the output file.

-table TABLENAME Table name of the table to be exported.

-sql SQLCOMMAND A custom sql command

-mode MODE The output format, optional. If mode is not provided, the program guesses the right mode based on the extension of the filename. For MODE, choose from:

tabs A tab separated file

csv A command separated file

xls An Excel file

html A html file

screen Show results on screen

-help If parameter -help is provided, information about the usage is printed.

You have to choose one of the two parameters -table or -sql. If one of the parameter values contains spaces, enclose the parameter value with double quotes.

Examples:

sqlite_export_cmd -database data.db -output myoutput.xls -table mytable
sqlite_export_cmd -database data.db -output data.csv -sql "SELECT * FROM tbl;"
sqlite_export_cmd -database data.db -mode html -output page.html -table address
sqlite_export_cmd -database "other database.db" -mode screen -table addresses
sqlite_export_cmd -help

Code

The code is created in C++ and wxWidgets using the CodeBlocks IDE. The code is crossplatform and can be compiled for different platforms.

The source code contains two projects: one for the commandline program, and one for the user interface.

Author

This program is created by Jos de Jong.
May 2010