I have been looking for a way to back up my app's database which is hosted by heroku. It uses an sqlite database. What I am looking for is a way to add a button on my site which will allow me to download the database as an sqlite file. I am sure there is some simple fix I am overlooking but it would be great if somebody could point me in the right direction.
Asked
Active
Viewed 586 times
1
-
1Using SQlite on Heroku is really dangerous because as soon as the process completes, all your data will be lost. Is there a reason you are not using the free Postgres database that Heroku provides? – Oct 10 '12 at 19:50
-
It was my first heroku app and my first rails app at the time. The point of the backup is so that I can migrate to postgres. Also, the process has been restarted many times and I have not lost my data so I do not think you are right about that. – Danny Dyla Oct 10 '12 at 20:04
-
SQLite can be in-memory, or on disk. I'd say it's using the on-disk option. – Greg Oct 10 '12 at 21:31
-
Heroku apps usually cannot use sqlite3 databases. Sure about that fact? – Oct 11 '12 at 08:02
-
actually no. but my yaml file says it is configured that way. I suppose it would be easy for heroku to override that yaml file when i push to their servers. – Danny Dyla Oct 11 '12 at 14:51