what would you need to do to be able to deploy this app so that is still updates the database file but it can be accessed from any device with a url? i'm a student working on a very similar project with SQLite, python and Html and it works great when i test it locally but i need to be able to access it from multiple devices and when i deploy it on free hosting platform like Render, none of my changes actually update in the database... i'm assuming that is because i am using free instances that spin down with inactivity and therefore loose all the data generated during that instance but would there be a way to connect the database to a cloud and save changes that way without having to pay anything extra?
There are very few free deployment options out there. My recommendation would be to try out Heroku. Instead of using SQLite, you will probably have to switch to a Postgres or MySQL Database. But these are hosted by Heroku which will prevent data loss. You may still need to pay for Heroku, but it will likely be on the cheaper side and it works really well for flask and Django applications. On that note, SQLite is best for local applications and testing.
Hi Aditya, thank you for taking the time to comment on the video. It is a little bit more of an advanced concept. I personally could have made the video simpler, but if anyone at the beginner level has questions, I’m happy to answer.
Thanks for the tutorial.
Do you have a link for the source code?
what would you need to do to be able to deploy this app so that is still updates the database file but it can be accessed from any device with a url? i'm a student working on a very similar project with SQLite, python and Html and it works great when i test it locally but i need to be able to access it from multiple devices and when i deploy it on free hosting platform like Render, none of my changes actually update in the database... i'm assuming that is because i am using free instances that spin down with inactivity and therefore loose all the data generated during that instance but would there be a way to connect the database to a cloud and save changes that way without having to pay anything extra?
There are very few free deployment options out there. My recommendation would be to try out Heroku. Instead of using SQLite, you will probably have to switch to a Postgres or MySQL Database. But these are hosted by Heroku which will prevent data loss. You may still need to pay for Heroku, but it will likely be on the cheaper side and it works really well for flask and Django applications.
On that note, SQLite is best for local applications and testing.
Hi, is there any chance you could share the code with me? Working on a project similar to this.
Hey! It’s been a while since this video was recorded. I’ve since deleted the code. Would have probably been a good idea to keep it 😅
@@SQLPro1 Aww no bother, thanks anyway.
Bro a beginner won't be able to understand anything
Hi Aditya, thank you for taking the time to comment on the video. It is a little bit more of an advanced concept. I personally could have made the video simpler, but if anyone at the beginner level has questions, I’m happy to answer.
@@SQLPro1 I understand your point completely , not an issue ...