How to view changes in the database sqlite?
gostrong11
HOBBYOP

2 years ago

I deployed the project (telegram bot) through GitHub and there is a .dp file there, all changes on the server are saved, but when I want to download the database and look, it is not updated on GitHub, how can I see all the changes in the database??

21 Replies

gostrong11
HOBBYOP

2 years ago

1c4b9758-1370-43f9-921d-fdac6f01f7da

brody
EMPLOYEE

2 years ago

GitHub to railway is a one way train, are you using a volume?

gostrong11
HOBBYOP

2 years ago

no(

brody
EMPLOYEE

2 years ago

you would need to use a volume for data persistence

gostrong11
HOBBYOP

2 years ago

how to do it? I'm new to this topic, please help

brody
EMPLOYEE

2 years ago

brody
EMPLOYEE

2 years ago

its not going to allow you to see the database but it will enable data persistence

gostrong11
HOBBYOP

2 years ago

thanks

gostrong11
HOBBYOP

2 years ago

should I connect volume ./user_data?

brody
EMPLOYEE

2 years ago

that would not be a valid path for a volume mount

brody
EMPLOYEE

2 years ago

where do you write your database file to?

gostrong11
HOBBYOP

2 years ago

my file in github repositories user_data

gostrong11
HOBBYOP

2 years ago

user_data, bot.py, worker

brody
EMPLOYEE

2 years ago

user_data is a folder?

gostrong11
HOBBYOP

2 years ago

no, is user_data.dp everything in one directory

brody
EMPLOYEE

2 years ago

you would need to move it into a subfolder like a data folder

brody
EMPLOYEE

2 years ago

then you can mount the volume to /app/data

gostrong11
HOBBYOP

2 years ago

bot.py
worker
-----folder data----
user_data.db

?

brody
EMPLOYEE

2 years ago

.
├── bot.py
├── worker
└── data/
    └── user_data.db
brody
EMPLOYEE

2 years ago

yes

gostrong11
HOBBYOP

2 years ago

thanks

Loading...