The SQLite command line provides several methods for exporting or backing up an entire database. One of those involves the .dump dot command.

The .dump command enables you to convert a whole database to a single ASCII text file. In other words, it renders the whole database as SQL. The text file contains all the SQL statements required to create the tables, insert data, etc.

You can also use .dump to create a compressed file. I outline both of these methods below.

Continue reading →

When using the SQLite command line shell, you can export your query results to a CSV file by using the .mode dot command in conjunction with the .output or .once commands.

You can also use the .system command to open that file.

Continue reading →

You can configure the SQLite command line interface to automatically open query results in a text editor.

When you do this, you have two options:

• Use a temporary file
• Use a permanent file (i.e. save it for later)

This article provides examples of both methods.

Continue reading →

The SQLite command line interface has a handy little feature where you can open your SQL query results in an Excel file.

When you run a query, instead of the query being output to your console as it normally would, it instead opens as an Excel spreadsheet (or LibreOffice, or whatever program your system uses to open CSV files).

You have two options when doing this:

• Use a temporary file
• Use a permanent file (i.e. save it for later)

This article covers both options.

Continue reading →