where does my sqlite database live?

I recently cloned and deployed this repo: GitHub - remix-run/indie-stack: The Remix Stack for deploying to Fly with SQLite, authentication, testing, linting, formatting, etc.

Everything works fine but I am not sure where my database is and how to access it.

On the readme file it says the following: The sqlite database lives at /data/sqlite.db in your deployed application. You can connect to the live database by running fly ssh console -C database-cli.

But I dont want the terminal view, Is there a way to view the table like the way I do with prisma during development?

1 Like

Did you have any luck finding this out? I have the same question.

1 Like