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?)

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.