Docker & Sqlite3 backup. Volume manipulation

sqlite3.Dockerfile

# docker build -f sqlite3.Dockerfile -t sqlite3:local .
# docker run --rm -it -v sqlite-db-volume:/db sqlite3:local my_app.db

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

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

# Backup
# docker run --rm -it -v sqlite-db-volume:/db sqlite3:local my_app.db .dump >> dump.sql
# OR (not using file direclty)
# docker run --rm -it -v $(pwd):/dump -v sqlite-db-volume:/db alpine:latest cp /db/my_app.db /dump

# Restore 
# cat dump.sql | docker run --rm -i -v sqlite-db-volume:/db sqlite3:local my_app.db
# OR inverse operation of copy

sqlite3.sql

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