Access sqlite file

I am trying to access the production.sqlite data in the attached volume

flyctl ssh sftp get ./app/sqlite3:/mnt/namei/production.sqlite says file not found, but flyctl ssh sftp find ./app/sqlite3:/mnt/namei/production.sqlite locates the file. Is there any other approach to doing this?

or is there a sqlite variant for flyctl postgres connect

1 Like

I am experiencing the same issue, but have found a work-around.

The file is there:

$ flyctl -a xxxx ssh sftp find /usr/app/data
Update available 0.0.441 -> v0.0.442.
Run "flyctl version update" to upgrade.
/usr/app/data
/usr/app/data/lost+found
/usr/app/data/noco.db

but i saw same issue as you when using get, says file not found:

$ flyctl -a xxx ssh sftp get /usr/app/data/noco.db
Update available 0.0.441 -> v0.0.442.
Run "flyctl version update" to upgrade.
Error get: local file /usr/app/data/noco.db: open /usr/app/data/noco.db: no such file or directory

However shell works fine!

$ echo 'get /usr/app/data/noco.db' | flyctl -a xxx ssh sftp shell
get //usr/app/data/noco.db -> noco.db
wrote 4161536 bytes

Any chance someone from support can look into this? The issue is specific to ‘sftp get’.