SQLite 3 Docker Compose

While we are talking about docker-compose powered databases, here is SQLite 3. Because, why not?

docker-compose -f ~/desh/docker-composers/sqlite3/docker-compose.yml up --build -d;

Contents of your docker-compose.yml file:

version: '3'

services:
  sqlite3:
    container_name: sqlite3_container
    image: nouchka/sqlite3:latest
    stdin_open: true
    tty: true
    volumes:
      #Modify following line
      - path-to/your/databases/sqlite3:/root/db/
    ports:
      - '9000:9000' # expose ports - HOST:CONTAINER
    restart: unless-stopped

Comments

Hello Mustafa,
I used your docker compose file to setup a SQlite3 on a ubuntu server 20.04.
It worked well thanks for share it.
Using docker shell console I create database and tables.
I have also install on docker node-red, and I want to use node-red to work with the database.
Here comes my problem, that I node-red can't access the database.
this is the error message:
Node-Red failed to open /home/iot/IOTstack/volumes/sqlite3/nodered.db
I give the r/w permissions to the database.

Can you point me how to fix this?
Thanks for your time

mustafabugra says:

09/01/2021 at 23:48

Hello Lucian,
As far as I know, that may be because of several reasons. One of them is permissions, not your user but docker needs to have access to proper volumes.
Also someone had a similar problem like yours in stackoverflow. Link (Not inside docker though.)
If you can share your compose file, I can try to recreate your problem.

Have a nice day.

Reply

Hello Mustafa,
I got errors with this container:
"sqlite3_container exited with code 1". Please help.