Railway•3w ago

How to view changes in the database sqlite?

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??

Solution:

https://docs.railway.app/guides/volumes

Jump to solution

17 Replies

Percy•3w ago

Project ID: 1c4b9758-1370-43f9-921d-fdac6f01f7da

Crabi•3w ago

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

Brody•3w ago

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

Crabi•3w ago

no(

Brody•3w ago

you would need to use a volume for data persistence

Crabi•3w ago

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

Solution

Brody•3w ago

https://docs.railway.app/guides/volumes

Brody•3w ago

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

Crabi•3w ago

thanks should I connect volume ./user_data?

Brody•3w ago

that would not be a valid path for a volume mount where do you write your database file to?

Crabi•3w ago

my file in github repositories user_data user_data, bot.py, worker

Brody•3w ago

user_data is a folder?

Crabi•3w ago

no, is user_data.dp everything in one directory

Brody•3w ago

you would need to move it into a subfolder like a data folder then you can mount the volume to /app/data

Crabi•3w ago

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

Brody•3w ago

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

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

yes

Crabi•3w ago

thanks

Gaming

Programming

How to view changes in the database sqlite?