1

I need to build a web app that has to be "universal". By universal I mean that I need it to be available online and offline, and usable on mobile platform and pc's and mac.

I need to store and retrieve the info and I want the app to be updated when its online.

Since I need to port the info to a SQL database I thought about building an CMS that would build the app for each client using the SQL database. That app would run with a Nosql Db in the background that would return the data to the master (couchdb) and then I would take that info and parse it to store it in the SQL Database ...

I thought using the couchdb engine would be the best solution because I need the data to be available online and offline.

The question now ...

  • First is it a good idea?
  • Any other suggestions I could build on?(can be anything)
  • Is the hybrid solution a good idea?
  • What offline storage easily replicable I could use for a web app ( easy to install at the client facilities?)
2

You can target HTML5 browsers and use local storage to store the data for offline use. These articles give pointers on how to synchronise the local and central storage.

| improve this answer | |
  • its a good solution but i need it to be linked to the master db at my work. – Lunatikzx May 18 '12 at 14:36
  • I've updated my answer. – paulmorriss May 18 '12 at 15:13
  • put things in perspective really useful edit ... that s a wrap ... im gonna use nosql... now the question is couch or mongo ...lol – Lunatikzx May 18 '12 at 15:52

Not the answer you're looking for? Browse other questions tagged or ask your own question.