Expose SQLite db to external ORM connections

[andrei-cucea]

After a lot of search I stumbled upon this post which achieved pretty much the same results that you were looking for.

Make sure you are locally in the correct app folders when running the flyctl commands. Also make sure once you connect to the fly ssh console to change the directory to your app folder before running the prisma studio command.

Using wireguard to display a table like structure for stored prisma sqlite db.

I was able to get Prisma studio on my deployed instance working locally! First, in one terminal tab I ran: fly proxy 3001:5555 Then, in a separate tab, I ssh’d into my app: fly ssh console cd your-app-name npx prisma studio I didn’t see anything after that, so wasn’t sure it worked, but sure enough, I opened a browser to http://localhost:3001 and there was my prod data. Not too long after I got an email saying my instance had run out of memory and crashed . I guess prisma uses a lo…

Did you manage to find a more elegant way of achieving this outcome?