best practice for handling sqlite?
andreasthinks
HOBBYOP

a year ago

hey folks, looking for some advice... I quite like Railway for handling python webapps, and normally really like sqlite files, but I find I never quite know how to handle the database file.

So far I've just been putting it in a data subfolder and sticking it in a volume, but that makes modifying/interacting with it quite challenging - ideally I'd like to be able to interact it like a Postgres web interface, but as far as I know I can't do that on sqlite. Any suggestions or ideas?

Solved

1 Replies

a year ago

Hello,

Seems like you kinda answered it yourself -

ideally I'd like to be able to interact it like a Postgres web interface

So use Postgres! Can't go wrong with Postgres.

Sure it's obviously going to use more resources than a file on a disk, but honestly it's pretty resource efficiency compared to MySQL or MongoDB, and the extra bit spent on resources is going to be well worth it.


Status changed to Awaiting User Response Railway about 1 year ago


Railway
BOT

7 months ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway 7 months ago


Loading...