keinos/sqlite3

SQLite3 Docker镜像

基于最新源代码构建的SQLite3 Alpine Docker镜像。

bash
docker pull keinos/sqlite3:latest

特性

• 当前SQLite3版本：
  • https://img.shields.io/endpoint?url=https%3A%2F%2Fraw.githubusercontent.com%2FKEINOS%2FDockerfile_of_SQLite3%2Fmaster%2FSQLite3-shields.io-badge.json](https://github.com/KEINOS/Dockerfile_of_SQLite3/blob/master/VERSION_SQLite3.txt)
  • https://hub.docker.com/r/keinos/sqlite3/tags @ DockerHub
• 支持架构：
  • Arm64、Armv6、Armv7及Intel/AMD64
• INIT系统支持：
  • https://github.com/krallin/tini%EF%BC%88%E4%BF%AE%E5%A4%8D%EF%BC%9Ahttps://github.com/KEINOS/Dockerfile_of_SQLite3/pull/65%EF%BC%89
• 扫描状态：
  • https://github.com/KEINOS/Dockerfile_of_SQLite3/actions/workflows/container-analysis.yml/badge.svg](https://github.com/KEINOS/Dockerfile_of_SQLite3/actions/workflows/container-analysis.yml)
  • https://github.com/KEINOS/Dockerfile_of_SQLite3/actions/workflows/container_scan.yml/badge.svg](https://github.com/KEINOS/Dockerfile_of_SQLite3/actions/workflows/container_scan.yml)

使用方法

拉取最新镜像

shellsession
$ docker pull keinos/sqlite3:latest
**snip**

指定版本拉取

shellsession
$ docker pull keinos/sqlite3:3.44.2
...

• https://hub.docker.com/r/keinos/sqlite3/tags @ hub.docker.com

本地构建

shellsession
$ docker build -t sqlite3:local https://github.com/KEINOS/Dockerfile_of_SQLite3.git
...

交互模式

在容器内交互式运行sqlite3命令：

shellsession
$ docker run --rm -it -v "$(pwd):/workspace" -w /workspace keinos/sqlite3
SQLite version 3.28.0 2019-04-16 19:49:53
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .open ./sample.db
sqlite> CREATE TABLE table_sample(timestamp TEXT, description TEXT);
sqlite> INSERT INTO table_sample VALUES(datetime('now'),'First sample data. Foo');
sqlite> INSERT INTO table_sample VALUES(datetime('now'),'Second sample data. Bar');
sqlite> .quit
$ ls
sample.db

• 注意：需将工作目录挂载为容器卷。

命令执行

• 运行sqlite3 --version命令：

shellsession
$ docker run --rm keinos/sqlite3 sqlite3 --version
3.38.2 2022-03-26 13:51:10 d33c709cc0af66bc5b6dc6216eba9f1f0b40960b9ae83694c986fbf4c1d6f08f

• 对挂载的数据库执行SQL查询：

shellsession
$ ls
sample.db
$ docker run --rm -it -v "$(pwd):/workspace" keinos/sqlite3 sqlite3 /workspace/sample.db -header -column 'SELECT rowid, * FROM table_sample;'
rowid  timestamp            description
-----  -------------------  -----------------------
1      2022-04-16 14:09:52  First sample data. Foo
2      2022-04-16 14:09:58  Second sample data. Bar

• 注意：需将工作目录挂载为容器卷。

运行测试

容器包含https://github.com/KEINOS/Dockerfile_of_SQLite3/blob/master/run-test.sh%EF%BC%8C%E5%8F%AF%E9%AA%8C%E8%AF%81%E5%AE%B9%E5%99%A8%E5%8F%8A%60sqlite3%60%E4%BA%8C%E8%BF%9B%E5%88%B6%E6%96%87%E4%BB%B6%E6%98%AF%E5%90%A6%E6%AD%A3%E5%B8%B8%E5%B7%A5%E4%BD%9C%EF%BC%88%E4%B8%8D%E9%80%82%E7%94%A8%E4%BA%8EHEALTHCHECK%EF%BC%89%EF%BC%9A

shellsession
$ docker run --rm keinos/sqlite3 /run-test.sh
- Creating test DB ... created
rowid  timestamp            description
-----  -------------------  -----------------------
1      2022-04-16 14:18:34  First sample data. Hoo
2      2022-04-16 14:18:34  Second sample data. Bar
- Testing ...
  1st row value ... OK
  2nd row value ... OK

- Test result:
success
$ echo $?
0

• 如有测试需求，可https://github.com/KEINOS/Dockerfile_of_SQLite3/issues%E3%80%82

在Dockerfile中使用

若基于alpine构建镜像，可从本镜像复制sqlite3二进制文件：

Dockerfile
FROM keinos/sqlite3:latest AS sqlite3

FROM alpine:latest

COPY --from=sqlite3 /usr/bin/sqlite3 /usr/bin/sqlite3

ENV \
  USER_SQLITE=sqlite \
  GROUP_SQLITE=sqlite
RUN \
  addgroup -S $GROUP_SQLITE && \
  adduser  -S $USER_SQLITE -G $GROUP_SQLITE

... 执行其他操作 ...

待办事项

• DockerHub ARM支持（Issue #https://github.com/KEINOS/Dockerfile_of_SQLite3/issues/2%EF%BC%8CPR #https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/20%EF%BC%89

许可证

• Dockerfile：https://github.com/KEINOS/Dockerfile_of_SQLite3/blob/master/LICENSE.md%EF%BC%8C%E7%94%B1https://github.com/KEINOS/Dockerfile_of_SQLite3/graphs/contributors%E6%8F%90%E4%BE%9B%E3%80%82
• SQLite：公共领域，由D. Richard Hipp及SQLite.org提供。
• 容器中以下包使用GPL-3.0-or-later许可证：
  • GNU patch
  • GNU make
  • GNU dbm（gdbm）
  • Debian fakeroot
  • GNU Readline Library
  • GNU Tar