2 years ago
I have a version of my bot that doesn't store data in a database but rather in a SQLite file (to make self hosting easier for people who don't like to trouble themselves with postgres). Currently it runs npx prisma db push on startup to create the file/make sure it exists, but will the file remain if the service is redeployed? I can already guess what the answer is but I just want to make sure
10 Replies
2 years ago
N/A
2 years ago
will the file remain if the service is redeployed?
yes as long as you store the sqlite file in a volume
2 years ago
Great. I gotta update the guide to include this though. For the people hosting at railway at least, even tho I recommend a vps
2 years ago
make a template that includes postgres?
2 years ago
It's a separate branch on github, the dbless one. I don't have any railway templates but with how straightforward it is it shouldn't be hard to self host either one
2 years ago
The one with a db is preferred cuz it makes my life easier but I can't exactly cut off people who don't know how to manage/setup one
2 years ago
making a template is preferred, since you would then get kickback
2 years ago
I know, I just don't really like that + I don't need it, am good
2 years ago
Thx for the suggestion tho
2 years ago
no worries