I’ve successfully created a container that has a Python program that received data from a serial port and writes it down to an SQLite database. The database is created, I guess, automatically by the Python script when you launch the sqlite3.connect() method. When I was testing the code on my DEV en…

Good evening Nico, I would store the db-file outside of the container. This is also a good point for data-persistence because a container might be killed and recreated resulting in loosing your sqlite.db otherwise. So copy the db-file from the existing container (because it is already filled with …

Thanks, that helps! Just one question. You mentioned copying a database from the outside but, after having added/deleted row/columns, or updated the database copied inside the docker container, does it update also the database outside the container?

Don’t know if I got your question right: You are copying the sqlite.db from within the container to your Docker-host. Then you recreate the container and mount (not copy) the sqlite.db (now residing on the Docker-host) into the new container - so the file usable file inside the container and the o…

Ok, I may have understood. Since I need, after launching the container, that everything should be done autonomously, is it possible to load the volume, even if it’s empty, and then my script will create sqlite.db if not existing on the volume or it will use the already existing one?

Or instead of mounting the single sqlite.db-file into the container you can mount a directory into the container. Within the container you can create the sqlite.db-file as usual.

I think mounting an empty directory and then using it to create/store the sqlite.db is the best solution. Thanks for the head up, I’ll give it a try

Accessing a db inside a docker container

General

matthiasradde (Matthias Radde) October 6, 2021, 1:48pm 6

If you mount a non-existing file into a container it will not work: a directory named as your non-existing file is created on your Docker-host.
So for sqlite you have to create an empty file before starting the container for the first time - otherwise you will run into problems described above.

Topic		Replies	Views
Accessing a .db file in a volume with DBeaver software General docker	1	1399	January 24, 2022
Accessing data in Sqlite3 Docker Desktop	0	1080	January 14, 2023
Python code with sqlite3 file, saving changes to the db General docker	2	713	January 11, 2022
Attempting to save database information on host machine General	6	1168	January 31, 2023
Copy/migrate database from running container General docker	1	1077	June 8, 2021

Accessing a db inside a docker container

Related topics