0

I've done a small school project to manage a library with several books, using SQLite and android 2.2. Later on, they asked me to create a back office system, which I wasn't ready for. So I'm trying to achieve a simple backup system that connects to the internet.

I would like directions or hints to:

  1. Get the project database from data/data/package_name/databases/school
  2. Send it to a online repository, could be just a ftp connection to upload school_%date% and latest.db (same contents)

and to restore:

  1. Download latest file from server, something like http://www.site.com/school/latest.db
  2. Replace data/data/package_name/databases/school with the downloaded latest.db

I been reading about SOA and REST approaches but I couldn't implement that on the trivial server I own... any other advices? /cheers

Guido
  • 46,642
  • 28
  • 120
  • 174
Bruno Tereso
  • 227
  • 1
  • 5
  • 15

1 Answers1

0

SOA or REST would be the most pretty way to do it. The easy way is just to get the database file and send it to you webserver. But I don't know if your app has enough privileges to restore the database while running. You could use the sqlite3 commandline tool to dump an sql file, see here and send it to your webserver. Restoring would be something the same, but then you have to delete your tables first, then restore the database with the retrieved data.

Maybe it would be nice to have some version dependency management like sending your app version with the backup. This way you can administer whether a database file is compatible or not.

Community
  • 1
  • 1
Jordi
  • 1,357
  • 12
  • 20
  • I have a backoffice layout in the project, the main idea is giving the admin user the possibility to backup the DB himself, directly from the device, I believe I can't use command line tool to accomplish it. Guess I need to dig more into SOA and REST... thanks – Bruno Tereso Aug 30 '11 at 21:47