How to download file from heroku hosting?

Question

Python

Hello, I have a telegram bot that collects the name and phone number into a database, and then I have to view this database, but a problem arises. Since the script is hosted by heroku, I don't know how to download this sqlite3 database.

PS Everything is saved to the sqlite3 database, that is, to the users.db file

Answer 1

https://sqlitebrowser.org/dl/ - viewing the sqlite database
https://losst.ru/komanda-find-v-linux - how to search files in linux
but all this is nonsense, because
Disk backed storage
SQLite runs in memory, and backs up its data store in files on disk. While this strategy works well for development, Heroku's Cedar stack has an ephemeral filesystem. You can write to it, and you can read from it, but the contents will be cleared periodically. If you were to use SQLite on Heroku, you would lose your entire database at least once every 24 hours.
Even if Heroku's disks were persistent running SQLite would still not be a good fit. Since SQLite does not run as a service, each dyno would run a separate running copy. Each of these copies need their own disk backed store. This would mean that each dyno powering your app would have a different set of data since the disks are not synchronized.
Instead of using SQLite on Heroku you can configure your app to run on Postgres.