Before you begin

In this tutorial will learn how to create, backup and restore a SQLite database using Docker. A Linux machine and Docker will be required to follow this tutorial.

Create a Docker SQLite Docker image


FROM alpine:3.4
RUN apk add --update sqlite
RUN mkdir /db

ENTRYPOINT ["sqlite3"]
CMD ["test.db"]

Command to build an image using previous Dockerfile (make sure you are on the same folder):

docker build -t some-sqlite .

Create a SQLite database using docker

Run the previous image to create a database called test.db:

docker run --rm -it -v `pwd`:/db some-sqlite test.db

Inside of the container run the following command to create a table, insert values and select them:

sqlite> create table test_table(id int, description varchar(10));
sqlite> insert into test_table values(1, 'foo');
sqlite> insert into test_table values(2, 'bar');
sqlite> select * from test_table;

You can find more SQLite commands here.

Backup a SQLite database using Docker

Command to backup test.db to a dump.sql file on host:

docker run --rm -it -v `pwd`:/db some-sqlite test.db .dump >> dump.sql

Restore a SQLite database using Docker

Before restoring the database make sure that the destination database is empty (moving current database to .old):

mv test.db test.db.old

Command to restore test.db database:

cat dump.sql | docker run --rm -i -v `pwd`:/db some-sqlite test.db