I want to switch from Postgres to SQLite for a side project. Managed Postgres is an unnecessary expense, and introduces complexity which I don't want to deal with or troubleshoot. SQLite is simple and appropriate for my current needs. I believe a simple rsync script is enough to keep backups. I'm also attracted to the fact that the database is stored in the same file system in SQLite, instead of being a network request away for Postgres.<p>However, I am hosting the application via DigitalOcean App Platform, which has an ephemeral storage and lacks the ability to mount volumes. I looked into storing the file in DO Spaces (S3-like storage), but App Platform seems to lack the ability to install/run s3cmd to retrieve files. I also cannot easily curl the file over, because the Spaces files are private and require a new presigned URL which needs to be manually generated as needed.<p>I really like the App Platform's zero-downtime capabilities and minimal configuration hassle, but I don't like that I lack granular abilities to install what I want on the managed VM (such as s3cmd). I could switch to a droplet, but then I have to manually script the shutdown and startup sequence so that it pulls the db.sqlite file from Spaces on startup.<p>I'm a little frustrated that App Platform is just <i>barely</i> not compliant enough for me to run SQLite.
How to get gigs on Upwork. I've invested so much time into it and it's not paying off so far.<p>I want to be one of the successful guys on there. I feel stuck.