How are you storing your data?

I'm guessing some sort of sqlite file? If so you can just ssh into your service and retrieve the file

that way you have all the database data and you can either move it to a persistent storage directory or port it over to a database like PG

Before you do that, you will need to follow Fragly's instructions to retrieve your database file so you don't lose data when you redeploy.

I can't see the sqlite file anywhere. Neither on github nor on Railway. Where can I see that?

https://docs.railway.com/reference/cli-api#ssh

Follow these docs, specifically the ssh section

Do you know if it is an SQLite file though? if you're storing the sessions in memory then you might be cooked

I am not sure

we can't really tell you where you're storing your data though only you'd know that

They said they use sqlite in the initial question

But if I am storing it in memory then how is it working fine? It has been 2 days now

So I'm leaning on that possibility. If they're storing anything in memory it will be gone on a restart without any way to retrieve the data

storing it in memory will work forever, until you redeploy

oh yea

So no way to retrieve it? I have like 250 users now

I don't want them to be gone

But even that is erasing on every redeployment

if you did store it in memory then yea retrieval is impossible

though to be clear that's not a railway problem
even if you hosted this on your own machine, if you stored it in memory then retrieval would've never been possible
it's not really a limitation on Railway, it's just a limitation of computers
-# Technically it is retrievable but it's next to impossible, it's like reconstructing a dollar note that's been burned to ash, technically possible but not realistically doable

If you did store it in sqlite like you said then you just need to find your sqlite file

Let's simplify this a bit, I think we're going off on a bit of a tangent talking about possibilities that may not be the case

You mentioned you stored your data in a sqlite database. Let's start there

Use the Railway CLI from the link I sent to retrieve the sqlite file

Follow the docs I linked

I don't know if I "stored" it into sqlite. There is no persistent storage. I just used sqlite python library to deal with it.

Ok

are you talking about sqlite3?

yes

you are storing it in a file

mycptrainer.db

i am doing this exactly so i feel a file called mycptrainer.db should be created

but i cant see it anywhere

how are you looking at your files?

on github/railway

github would only hold your code it wouldn't hold the database, unless you're pushing it to github which you shouldn't be doing

on Railway, you should SSH into your service and go through your files, have you been doing that?

going through the docs to do it now

perfect

btw if it is a file why it is clearing on each instance of redeployment

Railway deployments deploy your code into a container which is a small virtual machine that's set up to run your code
that virtual machine is destroyed and recreated whenever you redeploy because each deployment needs to create a new virtual machine for your code to run in
that means anything stored on that machine is destroyed including all your files

the way you workaround this is by adding volumes to your service
volumes allow you to store data in a directory that'll never be removed (unless you remove it)

I'm gonna head to bed soon so I'll summarize what you'll need to do from here

** Retrieving your DB**

1. SSH into your service

2. Find your sqlite file, then retrieve its contents somehow - perhaps you can upload it somewhere via CLI or something

3. Make sure you have the full database on your pc before continuing

*Re-adding your DB (assuming you want to keep using SQLite)

1. insert the Filebrowser template into your project

2. set USE_VOLUME_ROOT to 1

3. Log into it and upload your db file

4. Disconnect the volume

5. Connect the volume to your service (you can mount it to something like /app/data or whatever, update the sqlite3.connect path accordingly)

If you want to use something other than SQLite, which I'd recommend tbh, then you'll need to port it over to your chosen database, that's a bit more work so I can't explain that in text here

After that, confirm that everything is in working order, make sure the data does persist and everything to prevent a future situation like this

I'll be around if you need help once Fragly is gone, but please do read the docs and attempt to SSH into your deployment as a first step.

Thanks!

why this issue btw? I linked to my project but during ssh it says it isnt linked?

You do not need the project, environment, and service flags in the ssh command

then how do i view the ssh without it

???

i got it

got the database

thanks a lot!

glad to hear it

!s